On Jun 2, 2006, at 5:24 PM, Todd A. Cook wrote:
Josh Berkus wrote:
Greg, Tom,
But for most users analyze doesn't really have to run as often as
vacuum. One sequential scan per night doesn't seem like that big
a deal
to me.
Clearly you don't have any 0.5 TB databases.
Perhaps something like "ANALYZE FULL"? Then only those who need the
more precise statistics would pay the cost for a full scan.
Might also be worth adding analyze delay settings, ala
vacuum_cost_delay.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings