From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-performance@postgresql.org
Cc: Vinubalaji Gopal <vgopal@abaca.com>
Subject: Re: best way to run maintenance script
Date: Sun, 16 Mar 2008 19:11:48 +0100
Message-ID: <200803161911.49571.peter_e@gmx.net> (raw)
In-Reply-To: <1205542821.12661.16.camel@vinu-ubuntu.abaca>
References: <1205542821.12661.16.camel@vinu-ubuntu.abaca>
Vinubalaji Gopal wrote:
> I tried using the nice command (Linux system) on the maintenance script
> - it did not have any effect - guess it does not change the niceness of
> the postgresql vacuum process.
You are probably looking for the command ionice. nice only affects the CPU
priority, and that is usually not the primary problem for vacuum. (And yes,
you need to nice the server process, not the client script.)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: peter_e@gmx.net, vgopal@abaca.com
Subject: Re: best way to run maintenance script
In-Reply-To: <200803161911.49571.peter_e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox