Am Montag, 16. Juli 2007 16:19 schrieben Sie:
> Janning Vygen <vygen@planwerk6.de> 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