From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Michael Paesold <mpaesold(at)gmx(dot)at>, hubert depesz lubaczewski <depesz(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: problem with large maintenance_work_mem settings and |
Date: | 2006-03-05 11:30:14 |
Message-ID: | 440ACBC6.40707@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
>
>>>>forgot to mention that this is 8.1.3 compiled from source.
>>>
>>>See the discussion starting here:
>>>http://archives.postgresql.org/pgsql-hackers/2006-02/msg00590.php
>
>
>>I was following this thread - and it was partly a reason why I'm playing
>>with that(the CREATE INDEX on that table finished after about 12 hours
>>with a bit less 2GB for maintenance_work_mem(for comparision it took me
>>only about 2,5hours to create this table) .
>
>
> It would be interesting to try the same test with CVS tip to see if the
> sorting improvements Simon and I made over the past few weeks help much.
playing with CVS tip right now, it is a bit faster for both the initial
bulkloading (about 5%) and for the CREATE INDEX itself (11h30min vs
11h54min) though not a dramatic improvement.
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | mark | 2006-03-05 13:30:55 | Re: Copyright |
Previous Message | Matteo Beccati | 2006-03-05 11:02:19 | Re: Copyright |