Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Stark
Subject Re: More thoughts about planner's cost estimates
Date
Msg-id 87mzcsbo5k.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: More thoughts about planner's cost estimates  (Hannu Krosing <hannu@skype.net>)
Responses Re: More thoughts about planner's cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hannu Krosing <hannu@skype.net> writes:

> Ühel kenal päeval, L, 2006-06-03 kell 10:43, kirjutas Jim Nasby:
> 
> > Might also be worth adding analyze delay settings, ala  
> > vacuum_cost_delay.
> 
> Actually we should have delay settings for all potential
> (almost-)full-scan service ops, - VACUUM, ANALYSE, CREATE INDEX, ADD
> CONSTRAINT, maybe more - so that there would be better chances of
> running those on busy databases without disastrous effects.

What about UPDATE and DELETE and for that matter SELECT?


-- 
greg

pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: 'CVS-Unknown' buildfarm failures?
Next
From: Greg Stark
Date:
Subject: Re: Possible TODO item: copy to/from pipe