Re: pg_dump ANALYZE statements

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: pg_dump ANALYZE statements
Дата
Msg-id 20070122232014.GT64372@nasby.net
обсуждение исходный текст
Ответ на pg_dump ANALYZE statements  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: pg_dump ANALYZE statements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Jan 22, 2007 at 03:40:17PM +0000, Simon Riggs wrote:
> This would add a table-specific ANALYZE statement following each table's
> actions.

It'd probably be best to put it before any index creating activities,
since there's a better chance of everything from the table being in
shared buffers.

Better yet would be if COPY could analyze data as it was loaded in...
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [GENERAL] Autovacuum Improvements
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [pgsql-patches] Win32 WEXITSTATUS too