From: Alvaro Herrera <alvherre@commandprompt.com>
To: Little, Douglas <douglas.little@orbitz.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Forced quiesce
Date: Mon, 08 Nov 2010 12:05:24 -0300
Message-ID: <1289228619-sup-7871@alvh.no-ip.org> (raw)
In-Reply-To: <8585BA53443004458E0BAA6134C5A7FB4773E160@EGEXCMB01.oww.root.lcl>
References: <8585BA53443004458E0BAA6134C5A7FB4773E160@EGEXCMB01.oww.root.lcl>
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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, douglas.little@orbitz.com
Subject: Re: Forced quiesce
In-Reply-To: <1289228619-sup-7871@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox