[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] postgres: 100% CPU utilization
From: Mario Weilguni <mweilguni () sime ! com>
Date: 2007-04-23 8:53:38
Message-ID: 200704231053.38952.mweilguni () sime ! com
[Download RAW message or body]
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?
No problem.
>
> 4. Suggestions?
Do yourself a favor and upgrade at least to 8.1.x and use autovacuum.
Best regards
Mario Weilguni
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic