best way to run maintenance script

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

Responses

Browse pgsql-performance by date

  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