Stefan Kaltenbrunner <stefan@kaltenbrunner.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