Am Montag, 16. Juli 2007 16:19 schrieben Sie: > Janning Vygen <vygen@xxxxxxxxxxxx> writes: > > After this i create the index and it took 10 hours just for one index > > (primary key). I have 100.000.000 rows with one PK (int8), two integer > > data values, and two FK (int8) > > What PG version is this? We did a fair amount of work on sort speed > for 8.2. sorry for forgetting the version number. it is 8.1. i think i got it fixed as i saw that i pushed my maintenance_work_mem too high. It was higher than physical ram :-( i don't know what happens but i guess it is swapping all the time i will try it again - with correct maintenance_work_mem setting - with 8.2 as your statement sounds great. i never thought pg8.1 could be improved anyway as i was already totally satisfied with its performance. i will ask my second question in a different thread. kind regards, janning
