Re: PostgreSQL Dump based backup using pipe - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgreSQL Dump based backup using pipe
Date
Msg-id 15001.1432826851@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL Dump based backup using pipe  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: PostgreSQL Dump based backup using pipe
List pgsql-admin
girish R G peetle <giri.anamika0@gmail.com> writes:
> I just tracked pg_dump writing output to a file. (using procmon)
> As indicated below data is not written in serial fashion.
> If we use name pipe would this behavior cause problem ?

It's less efficient with a named pipe, yes, because then pg_dump
can't do that.  But this doesn't prove anything one way or another
concerning your original complaint.

            regards, tom lane


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: raid writethrough mode (WT), ssds and your DB. (was Performances issues with SSD volume ?)
Next
From: "Guo, Yun"
Date:
Subject: pg_dump not dumping some schemas