Re: createing indexes on large tables and int8

Am Montag, 16. Juli 2007 16:19 schrieben Sie:
> Janning Vygen <vygen(at)planwerk6(dot)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