Re: PostgreSQL Dump rate is too slow

On Jan 15, 2015, at 10:57 AM, girish R G peetle <giri.anamika0@gmail.com> wrote:
>
> Thanks Joshua. Even if we have a long transaction running on the database, pg_dump shouldn't be affected right ? As
itdoesn't block readers or writers.  
> Before getting resources to setup stand by server, I just wanna make sure that we don't this issue on stand by too.

I believe he meant that pg_dump itself is the long-running transaction. Even though read-only transactions block
neitherreaders nor writers, they still prevent cleanup of blocks because they have to be able to see the state of the
dbas of the beginning of the transaction. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice