Postgres Pro
Downloads
Home   >   mailing lists

database response slows while pg_dump is running (8.4.2) - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject database response slows while pg_dump is running (8.4.2)
Date
Msg-id AANLkTinNmFzmj9xrIfiPGGg-h3p6tjZRLKNprYXQUF_V@mail.gmail.com
Whole thread Raw
Responses Re: database response slows while pg_dump is running (8.4.2)  (Andy Colson <andy@squeakycode.net>)
Re: database response slows while pg_dump is running (8.4.2)  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view 
PostgreSQL 8.4.2 response time slows during pg_dump of a 14 GB database.

Specifically, I am monitoring how long it takes to login to our Web
app - usually under 2 seconds, but when pg_dump is running, that
changes to 2 - 18 seconds.

Is there any way I can keep my response fast but still get my pg_dump?
 Or should I move my pg_dump to a Slony-I slave?

Best,
-at

pgsql-general by date:

Previous
From: Jim.Gray@Bull.com
Date:
Subject: PL/pgSQL nested functions
Next
From: Raymond O'Donnell
Date:
Subject: Re: PL/pgSQL nested functions