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

From Adrian von Bidder
Subject Re: database response slows while pg_dump is running (8.4.2)
Date
Msg-id 201006110843.53857@fortytwo.ch
Whole thread Raw
In response to Re: database response slows while pg_dump is running (8.4.2)  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Responses Re: database response slows while pg_dump is running (8.4.2)  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: database response slows while pg_dump is running (8.4.2)  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List pgsql-general
Heyho!

On Thursday 10 June 2010 23.49:58 Aleksey Tsalolikhin wrote:
> 3. We ARE disk bound.  Disk utilization goes to 94% during
> the dump.  There is an order of magnitude more reads than
> writes.

Just speculation, I've not tried this.  Perhaps pipe the output of pg_dump
through a software that bandwidth-limits the throughput?  (I don't know if
such a command exists, but it probably could be done in 4 lines of Perl or
30 lines of C if necessary.)  Or are there so many buffers involved that
this would just cause data to pile up in memory, waiting to be written out?

cheers
-- vbi

--
There’s a big confusion in the terms, as the numbers used in Arabic are
the Hindu numbers and the numbers used in Latin languages are the Arabic
numbers.
        -- Lior Kaplan, 1.4.2008

Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Enforcing password standards
Next
From: Adrian von Bidder
Date:
Subject: Re: Best way to store case-insensitive data?