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