Re: [HACKERS] More thoughts about planner's cost estimates

[Greg Stark]

Hannu Krosing <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match