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

Re: More thoughts about planner's cost estimates

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Todd A(dot) Cook <tcook(at)blackducksoftware(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: More thoughts about planner's cost estimates
Date: 2006-06-03 15:43:39
Message-ID: (view raw or whole thread)
Lists: 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  

In response to


pgsql-hackers by date

Next:From: Greg StarkDate: 2006-06-03 15:45:52
Subject: Re: COPY (query) TO file
Previous:From: Tom LaneDate: 2006-06-03 15:27:03
Subject: Re: Faster Updates

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