Re: Automatic analyze on select into

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)nasby(dot)net
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Automatic analyze on select into
Date: 2003-04-26 16:18:54
Message-ID: 8335.1051373934@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim C. Nasby" <jim(at)nasby(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2003-04-26 18:16:25 Re: Automatic analyze on select into
Previous Message Jim C. Nasby 2003-04-26 15:15:37 Automatic analyze on select into