From: scott.marlowe <scott.marlowe@ihs.com>
To: Francisco Reyes <lists@natserv.com>
Cc: Medi Montaseri <medi.montaseri@intransa.com>
Cc: pgsql General List <pgsql-general@postgresql.org>
Subject: Re: Closing inactive connections OR user connections limits
Date: Wed, 20 Nov 2002 12:32:40 -0700 (MST)
Message-ID: <Pine.LNX.4.33.0211201229040.21101-100000@css120.ihs.com> (raw)
In-Reply-To: <20021120135345.S30106-100000@zoraida.natserv.net>
On Wed, 20 Nov 2002, Francisco Reyes wrote:
> On Wed, 20 Nov 2002, Medi Montaseri wrote:
>
> > In 7.2, you can run the vacuum in parallel with other database activities...
>
> As far as I know this is not the case for "vacuum full".
The thing that blocks vacuum full are pending transactions. If the
connections aren't holding open a transaction the vacuum full will run
just fine.
For most folks, daily / hourly vacuums (not full vacuums) in 7.2 are
all you need, with a weekly or so vacuum full.
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-sql@postgresql.org
Cc: scott.marlowe@ihs.com, lists@natserv.com, medi.montaseri@intransa.com, pgsql-general@postgresql.org
Subject: Re: Closing inactive connections OR user connections limits
In-Reply-To: <Pine.LNX.4.33.0211201229040.21101-100000@css120.ihs.com>
* 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