Re: PostgreSQL Dump rate is too slow
От
girish R G peetle
Тема
Re: PostgreSQL Dump rate is too slow
Дата
Msg-id
CAKKd067BaJBY2ri97=d=4B8rS-tSpmhJVL3z27umhGynup-kRg@mail.gmail.com
Ответ на
Re: PostgreSQL Dump rate is too slow (Scott Ribe)
Список
Дерево обсуждения
PostgreSQL Dump rate is too slow girish R G peetle <giri.anamika0@gmail.com>
Re: PostgreSQL Dump rate is too slow David G Johnston <david.g.johnston@gmail.com>
Re: PostgreSQL Dump rate is too slow Jeff Frost <jeff@pgexperts.com>
Re: PostgreSQL Dump rate is too slow girish R G peetle <giri.anamika0@gmail.com>
Re: PostgreSQL Dump rate is too slow "ktm@rice.edu" <ktm@rice.edu>
Re: PostgreSQL Dump rate is too slow Eduardo Morras <emorrasg@yahoo.es>
Re: PostgreSQL Dump rate is too slow "Joshua D. Drake" <jd@commandprompt.com>
Re: PostgreSQL Dump rate is too slow girish R G peetle <giri.anamika0@gmail.com>
Re: PostgreSQL Dump rate is too slow "Joshua D. Drake" <jd@commandprompt.com>
Re: PostgreSQL Dump rate is too slow girish R G peetle <giri.anamika0@gmail.com>
Re: PostgreSQL Dump rate is too slow "Joshua D. Drake" <jd@commandprompt.com>
Re: PostgreSQL Dump rate is too slow Scott Ribe <scott_ribe@elevated-dev.com>
Re: PostgreSQL Dump rate is too slow girish R G peetle <giri.anamika0@gmail.com>
Re: PostgreSQL Dump rate is too slow Harshad Adalkonda <adalkondaharshad@gmail.com>
Re: PostgreSQL Dump rate is too slow Robert Burgholzer <rburghol@vt.edu>
Re: PostgreSQL Dump rate is too slow Scott Ribe <scott_ribe@elevated-dev.com>
Re: PostgreSQL Dump rate is too slow Kevin Grittner <kgrittn@ymail.com>
Re: PostgreSQL Dump rate is too slow David G Johnston <david.g.johnston@gmail.com>
Re: PostgreSQL Dump rate is too slow "ktm@rice.edu" <ktm@rice.edu>
Re: PostgreSQL Dump rate is too slow Alvaro Herrera <alvherre@2ndquadrant.com>
Thanks Scott, Joshua. Got it.
On Thu, Jan 15, 2015 at 11:43 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
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 it doesn'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 neither readers nor writers, they still prevent cleanup of blocks because they have to be able to see the state of the db as of the beginning of the transaction.
В списке pgsql-admin по дате отправления
