Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group