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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
