Slow after running pg_dump

From: "Ganesan" <ganesan(at)magnusquest(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Slow after running pg_dump
Date: 2005-01-03 05:18:42
Message-ID: 20050103051919.C485B25F3EE@EMPEROR.MAGNUSQUEST.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Ganesan 2005-01-03 08:31:44 Slow after running pg_dump
Previous Message roblam 2005-01-02 19:39:43 Re: error 2203 8.0.0 install on win2000 server