Horton
Menu

Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Gary Doades <gpd@gpdnet.co.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org
Date: 2006-02-16T01:52:46Z
Lists: pgsql-hackers, pgsql-performance 
> 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