Re: Hi- How frequently Postgres Poll for trigger file

Hey!!!!!!!!!1
I am able to change the switch over time.. Thanks alot..
2010/12/2 aaliya zarrin <aaliya(dot)zarrin(at)gmail(dot)com>

> Ok.. Thanks I will try!!!
>
> 2010/12/2 Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
>
> Oh, and there's another value for the case we're polling the archive, not
>> streaming from master. Search for "5" in XLogPageRead function to catch them
>> all.
>>
>>
>> On 02.12.2010 08:21, Heikki Linnakangas wrote:
>>
>>> It's the 5000000L argument in the WaitLatch call. It's expressed in
>>> microseconds.
>>>
>>> On 02.12.2010 06:39, aaliya zarrin wrote:
>>>
>>>> Where this 5 Seconds time is defined in the code ???
>>>>
>>>>
>>>>
>>>> On Wed, Dec 1, 2010 at 5:53 PM, Heikki Linnakangas<
>>>> heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>>>>
>>>> On 01.12.2010 13:27, aaliya zarrin wrote:
>>>>>
>>>>> I want to know how frequently postgres search for trigger file to
>>>>>> switch
>>>>>> over.
>>>>>>
>>>>>>
>>>>> In 9.0, every 100ms while streaming replication is active and
>>>>> connected. 5
>>>>> seconds otherwise. In current git master branch, it's always 5 s.
>>>>>
>>>>>
>>>>> Can this switch over time be reduced?
>>>>>
>>>>>>
>>>>>>
>>>>> Not without hacking the sources and compiling.
>>>>>
>>>>> Although, on many platforms, Linux included I believe, sending a
>>>>> signal to
>>>>> 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.
>>>>>
>>>>>
>>>>> Plz let me know where postgres poll for trigger file. I could find it
>>>>> out
>>>>>
>>>>>> in
>>>>>> "backend/access/trans/xlog.c" ? am i right?
>>>>>>
>>>>>>
>>>>> Yes. search for callers of CheckForStandbyTrigger() function.
>>>>>
>>>>>
>>>>> --
>>>>> Heikki Linnakangas
>>>>> EnterpriseDB http://www.enterprisedb.com
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>> --
>> Heikki Linnakangas
>> EnterpriseDB http://www.enterprisedb.com
>>
>
>
>
> --
> Thanks & Regards,
>
> Aaliya Zarrin
> (+91)-9160665888
>

--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888