From: "Anibal David Acosta" <aa@devshock.com>
To: "'Scott Marlowe'" <scott.marlowe@gmail.com>
Cc: <pgsql-performance@postgresql.org>
References: <000001cc6fda$7e55fd20$7b01f760$@devshock.com>
	<CAOR=d=17qPEx5O1W3jga8wknKvv+7O4u6JiugJS30vyciz3vBQ@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=17qPEx5O1W3jga8wknKvv+7O4u6JiugJS30vyciz3vBQ@mail.gmail.com>
Subject: Re: should i expected performance degradation over time
Date: Tue, 11 Oct 2011 15:20:12 -0300
Message-ID: <003001cc8842$6ced6ca0$46c845e0$@devshock.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQHsI1FKu/mxvl84UJ0Y4KoiPGDhvALrDJ2tlSDlLAA=
Content-Language: es-py

Do you know if check_postgresql.pl can run on windows (with perl =
installed)?

Because our postgres installation is running on a Windows 2008 R2 server =
but
can't find any tool like this for windows :(

Thanks!


-----Mensaje original-----
De: Scott Marlowe [mailto:scott.marlowe@gmail.com]=20
Enviado el: s=E1bado, 10 de septiembre de 2011 02:30 p.m.
Para: Anibal David Acosta
CC: pgsql-performance@postgresql.org
Asunto: Re: [PERFORM] should i expected performance degradation over =
time

On Sat, Sep 10, 2011 at 10:55 AM, Anibal David Acosta <aa@devshock.com>
wrote:
> Sometimes I read that postgres performance is degraded over the time=20
> and something people talk about backup and restore database solve the
problem.
>
> It is really true?

Yes and no.  If you let things get out of hand, a backup and restore may =
be
your best choice.

> I have postgres 9.0 on a windows machine with The autovacuum is ON

Good start

> Transactional table has about 4 millions of rows inserted per day.
>
> In the midnight all rows are moved to a historical table and in the=20
> historical table rows are about 2 months, any transaction older than 2 =

> months are deleted daily.

You should look into table partitioning then.  but as long as vacuum =
keeps
up you're probably still ok.  Look at the check_postgresql.pl script by =
the
same guy who wrote Bucardo.  It'll keep you advised of how much bloat =
your
tables have.

> So, my question is, if Should I expect same performance over time
(example:
> after 1 year) or should I expect a degradation and must implements=20
> come technics like backup restore every certain time?

If you maintain your db properly, performance should stay good.  If you
ignore bloat issues you might have some issues.