Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: qsort again (was Re: Strange Create Index behaviour)
- From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- To: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: qsort again (was Re: Strange Create Index behaviour)
- Date: Thu, 16 Feb 2006 09:52:46 +0800
Ouch! That confirms my problem. I generated the random test case because it was easier than including the dump of my tables, but you can appreciate that tables 20 times the size are basically crippled when it comes to creating an index on them.
I have to say that I restored a few gigabyte dump on freebsd the other day, and most of the restore time was in index creation - I didn't think too much of it though at the time. FreeBSD 4.x.
Chris
- References:
- Strange Create Index behaviour
- From: Gary Doades
- Re: Strange Create Index behaviour
- From: Tom Lane
- Re: Strange Create Index behaviour
- From: Tom Lane
- Re: Strange Create Index behaviour
- From: Gary Doades
- qsort again (was Re: Strange Create Index behaviour)
- From: Tom Lane
- Re: qsort again (was Re: Strange Create Index behaviour)
- From: Gary Doades
- Strange Create Index behaviour
- Prev by Date: Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour)
- Next by Date: Re: Strange Create Index behaviour
- Previous by thread: Re: [HACKERS] qsort again (was Re: Strange Create Index
- Next by thread: Re: qsort again (was Re: Strange Create Index
- Indexes: