From: | mljv(at)planwerk6(dot)de |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: createing indexes on large tables and int8 |
Date: | 2007-07-17 15:33:29 |
Message-ID: | 200707171733.29243.mljv@planwerk6.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2007-07-17 15:39:50 | Re: yet another image: db or filesystem ? question |
Previous Message | Richard Huxton | 2007-07-17 15:31:34 | Re: yet another image: db or filesystem ? question |