Postgres Pro
Downloads
Home   >   mailing lists

Slow after running pg_dump - Mailing list pgsql-admin

From Ganesan
Subject Slow after running pg_dump
Date
Msg-id 20050103051919.C485B25F3EE@EMPEROR.MAGNUSQUEST.COM
Whole thread Raw
List pgsql-admin
Tree view 
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: Henry Kon
Date:
Subject: Re: initial windows install : can't createuser or createdb - what user / pass to use?
Next
From: Henry Kon
Date:
Subject: initial windows install : can't createuser or createdb - what user / pass to use?