| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Thorne, Francis" <thornef(at)cromwell(dot)co(dot)uk> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Slow adding Large Indexes |
| Date: | 2009-07-27 14:00:05 |
| Message-ID: | 9766.1248703205@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Thorne, Francis" <thornef(at)cromwell(dot)co(dot)uk> writes:
> The problem I have is that it takes around 15 mins to insert the data
> into the table which is a massive improvement from the old server but it
> then takes 40 mins to create two indexes one 1GB index and another that
> is a 2GB index this is considerably slower than on the older server.
If these are indexes on textual data, maybe you accidentally changed
from C locale to some other locale. All the other ones are slower to
compare text strings, sometimes massively so.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-27 14:31:17 | Re: Problem to compiling with SunStudio |
| Previous Message | monika.koenig | 2009-07-27 13:52:36 | Problem to compiling with SunStudio |