On Wed, Oct 27, 2010 at 3:44 PM, Justin Pitts <justinpitts@xxxxxxxxx> wrote: >> Jason Pitts: >> RE: changing default_statistics_target (or via ALTER TABLE SET STATS) >> not taking effect until ANALYZE is performed. >> >> I did already know that, but it's probably good to put into this >> thread. However, you'll note that this is a temporary table created at >> the beginning of a transaction. >> > > ( giving up on replying to the group; the list will not accept my posts ) Evidently it's accepting some of them... > I've been following the thread so long I had forgotten that. I rather > strongly doubt that analyze can reach that table's content inside that > transaction, if you are creating, populating, and querying it all > within that single transaction. Actually I don't think that's a problem, at least for a manual ANALYZE. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
