Re: server space increasing very fast but transaction are very low

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: server space increasing very fast but transaction are very low
Date: 2008-11-06 11:57:09
Message-ID: 8763n1jcdm.fsf@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Richard Huxton <dev 'at' archonet.com> writes:

> I'm guessing what you've got is a table that's not being vacuumed
> because you've had a transaction that's been open for weeks.

Or because no vacuuming at all is performed on this table (no
autovacuum and no explicit VACUUM on database or table).

--
Guillaume Cottenceau

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Swathi S 2008-11-07 06:04:05 Ideal way to upgrade to postgres 8.3 with less downtime
Previous Message Richard Huxton 2008-11-06 11:04:30 Re: server space increasing very fast but transaction are very low

Browse pgsql-performance by date

  From Date Subject
Next Message Helio Campos Mello de Andrade 2008-11-06 12:26:20 Re: PostgreSQL OR performance
Previous Message Richard Huxton 2008-11-06 11:04:30 Re: server space increasing very fast but transaction are very low