Postgres Pro
Downloads
Home   >   mailing lists

Re: Automatic analyze on select into - Mailing list pgsql-performance

From Tom Lane
Subject Re: Automatic analyze on select into
Date
Msg-id 8335.1051373934@sss.pgh.pa.us
Whole thread Raw
In response to Automatic analyze on select into  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Automatic analyze on select into  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-performance
Tree view 
"Jim C. Nasby" <jim@nasby.net> writes:
> So, question is, would it make sense to automatically do an analyze
> after/during a SELECT INTO?

I don't think so.  Very often, temp tables are small and only used for
one or two operations anyway --- so the cost of an ANALYZE wouldn't be
repaid.  If ANALYZE would be useful, the user can issue one.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Automatic analyze on select into
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Automatic analyze on select into