Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TbPsm-0000XP-0w for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 06:03:28 +0000 Received: from rs133.luxsci.com ([72.32.115.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TbPsi-0002Gs-5n for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 06:03:26 +0000 Received: from GNANAM (NSG-Static-009.236.71.182.airtel.in [182.71.236.9] (may be forged)) (authenticated bits=0) by rs133.luxsci.com (8.13.8/8.13.8) with ESMTP id qAM63FKq006652; Thu, 22 Nov 2012 00:03:18 -0600 Reply-To: From: "Gnanakumar" To: "'Craig James'" Cc: References: <014101cdc7c9$a73bcb00$f5b36100$@zoniac.com> In-Reply-To: Subject: Re: Database archive solutions Date: Thu, 22 Nov 2012 11:33:19 +0530 Organization: Zoniac Software Private Limited Message-ID: <00de01cdc877$15dcfcc0$4196f640$@zoniac.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQNZAA/29sFp5hTx+oMVkPt6CgHA7AHaaEpalNAM6UA= Content-Language: en-us X-Lux-Comment: Message qAM63FKq006652 sent by user #22393 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201211/115 X-Sequence-Number: 40360 > Your question isn't specific enough.=A0 What does "not compromised" = mean?=A0 Every technique for archiving records has some impact on some part of = your system.=A0 Is a 0.1% impact too=20 > much?=A0 A 1% impact?=A0 A 10% impact?=A0 A factor of 2 slowdown? Sorry if my original question has not clearly conveyed my requirement. First, let me accept that I'm not a good DBA Expert (am a beginner), = however I'm trying to learn things. Actually, am finding out various techniques/options *itself* available = for archiving database records. Based on the techniques available, I can see/assess on how much it could impact our application, so that I can = choose one and adopt that suits our needs. In fact your response was an = eye-opener for me to think further in detail. > Do you need real-time archiving, a few minutes delay, or once a month backup? Yes, we're looking for real-time archiving. Once the records are = archived, Users in the application should able to perform search within archives = also after few minutes of time. > Do you need a hot standby or records that can be retrieved in a few = hours? It would be helpful if you can share the techniques/options available = for hot standby also.