Re: new to postgres (and db management) and performance already a problem :-(

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: 2006-01-17 13:28:59
Message-ID: 20060117132859.GD21092@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jan 17, 2006 at 09:14:27AM +0100, Antoine wrote:
> think about it - we do very little removing, pretty much only inserts and
> selects. I will give it a vacuum full and see what happens.

UPDATES? Remember that, in Postgres, UPDATE is effectively DELETE +
INSERT (from the point of view of storage, not the point of view of
the user).

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-01-17 13:33:41 Re: new to postgres (and db management) and performance
Previous Message Alvaro Herrera 2006-01-17 13:19:58 Re: Autovacuum / full vacuum