"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
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2003-04-26 18:16:25|
|Subject: Re: Automatic analyze on select into|
|Previous:||From: Jim C. Nasby||Date: 2003-04-26 15:15:37|
|Subject: Automatic analyze on select into|