Am Donnerstag, 19. April 2007 schrieb Sergey Tsukinovsky:
> 2. What would be the recommended set of parameters to tune up in order
> to improve the performance over the time, instead of considering an
> option to vacuum every 30 minutes or so?
> 3. Is it safe to run 'vacuum' as frequently as every 15-30 minutes?
> 4. Suggestions?
Do yourself a favor and upgrade at least to 8.1.x and use autovacuum.
In response to
pgsql-performance by date
|Next:||From: Heikki Linnakangas||Date: 2007-04-23 09:46:45|
|Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command|
|Previous:||From: Michael Fuhr||Date: 2007-04-23 08:45:58|
|Subject: Re: Help with TOAST Compression|