Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-03 Thread Heikki Linnakangas
On 03.12.2010 03:55, Fujii Masao wrote: On Thu, Dec 2, 2010 at 12:16 AM, Euler Taveira de Oliveira wrote: As you said, there are platforms that a signal doesn't wake up a process, so I suggest (ii) but I'm fine to include (i) at docs too. Can we use "pg_ctl kill" to send signal on such platf

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-02 Thread Fujii Masao
On Thu, Dec 2, 2010 at 12:16 AM, Euler Taveira de Oliveira wrote: > As you said, there are platforms that a signal doesn't wake up a > process, so I suggest (ii) but I'm fine to include (i) at docs too. Can we use "pg_ctl kill" to send signal on such platforms? Regards, -- Fujii Masao NIPPON T

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-02 Thread aaliya zarrin
Hey!1 I am able to change the switch over time.. Thanks alot.. 2010/12/2 aaliya zarrin > Ok.. Thanks I will try!!! > > 2010/12/2 Heikki Linnakangas > > Oh, and there's another value for the case we're polling the archive, not >> streaming from master. Search for "5" in XLogPageRead funct

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread Heikki Linnakangas
On 01.12.2010 19:23, aaliya zarrin wrote: Thanks for quick response.. Can I change this 5 second time? I have seen the postgres code as well. You can, if you don't mind changing the sources. What is the functionality of WaitLatch() function. I could not understand completely. The recoveryWa

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread aaliya zarrin
Thanks for quick response.. Can I change this 5 second time? I have seen the postgres code as well. What is the functionality of WaitLatch() function. I could not understand completely. Plz help.. On Wed, Dec 1, 2010 at 5:53 PM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > O

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread Euler Taveira de Oliveira
Heikki Linnakangas escreveu: > 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 alway

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread Heikki Linnakangas
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

[HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread aaliya zarrin
Hi All, I am new to postgres. I want to know how frequently postgres search for trigger file to switch over. Can this switch over time be reduced? Plz let me know where postgres poll for trigger file. I could find it out in "backend/access/trans/xlog.c" ? am i right? -- Thanks & Regards, Aaliy