Re: performance of IN (subquery)

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: performance of IN (subquery)
Дата
Msg-id 412EF28D.7030707@bigfoot.com
обсуждение исходный текст
Ответ на Re: performance of IN (subquery)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: David Suela Fernández
Дата:
Сообщение: Re: copy a database
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Creating Functions in Separate Schema