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.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-06-02 22:36:40|
|Subject: Re: More thoughts about planner's cost estimates |
|Previous:||From: Josh Berkus||Date: 2006-06-02 22:15:43|
|Subject: Re: More thoughts about planner's cost estimates|