| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4 |
| Date: | 2009-06-19 18:17:49 |
| Message-ID: | 12351.1245435469@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> Tom Lane wrote:
>> If you have time to repeat the experiments, it would be interesting to
>> see what happens with consistent default_statistics_target across 8.3
>> and 8.4.
> given that this was likely a single-thread restore and therefor wal
> logged I wonder if the 206min one might be affected by the issue
> discussed here
> http://archives.postgresql.org/pgsql-hackers/2009-06/msg01133.php
It might be, but the current theory about that (ie that it's the
bulkwrite patch doing it) doesn't explain the interaction with
autovacuum on/off. I'd still like to hear whether changing the stats
target changes Todd's results.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2009-06-19 18:23:20 | looping over a small record set over and over in a function |
| Previous Message | Stefan Kaltenbrunner | 2009-06-19 17:59:38 | Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4 |