X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 212EE11F60AA for ; Thu, 20 Apr 2006 14:00:19 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.297 X-Spam-Level: X-Spam-Status: No, score=0.297 required=5 tests=[AWL=0.297] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 2rnrRS04HOkX for ; Thu, 20 Apr 2006 14:00:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 9573011F6224 for ; Thu, 20 Apr 2006 14:00:09 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id F25A056423; Thu, 20 Apr 2006 12:00:08 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 20 Apr 2006 12:00:07 -0500 Date: Thu, 20 Apr 2006 12:00:07 -0500 From: "Jim C. Nasby" To: Radovan Antloga Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: Performance decrease Message-ID: <20060420170007.GA49405@pervasive.com> References: <011b01c6648e$067ee170$1e4ba8c0@AR6> <18973.1145547701@sss.pgh.pa.us> <015801c66494$ee3d25c0$1e4ba8c0@AR6> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <015801c66494$ee3d25c0$1e4ba8c0@AR6> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060420:radovan.antloga@siol.net::6CFZ9w+qtQker2rJ:0000000000000 0000000000000000000000008VRx X-Hashcash: 1:20:060420:tgl@sss.pgh.pa.us::aheoylP2kiyNYiAg:00000000000000000000 0000000000000000000000006Di5 X-Hashcash: 1:20:060420:pgsql-performance@postgresql.org::IRdFs1jDYMU0IXS6:00000 0000000000000000000000000pXR X-Archive-Number: 200604/463 X-Sequence-Number: 18547 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