Re: Tweaking the planner's heuristics for small/empty tables

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Tweaking the planner's heuristics for small/empty tables
Дата
Msg-id 201107131912.p6DJCD403395@momjian.us
обсуждение исходный текст
Ответ на Tweaking the planner's heuristics for small/empty tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Tweaking the planner's heuristics for small/empty tables
Список pgsql-hackers
Tom Lane wrote:
> Another reason not to rely completely on the auto-analyze update path is
> that it doesn't work for temp tables, since autovac can't access another
> session's temp tables.  It's also worth noting that auto-analyze will
> never kick in at all for tables of less than about 60 rows, unless there
> is update/delete traffic on them.

We could exclude temp tables in the 'if' test.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Need help understanding pg_locks
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_class.relistemp