| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: performance of IN (subquery) |
| Date: | 2004-08-27 08:36:29 |
| Message-ID: | 412EF28D.7030707@bigfoot.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Suela Fernández | 2004-08-27 08:37:05 | Re: copy a database |
| Previous Message | Kristian Rink | 2004-08-27 08:09:43 | Re: postgresql, odbc and escape characters? |