From: | Vinubalaji Gopal <vgopal(at)abaca(dot)com> |
---|---|
To: | "Pgsql-Performance ((E-mail))" <pgsql-performance(at)postgresql(dot)org> |
Subject: | best way to run maintenance script |
Date: | 2008-03-15 01:00:21 |
Message-ID: | 1205542821.12661.16.camel@vinu-ubuntu.abaca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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?
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)
--
Vinu
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-03-15 01:37:22 | Re: best way to run maintenance script |
Previous Message | Joshua D. Drake | 2008-03-15 00:32:35 | Re: best way to run maintenance script |