database response slows while pg_dump is running (8.4.2)

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: database response slows while pg_dump is running (8.4.2)
Date: 2010-06-10 20:25:37
Message-ID: AANLkTinNmFzmj9xrIfiPGGg-h3p6tjZRLKNprYXQUF_V@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-06-10 20:33:44 Re: PL/pgSQL nested functions
Previous Message Jim.Gray 2010-06-10 20:23:22 PL/pgSQL nested functions