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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
