ANALYZE after CREATE TABLE AS SELECT...

From: "Semyon Reyfman" <reyfmans(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ANALYZE after CREATE TABLE AS SELECT...
Date: 2015-02-26 16:54:49
Message-ID: 00ae01d051e4$f0849b00$d18dd100$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MattF 2015-02-26 17:13:03 Triggers on foreign Postgres 9.3 tables in Postgres 9.4
Previous Message Tim Smith 2015-02-26 16:33:36 Re: "JSON does not support infinite date values"