Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E9ACAB5DC1E for ; Sat, 10 Sep 2011 14:03:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 87849-10 for ; Sat, 10 Sep 2011 17:03:01 +0000 (UTC) X-Greylist: delayed 00:07:40.793275 by SQLgrey-1.7.6 Received: from mail-yi0-f46.google.com (mail-yi0-f46.google.com [209.85.218.46]) by mail.postgresql.org (Postfix) with ESMTP id 7305AB5DC19 for ; Sat, 10 Sep 2011 14:03:01 -0300 (ADT) Received: by yie30 with SMTP id 30so1683310yie.19 for ; Sat, 10 Sep 2011 10:03:01 -0700 (PDT) Received: by 10.150.8.11 with SMTP id 11mr475198ybh.215.1315673720254; Sat, 10 Sep 2011 09:55:20 -0700 (PDT) Received: from AnibalVAIO (host-1-30.b9.cvc.com.py [186.2.200.30]) by mx.google.com with ESMTPS id u31sm273410ybu.24.2011.09.10.09.55.17 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 10 Sep 2011 09:55:18 -0700 (PDT) From: "Anibal David Acosta" To: Subject: should i expected performance degradation over time Date: Sat, 10 Sep 2011 12:55:46 -0400 Message-ID: <000001cc6fda$7e55fd20$7b01f760$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CC6FB8.F74595A0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Acxv2PQmuYgvE3ubQOC0iy0cyA0eiA== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.584 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, SARE_MILLIONSOF=0.315 X-Spam-Level: X-Archive-Number: 201109/102 X-Sequence-Number: 44878 This is a multipart message in MIME format. ------=_NextPart_000_0001_01CC6FB8.F74595A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 some configuration tables And a couple of transactional table. 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 historical table rows are about 2 months, any transaction older than 2 months are deleted daily. 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 come technics like backup restore every certain time? Thanks!! ------=_NextPart_000_0001_01CC6FB8.F74595A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 some configuration tables

And a couple of transactional table.

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 historical table rows = are about 2 months, any transaction older than 2 months are deleted = daily.

 

 

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 come = technics like backup restore every certain time?

 

Thanks!!

 

 

 

 

 

 

------=_NextPart_000_0001_01CC6FB8.F74595A0--