Re: Inefficient shutdown of pg_basebackup
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-05-03T06:10:16Z
Lists: pgsql-hackers
On 27 April 2017 at 05:31, Tom Lane <tgl@sss.pgh.pa.us> wrote: > The attached draft patch fixes this by expanding the StreamCtl API > with a socket that the low-level wait routine should check for input. > For me, this consistently knocks about 10 seconds off the runtime of > 001_stream_rep.pl. That is good. I noticed that delay many times. > It could be argued that this isn't too significant in the real world > because pg_basebackup would always run far longer than 10 seconds > anyway for non-toy data. But it still looks like a bug to me. Not sure its a bug, but if it causes people to avoid running tests then it is clearly a reliability issue. I don't see anything to gain by waiting a year to apply this, so +1 to move on it now. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Avoid slow shutdown of pg_basebackup.
- 7834d20b57a4 10.0 landed