Re: best way to run maintenance script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.)

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux