Greg,
Things I was hoping for some input on:
-Using default_stats_target=100 doesn't seem controversial anymore,
which makes we wonder if it makes sense to restore the original DW
suggestion of 400 Josh suggested?
I'm going to back off from this. Following our discussion, I did some
testing on DWs belonging to my clients. The amount of time required to
ANALYZE 20m rows of a large text field at 400 is significant, as is the
bulk-out of the stats table.
Instead, I'm writing a script which increases stats for all *indexed*
columns under a named size to a user-specified level. When it's ready,
I'll add it to pgTune.
So for DW, go for 100. Not 400, though.
--Josh Berkus
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
