Postgres Pro
Downloads
Home   >   mailing lists

Re: server space increasing very fast but transaction are very low - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: server space increasing very fast but transaction are very low
Date
Msg-id 8763n1jcdm.fsf@mnc.ch
Whole thread Raw
In response to Re: server space increasing very fast but transaction are very low  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: server space increasing very fast but transaction are very low
Next
From: "Helio Campos Mello de Andrade"
Date:
Subject: Re: PostgreSQL OR performance