On 2/26/15 5:23 PM, Alvaro Herrera wrote: > 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. Is it necessary to create indexes before analyzing? I usually do, just to be safe, but I thought statistics were based solely on sampling of the heap. -- - David Steele david@xxxxxxxxxxxxx
Attachment:
signature.asc
Description: OpenPGP digital signature
