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
In response to
pgsql-hackers by date
|Next:||From: Greg Stark||Date: 2006-06-03 15:45:52|
|Subject: Re: COPY (query) TO file|
|Previous:||From: Tom Lane||Date: 2006-06-03 15:27:03|
|Subject: Re: Faster Updates |