Re: performance of IN (subquery) - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: performance of IN (subquery)
Date
Msg-id 412EF28D.7030707@bigfoot.com
Whole thread Raw
In response to Re: performance of IN (subquery)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:


> 2. Instability of plans.  Right now, the planner will not change plans
>    underneath you --- you have to issue an explicit VACUUM or ANALYZE
>    to change the terms of discussion.  That would stop being true if
>    physical file size were always taken into account.  Maybe this is a
>    problem, or maybe it isn't ... as someone who likes to be able to
>    debug planner behavior without actually creating umpteen-gig test
>    tables, my world view may be a bit skewed ...

Did you forgot the autovacuum daemon ? I didn't see anyone bitten or
paged during the night for autovacuum daemon job.


Regards
Gaetano Mendola



pgsql-general by date:

Previous
From: David Suela Fernández
Date:
Subject: Re: copy a database
Next
From: Oliver Elphick
Date:
Subject: Re: Creating Functions in Separate Schema