X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 501239FA2C8 for ; Wed, 17 May 2006 16:24:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94373-03 for ; Wed, 17 May 2006 16:24:43 -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 EB3719F944D for ; Wed, 17 May 2006 16:24:42 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id CC8D656427; Wed, 17 May 2006 14:24:41 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 17 May 2006 14:24:40 -0500 Date: Wed, 17 May 2006 14:24:40 -0500 From: "Jim C. Nasby" To: Chris Mckenzie Cc: pgsql-performance@postgresql.org Subject: Re: Performance/Maintenance test result collection Message-ID: <20060517192440.GX26212@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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:060517:chris.mckenzie@entrust.com::3AQc/ekPSYXcN0+W:00000000000 000000000000000000000000DXMp X-Hashcash: 1:20:060517:pgsql-performance@postgresql.org::uzsxFgz/sD654gY1:00000 0000000000000000000000004h/7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/372 X-Sequence-Number: 19159 On Wed, May 17, 2006 at 01:50:22PM -0400, Chris Mckenzie wrote: > Hi. > > I'm trying to plan for a performance test session where a large database is > subject to regular hits from my application while both regular and full > database maintenance is being performed. The idea is to gain a better idea > on the impact maintenance will have on regular usage, and when to reasonably > schedule both regular and full maintenance. What do you mean by "regular and full maintenance"? Do you mean VACUUM FULL? If you're vacuuming appropriately you shouldn't have any need to ever VACUUM FULL... -- 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