Slow after running pg_dump - Mailing list pgsql-admin

From Ganesan
Subject Slow after running pg_dump
Date
Msg-id 20050103083403.EE7EF25F3DE@EMPEROR.MAGNUSQUEST.COM
Whole thread Raw
List 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

 

pgsql-admin by date:

Previous
From: "roblam"
Date:
Subject: Re: error 2203 8.0.0 install on win2000 server
Next
From: Amauri Pimenta
Date:
Subject: Postgresql 8.0.0 frezzes and stop!