Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Fujii Masao <masao.fujii@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-04-06T14:11:08Z
Lists: pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes: > Ok, here's a patch to add signaling between walreceiver and startup > process. It indeed isn't much code, and seems pretty safe, so if no-one > objects strongly, I'll commit. I object --- this seems like a large change to be sticking in at this point with no testing. I'm concerned about exactly how often the signal will happen (ie, how much overhead is being added). I'm also concerned about the fact that the startup process will now be receiving a constant storm of "no-op" signals, an operational behavior that is completely untested. If there's even one place that is failing to deal with EINTR retry, for instance, we'll have a problem. Plus I don't care for the platform dependency of the "fix". Being interruptable by signals is not part of the defined API for pg_usleep. I agree with the previous opinion that trying to get rid of that delay is an entirely inappropriate task at this point. Leave it for 9.1. regards, tom lane