| From: | "Jim C(dot) 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: | 2006-05-17 19:24:40 |
| Message-ID: | 20060517192440.GX26212@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2006-05-17 19:40:59 | Re: [PERFORM] Performance incorporate with JReport |
| Previous Message | Jim C. Nasby | 2006-05-17 19:20:34 | Re: Optimizer: limit not taken into account |