Excerpts from Little, Douglas's message of jue oct 28 09:39:19 -0300 2010: > Hi, > We're having to vacuum full the system tables everyday due to the number of temp table drop/creates. Seems to me that you're solving the wrong problem. I think you should be doing very frequent lazy vacuum (not full) of certain system catalogs to prevent bloat. That way you don't need the maintenance to be done with exclusive locks. -- Ãlvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
