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 6A75E3A2D8F for ; Mon, 3 Jan 2005 05:19:28 +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 21819-08 for ; Mon, 3 Jan 2005 05:19:17 +0000 (GMT) Received: from EMPEROR.MAGNUSQUEST.COM (emperor.magnusquest.com [219.93.76.5]) by svr1.postgresql.org (Postfix) with ESMTP id 1D8E63A2D86 for ; Mon, 3 Jan 2005 05:19:16 +0000 (GMT) Received: from localhost (unknown [127.0.0.1]) by EMPEROR.MAGNUSQUEST.COM (Postfix) with ESMTP id 2D7D725F3EF for ; Mon, 3 Jan 2005 13:19:21 +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 77268-07 for ; Mon, 3 Jan 2005 13:19:19 +0800 (MYT) Received: from ganesan (unknown [192.168.0.63]) by EMPEROR.MAGNUSQUEST.COM (Postfix) with ESMTP id C485B25F3EE for ; Mon, 3 Jan 2005 13:19:19 +0800 (MYT) From: "Ganesan" To: Subject: Slow after running pg_dump Date: Mon, 3 Jan 2005 13:18:42 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTxU7DuJzvg9+w1SdC5mCjOxMO+xw== Message-Id: <20050103051919.C485B25F3EE@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 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/6 X-Sequence-Number: 15865 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