Skip site navigation (1) Skip section navigation (2)

Re: More thoughts about planner's cost estimates

From: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: More thoughts about planner's cost estimates
Date: 2006-06-02 22:24:33
Message-ID: 4480BAA1.9040907@blackducksoftware.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

-- todd

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-06-02 22:36:40
Subject: Re: More thoughts about planner's cost estimates
Previous:From: Josh BerkusDate: 2006-06-02 22:15:43
Subject: Re: More thoughts about planner's cost estimates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group