Re: More thoughts about planner's cost estimates - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: More thoughts about planner's cost estimates
Date
Msg-id 0B801F97-877B-49FE-88DA-8C0083FA0CE5@pervasive.com
Whole thread Raw
In response to Re: More thoughts about planner's cost estimates  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Responses Re: More thoughts about planner's cost estimates  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: 'CVS-Unknown' buildfarm failures?
Next
From: Greg Stark
Date:
Subject: Re: COPY (query) TO file