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 th
"Vinubalaji Gopal" <[EMAIL PROTECTED]> writes:
> On Fri, 2008-03-14 at 18:37 -0700, Tom Lane wrote:
>> That's only a little bit better. Read about all the bug fixes you're
>
> Sure - will eventually upgrade it sometime - but it has to wait for
> now :(
Waiting for one of those bugs to bite you i
>
> I think you will find if you do it the right way, which is to say the
> way that it is meant to be done with the configurable options, your
> life will be a great deal more pleasant than some one off hack.
>
yeah I agree. The pg_maintanence script which calls vacuum and analyze
is the one o
On Fri, 2008-03-14 at 18:37 -0700, Tom Lane wrote:
> That's only a little bit better. Read about all the bug fixes you're
Sure - will eventually upgrade it sometime - but it has to wait for
now :(
--
Vinu
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 14 Mar 2008 17:51:52 -0800
Vinubalaji Gopal <[EMAIL PROTECTED]> wrote:
> Hi Joshua,
>
> > 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-aut
Vinubalaji Gopal <[EMAIL PROTECTED]> writes:
>> If you are truly running 8.0 and not something like 8.0.15 vacuum is
>> the least of your worries.
> Its 8.0.4.
That's only a little bit better. Read about all the bug fixes you're
missing at
http://www.postgresql.org/docs/8.0/static/release.html
Hi Joshua,
> 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
I am checking it out. Seems to be a nice option for vacuum - but wish
there was a way to change the delete priority or I will
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 14 Mar 2008 17:00:21 -0800
Vinubalaji Gopal <[EMAIL PROTECTED]> 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
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 cons
