Re: Unusual table size and very slow inserts

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ivano Luberti <luberti(at)archicoop(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unusual table size and very slow inserts
Date: 2010-02-02 21:06:15
Message-ID: dcc563d11002021306v41ca19bbmea617e5b8a691056@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 2, 2010 at 1:45 PM, Ivano Luberti <luberti(at)archicoop(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-02-02 21:22:19 Re: Questions on PostGreSQL Authentication mechanism...
Previous Message Ivano Luberti 2010-02-02 20:45:46 Re: Unusual table size and very slow inserts