X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AD14C3A1996 for ; Mon, 3 Jan 2005 08:34:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16869-05 for ; Mon, 3 Jan 2005 08:33:59 +0000 (GMT) Received: from EMPEROR.MAGNUSQUEST.COM (emperor.magnusquest.com [219.93.76.5]) by svr1.postgresql.org (Postfix) with ESMTP id 28F2E3A3AF8 for ; Mon, 3 Jan 2005 08:33:58 +0000 (GMT) Received: from localhost (unknown [127.0.0.1]) by EMPEROR.MAGNUSQUEST.COM (Postfix) with ESMTP id 6ED0025F3E0 for ; Mon, 3 Jan 2005 16:34:05 +0800 (MYT) Received: from EMPEROR.MAGNUSQUEST.COM ([127.0.0.1]) by localhost (EMPEROR.MAGNUSQUEST.COM [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 78779-08 for ; Mon, 3 Jan 2005 16:34:04 +0800 (MYT) Received: from ganesan (unknown [192.168.0.63]) by EMPEROR.MAGNUSQUEST.COM (Postfix) with ESMTP id EE7EF25F3DE for ; Mon, 3 Jan 2005 16:34:03 +0800 (MYT) From: "Ganesan" To: Subject: Slow after running pg_dump Date: Mon, 3 Jan 2005 16:31:44 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C4F1B1.B6DCDE10" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTxbqhLonMv/iQ9QQaEs6W54Q+zNw== Message-Id: <20050103083403.EE7EF25F3DE@EMPEROR.MAGNUSQUEST.COM> X-Virus-Scanned: by amavisd-new run on FreeBSD HP ML150 mail server at EMPEROR.MAGNUSQUEST.COM X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.19 tagged_above=0 required=5 tests=HTML_90_100, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/3 X-Sequence-Number: 15862 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4F1B1.B6DCDE10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am doing pg_dump for my database on daily basis (afternoon backup) and after I did pg_dump the database become slow for accessing. Is there anything I could do to make the database access fast. I am doing VACUUM and ANALYZE for the database at night and as well night backup. Please advice. Regards, Ganesan ------=_NextPart_000_0013_01C4F1B1.B6DCDE10 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am doing pg_dump for my database on daily = basis (afternoon backup) and after I did pg_dump = the database become slow for accessing.

 

Is there anything I could do to make the database access fast.

 

I am doing VACUUM and ANALYZE for the database at night and as well night = backup.

 

Please advice.

 

Regards,

Ganesan

 

------=_NextPart_000_0013_01C4F1B1.B6DCDE10--