From: Scott Marlowe <scott.marlowe@gmail.com>
To: BRAHMA PRAKASH TIWARI <prakashr2n5@gmail.com>
Cc: Francesco Andreozzi <francesco.andreozzi@gamestorm.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: tuning tips, speed problem
Date: Mon, 19 Jan 2009 08:54:30 -0700
Message-ID: <dcc563d10901190754o4c8f74eeidad1b52cf2e73356@mail.gmail.com> (raw)
In-Reply-To: <2acc2c820901190435m4062f8d3v1e6099f32ed009af@mail.gmail.com>
References: <20090116161802.v6tj5jmhw0c80sow@webmail.gamestorm.it>
<2acc2c820901190435m4062f8d3v1e6099f32ed009af@mail.gmail.com>
On Mon, Jan 19, 2009 at 5:35 AM, BRAHMA PRAKASH TIWARI
<prakashr2n5@gmail.com> wrote:
> Hi Francesco
>
> most probabely this is due to the auto vacuum option on and if auto vacuum
> is on then the in condition of high transaction on database it slows the
> speed of the hole database.Set it off in postgres.conf and vacuum and
> reindex transactional tables manualy with in every two million
> transactions.
> like
> vacuum full <table name>;
> reindex table <table name>;
Except for certain circumstances vacuum full should be avoided and
vacuum (regular) used in its place until it is proven ineffective.
Also, it is usually far better to turn up the
autovacuum_vacuum_cost_delay to 10 or 20 and let autovacuum do its
job. Unless you have a very starved I/O subsystem autovacuum with
cost delay of 20 should have almost no noticeable effect on a
transactional database.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, prakashr2n5@gmail.com, francesco.andreozzi@gamestorm.it
Subject: Re: tuning tips, speed problem
In-Reply-To: <dcc563d10901190754o4c8f74eeidad1b52cf2e73356@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox