Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group