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

From Todd A. Cook
Subject Re: More thoughts about planner's cost estimates
Date
Msg-id 4480BAA1.9040907@blackducksoftware.com
Whole thread Raw
In response to Re: More thoughts about planner's cost estimates  (Josh Berkus <josh@agliodbs.com>)
Responses Re: More thoughts about planner's cost estimates  (Jim Nasby <jnasby@pervasive.com>)
List 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


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: More thoughts about planner's cost estimates
Next
From: "Mark Woodward"
Date:
Subject: Re: COPY (query) TO file