On Tue, Feb 1, 2011 at 6:44 PM, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> wrote: > On 2/1/2011 6:03 PM, Andrew Dunstan wrote: >> >> Whether or not it's bad application design, it's ubiquitous, and we >> should make it work as best we can, IMNSHO. This often generates >> complaints about Postgres, and if we really plan for world domination >> this needs to be part of it. > > There are many other things to fix first. One of them would be optimizer > decisions when a temp table is involved. It would be pretty hard to make autoanalyze work on such tables without removing some of the performance benefits of having such tables in the first place - namely, the local buffer manager. But you could ANALYZE them by hand. -- 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
