From: Scott Marlowe <scott.marlowe@gmail.com>
To: Fabricio <fabrixio1@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Recommend dba maintenance tasks on a regular bases
Date: Fri, 12 Sep 2008 13:55:23 -0600
Message-ID: <dcc563d10809121255h7675a5e3hf0019e81974fd3ff@mail.gmail.com> (raw)
In-Reply-To: <BLU103-W48E4A0BE4644FCF0BDCAA3FE510@phx.gbl>
References: <200809121149.46137.barbara@turbocorp.com>
<20080912164019.GD2171@commandprompt.com>
<BLU103-W48E4A0BE4644FCF0BDCAA3FE510@phx.gbl>
On Fri, Sep 12, 2008 at 12:51 PM, Fabricio <fabrixio1@hotmail.com> wrote:
>
> I have a reindex of my databases periodically
>
> Sorry for the English translation of google
> I have PostgreSQL 8.1.x
> The databases that we have has many updates and were being slow, revising
> found that some index were bigger than it should be, did not agree to the
> size of the table. I made a reindex of the table and consultation is his
> much faster and the index remained very small.
> We therefore began a scheduled task that reidex my batadase periodically.
This is generally a sign you aren't vacuuming aggresively enough.
some usage patterns, however, lend themselves to off hours vacuuming
instead of during the day. If your machine doesn't have enough
bandwidth to handle vacuuming during the day, then it's probably
better in the long run to look at faster I/O subsystems.
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, fabrixio1@hotmail.com
Subject: Re: Recommend dba maintenance tasks on a regular bases
In-Reply-To: <dcc563d10809121255h7675a5e3hf0019e81974fd3ff@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