ANALYZE after CREATE TABLE AS SELECT...

Поиск
Список
Период
Сортировка
От Semyon Reyfman
Тема ANALYZE after CREATE TABLE AS SELECT...
Дата
Msg-id 00ae01d051e4$f0849b00$d18dd100$@gmail.com
обсуждение исходный текст
Ответы Re: ANALYZE after CREATE TABLE AS SELECT...  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general

Hi,

 

When I create a table with “CREATE TABLE name AS SELECT…” statement and immediately afterward use this new table in a query does it make sense to run ANALYZE on the table in between?  It appears that postgres should be able to collect very detailed statistics while emitting the table but I am not sure if this is done.

 

Thanks

 

Simon

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

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: Triggers and scalability in high transaction tables.
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Triggers and scalability in high transaction tables.