Semyon Reyfman wrote: > 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.
It isn't. It also doesn't create any indexes, which you might want to do before analyze. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
