Stefan Kaltenbrunner <stefan@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
