pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Slow after running pg_dump
2+ messages / 2 participants
[nested] [flat]

* Slow after running pg_dump
@ 2005-01-03 05:18  Ganesan <ganesan@magnusquest.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ganesan @ 2005-01-03 05:18 UTC (permalink / raw)
  To: 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








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Slow after running pg_dump
@ 2005-01-03 08:31  Ganesan <ganesh@magnusquest.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ganesan @ 2005-01-03 08:31 UTC (permalink / raw)
  To: 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
 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-01-03 08:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-03 05:18 Slow after running pg_dump Ganesan <ganesan@magnusquest.com>
2005-01-03 08:31 Slow after running pg_dump Ganesan <ganesh@magnusquest.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox