Re: best way to run maintenance script - Mailing list pgsql-performance

From Peter Eisentraut
Subject Re: best way to run maintenance script
Date
Msg-id 200803161911.49571.peter_e@gmx.net
Whole thread Raw
In response to best way to run maintenance script  (Vinubalaji Gopal <vgopal@abaca.com>)
List pgsql-performance
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.)

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Next
From: Craig James
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10