Slow after running pg

Slow after running pg_dump

This is a discussion on Slow after running pg_dump within the pgsql Admins forums, part of the PostgreSQL category; --> Hi, I am doing pg_dump for my database on daily basis (afternoon backup) and after I did pg_dump the ...

		Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins
Slow after running pg_dump

#1 (permalink)

04-10-2008, 01:14 AM

Ganesan

Posts: n/a

Slow after running pg_dump

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

« Postgresql 8.0.0 frezzes and stop! | Rules on a view overwrite default values. Any way to reinstate them? »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 10:40 PM.