Postgres Pro
Downloads
Home   >   mailing lists

Re: Unusual table size and very slow inserts - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Unusual table size and very slow inserts
Date
Msg-id dcc563d11002021306v41ca19bbmea617e5b8a691056@mail.gmail.com
Whole thread Raw
In response to Re: Unusual table size and very slow inserts  (Ivano Luberti <luberti@archicoop.it>)
List pgsql-general
Tree view 
On Tue, Feb 2, 2010 at 1:45 PM, Ivano Luberti <luberti@archicoop.it> wrote:
> In this table and all her sisters in the other schemas, records are only
> inserted and deleted. No update

same diff.  In pgsql an update equals a delete and an insert.  deleted
rows use up space just like former versions from an update.  If you're
deleting a lot of rows then you'll have a lot of bloat.

pgsql-general by date:

Previous
From: Ivano Luberti
Date:
Subject: Re: Unusual table size and very slow inserts
Next
From: Alvaro Herrera
Date:
Subject: Re: Questions on PostGreSQL Authentication mechanism...