Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performance/Maintenance test result collection
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Chris Mckenzie <Chris(dot)McKenzie(at)entrust(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Performance/Maintenance test result collection
- Date: Wed, 17 May 2006 14:24:40 -0500
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(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- References:
- Performance/Maintenance test result collection
- From: Chris Mckenzie
- Performance/Maintenance test result collection
- Prev by Date: Re: Optimizer: limit not taken into account
- Next by Date: Re: [HACKERS] Big IN() clauses etc : feature proposal
- Previous by thread: Performance/Maintenance test result collection
- Next by thread: Re: Performance/Maintenance test result collection
- Indexes: