-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 14 Mar 2008 17:00:21 -0800 Vinubalaji Gopal <vgopal@xxxxxxxxx> wrote: > Hi all, > I have been searching for the best way to run maintenance scripts > which does a vacuum, analyze and deletes some old data. Whenever the > maintenance script runs - mainly the pg_maintenance --analyze script - > it slows down postgresql inserts and I want to avoid that. The system > is under constant load and I am not interested in the time taken to > vacuum. Is there a utility or mechanism in postgresql which helps in > reducing priority of maintenance queries? You can use parameters such as vacuum_cost_delay to help this... see the docs: http://www.postgresql.org/docs/8.3/static/runtime-config-autovacuum.html > > Is writing a postgresql C function and setting the priority of process > the only way to change the priority of the maintenance script or is > there a better way. > http://weblog.bignerdranch.com/?p=11 > > 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. > > (I am running Postgresql 8.0 on a Linux) If you are truly running 8.0 and not something like 8.0.15 vacuum is the least of your worries. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL political pundit | Mocker of Dolphins -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH2xkkATb/zqfZUUQRAsFxAJ422xFUGNwJZZVS47SwM9HJEYrb/gCePESL YZFM27b93ylhy5TuE2MCcww= =2Zpp -----END PGP SIGNATURE----- -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-performance
