Re: Performance decrease - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Performance decrease
Date
Msg-id 20060420170007.GA49405@pervasive.com
Whole thread Raw
In response to Re: Performance decrease  ("Radovan Antloga" <radovan.antloga@siol.net>)
List pgsql-performance
On Thu, Apr 20, 2006 at 06:10:21PM +0200, Radovan Antloga wrote:
> I have once or twice a month update on many records (~6000) but
> not so many. I did not expect PG would have problems with
> updating 15800 records.

And generally speaking, it doesn't. But you do need to ensure that
you're vacuuming the database frequently enough. Autovacuum is a good
way to do that.

> My test was on Windows XP SP2.
> I have AMD 64 2.1 GHz cpu with
> 1GB ram.

One think to keep in mind is that the windows code is rather new, so it
is possible to find some performance issues there.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Quick Performance Poll
Next
From: "Mikael Carneholm"
Date:
Subject: Hardware: HP StorageWorks MSA 1500