Re: Hi- How frequently Postgres Poll for trigger file

Thanks for quick response..<br />Can I change this 5 second time?<br />I have seen the postgres code as well.<br />What
isthe functionality of WaitLatch() function. I could not understand completely.<br />Plz help..<br /><br /><div
class="gmail_quote">On Wed, Dec 1, 2010 at 5:53 PM, Heikki Linnakangas <span dir="ltr"><<a
href="mailto:heikki.linnakangas@enterprisedb.com">heikki.linnakangas@enterprisedb.com</a>></span>wrote:<br
/><blockquoteclass="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;"><div class="im">On 01.12.2010 13:27, aaliya zarrin wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> I want to know how
frequentlypostgres search for trigger file to switch<br /> over.<br /></blockquote><br /></div> In 9.0, every 100ms
whilestreaming replication is active and connected. 5 seconds otherwise. In current git master branch, it's always 5
s.<divclass="im"><br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid
rgb(204,204, 204); padding-left: 1ex;"> Can this switch over time be reduced?<br /></blockquote><br /></div> Not
withouthacking the sources and compiling.<br /><br /> Although, on many platforms, Linux included I believe, sending a
signalto the startup process should wake it up from the sleep and make it check the trigger file immediately. "pg_ctl
reload"for example should do it. So if ıou send a signal to the startup process immediately after creating the trigger
file,it should take notice sooner.<div class="im"><br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt
0pt0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> Plz let me know where postgres poll for
triggerfile. I could find it out in<br /> "backend/access/trans/xlog.c" ? am i right?<br /></blockquote><br /></div>
Yes.search for callers of CheckForStandbyTrigger() function.<br /><font color="#888888"><br /><br /> -- <br />  Heikki
Linnakangas<br/>  EnterpriseDB   <a href="http://www.enterprisedb.com"
target="_blank">http://www.enterprisedb.com</a><br/></font></blockquote></div><br /><br clear="all" /><br />-- <br
/>Thanks& Regards,<br /><br />Aaliya Zarrin<br />(+91)-9160665888<br />