Re: VERY slow after many updates - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: VERY slow after many updates
Date
Msg-id 1132591417.28788.7.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: VERY slow after many updates  ("Alex Wang" <alex@alexwang.com>)
List pgsql-performance
On Sat, 2005-11-19 at 06:29, Alex Wang wrote:
> Great infomation. I didn't know that update is equal to delete+insert in
> Postgres. I would be more careful on designing the database access method in
> this case.

Just make sure you have regular vacuums scheduled (or run them from
within your app) and you're fine.

pgsql-performance by date:

Previous
From: Alan Stange
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: "Luke Lonergan"
Date:
Subject: Re: Hardware/OS recommendations for large databases (