Re: VERY slow after many updates

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Alex Wang <alex(at)alexwang(dot)com>
Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: VERY slow after many updates
Date: 2005-11-21 16:43:38
Message-ID: 1132591417.28788.7.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2005-11-21 18:06:48 Re: Hardware/OS recommendations for large databases (
Previous Message Alan Stange 2005-11-21 14:57:59 Re: Hardware/OS recommendations for large databases (