Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Simon Riggs
On Mon, 2010-01-25 at 09:52 +0200, Heikki Linnakangas wrote: Simon Riggs wrote: On Sat, 2010-01-23 at 21:40 +, Greg Stark wrote: On Sat, Jan 23, 2010 at 8:28 PM, Simon Riggs si...@2ndquadrant.com wrote: What is your proposed way of handling buffer pin deadlocks? That will be

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Heikki Linnakangas
Simon Riggs wrote: On Mon, 2010-01-25 at 09:52 +0200, Heikki Linnakangas wrote: Would this simple scheme work: When the startup process has waited for a short while (ie deadlock_timeout), it sends the signal please check if you're holding a pin on buffer X to all backends. When a backend

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Heikki Linnakangas
Heikki Linnakangas wrote: Simon Riggs wrote: On Mon, 2010-01-25 at 09:52 +0200, Heikki Linnakangas wrote: Would this simple scheme work: When the startup process has waited for a short while (ie deadlock_timeout), it sends the signal please check if you're holding a pin on buffer X to all

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Simon Riggs
On Mon, 2010-01-25 at 10:59 +0200, Heikki Linnakangas wrote: Heikki Linnakangas wrote: Simon Riggs wrote: On Mon, 2010-01-25 at 09:52 +0200, Heikki Linnakangas wrote: Would this simple scheme work: When the startup process has waited for a short while (ie deadlock_timeout), it sends

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Heikki Linnakangas
Simon Riggs wrote: It's clearly a lower priority than other code based upon feedback from the Hot Standby user group. What's the the Hot Standby user group? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Simon Riggs
On Mon, 2010-01-25 at 16:22 +0200, Heikki Linnakangas wrote: Simon Riggs wrote: It's clearly a lower priority than other code based upon feedback from the Hot Standby user group. What's the the Hot Standby user group? A group of people who have an interest in using Hot Standby, as

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-25 Thread Josh Berkus
A group of people who have an interest in using Hot Standby, as advertised on postgresql.org and Weekly News. There are pg users who won't be using HS/SR? ;-) --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-24 Thread Heikki Linnakangas
Simon Riggs wrote: On Sat, 2010-01-23 at 21:40 +, Greg Stark wrote: On Sat, Jan 23, 2010 at 8:28 PM, Simon Riggs si...@2ndquadrant.com wrote: What is your proposed way of handling buffer pin deadlocks? That will be acceptable and working to some extent in the next week? Wait forever

[HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-23 Thread Greg Stark
On Sat, Jan 23, 2010 at 4:37 PM, Simon Riggs sri...@postgresql.org wrote: max_standby_delay = -1 option removed to prevent deadlock. This seems unacceptable to me. It means it's impossible to configure a reporting slave so it doesn't spuriously signal errors if your reports run too long. Recall

[HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-23 Thread Simon Riggs
On Sat, 2010-01-23 at 17:35 +, Greg Stark wrote: On Sat, Jan 23, 2010 at 4:37 PM, Simon Riggs sri...@postgresql.org wrote: max_standby_delay = -1 option removed to prevent deadlock. This seems unacceptable to me. It means it's impossible to configure a reporting slave so it doesn't

[HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-23 Thread Greg Stark
On Sat, Jan 23, 2010 at 8:28 PM, Simon Riggs si...@2ndquadrant.com wrote: What is your proposed way of handling buffer pin deadlocks? That will be acceptable and working to some extent in the next week? Wait forever isn't always a good idea, anymore, if it ever was. I've never said it was

[HACKERS] Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

2010-01-23 Thread Simon Riggs
On Sat, 2010-01-23 at 21:40 +, Greg Stark wrote: On Sat, Jan 23, 2010 at 8:28 PM, Simon Riggs si...@2ndquadrant.com wrote: What is your proposed way of handling buffer pin deadlocks? That will be acceptable and working to some extent in the next week? Wait forever isn't always a good