Re: [PERFORM] should i expected performance degradation over time

2011-10-28 Thread Robert Haas
On Tue, Oct 11, 2011 at 2:20 PM, Anibal David Acosta wrote: > 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! It's written in Pe

Re: [PERFORM] should i expected performance degradation over time

2011-10-11 Thread Anibal David Acosta
viado el: sábado, 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 wrote: > Sometimes I read that postgres perfor

Re: [PERFORM] should i expected performance degradation over time

2011-09-10 Thread Scott Marlowe
On Sat, Sep 10, 2011 at 10:55 AM, Anibal David Acosta wrote: > Sometimes I read that postgres performance is degraded over the time 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

Re: [PERFORM] should i expected performance degradation over time

2011-09-10 Thread Andy Colson
On 09/10/2011 11:55 AM, Anibal David Acosta wrote: Sometimes I read that postgres performance is degraded over the time and something people talk about backup and restore database solve the problem. It is really true? I have postgres 9.0 on a windows machine with The autovacuum is ON I have s