Re: [HACKERS] SSI, simplified

2011-01-26 Thread Kevin Grittner
"Kevin Grittner" wrote: > Suggested changes? I see that Heikki suggested that the change to the hot standby docs belonged in the Caveats section. Will change that note to a bullet point under Caveats. Sorry I didn't catch that sooner. -Kevin -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Kevin Grittner
Heikki Linnakangas wrote: > By all means, feel free to add a note to the docs about this. A > note in the Hot Standby Caveats section would be good, in addition > to somewhere in the chapter about isolation levels. Here's what I came up with: http://git.postgresql.org/gitweb?p=users/kgrittn/

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Kevin Grittner
Heikki Linnakangas wrote: > By all means, feel free to add a note to the docs about this. A > note in the Hot Standby Caveats section would be good, in addition > to somewhere in the chapter about isolation levels. OK, will do. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@p

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Heikki Linnakangas
On 26.01.2011 17:00, Kevin Grittner wrote: Simon Riggs wrote: So in the Compatibility release notes for 9.1 we should say: "Applications that request SERIALIZABLE mode will now experience different and fully correct behaviour. The new mode does not currently work in Hot Standby mode, and an e

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Kevin Grittner
Alvaro Herrera wrote: > Also, perhaps > > errmsg("cannot use serializable mode in a hot standby"), > errhint("You can use REPEATABLE READ instead.") OK: http://git.postgresql.org/gitweb?p=users/kgrittn/postgres.git;a=commitdiff;h=0950b11c91aecbbe490ec06205235d60fcd90a2e -Kevin -- Sent

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Alvaro Herrera
Excerpts from Simon Riggs's message of miƩ ene 26 10:40:28 -0300 2011: > So in the Compatibility release notes for 9.1 we should say: > > "Applications that request SERIALIZABLE mode will now experience > different and fully correct behaviour. The new mode does not currently > work in Hot Standby

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Kevin Grittner
Simon Riggs wrote: > So in the Compatibility release notes for 9.1 we should say: > > "Applications that request SERIALIZABLE mode will now experience > different and fully correct behaviour. The new mode does not > currently work in Hot Standby mode, and an error will be returned > if this is

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Simon Riggs
On Wed, 2011-01-26 at 14:27 +0100, Dimitri Fontaine wrote: > Simon Riggs writes: > > Not sure how to handle that. My understanding is that we are replacing > > the old Serializable mode with the new Serializable mode. The old way > > works, but the new way doesn't. I don't think we should throw an

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Dimitri Fontaine
Simon Riggs writes: > Not sure how to handle that. My understanding is that we are replacing > the old Serializable mode with the new Serializable mode. The old way > works, but the new way doesn't. I don't think we should throw an error; > we just need to document that it works the old way on HS

Re: [HACKERS] SSI, simplified

2011-01-26 Thread Simon Riggs
On Mon, 2011-01-24 at 09:29 +0200, Heikki Linnakangas wrote: > On 24.01.2011 03:48, Kevin Grittner wrote: > > If I get a solid answer on the SSI/HS issue before I post V14, I > > might be able to cover that, too, in that patch. I haven't wanted to > > totally write off the possibility of integrati

Re: [HACKERS] SSI, simplified

2011-01-25 Thread Kevin Grittner
Joshua Tolley wrote: >> http://www.xtranormal.com/watch/8285377/?listid=20642536 > I foresee a whole new set of animated postgres tutorials... Seriously, I was thinking the same thing. I threw this together while waiting to see if DBT-2 could shake out any new problems after some minor cha

Re: [HACKERS] SSI, simplified

2011-01-25 Thread Joshua Tolley
On Sun, Jan 23, 2011 at 07:48:04PM -0600, Kevin Grittner wrote: > http://www.xtranormal.com/watch/8285377/?listid=20642536 I foresee a whole new set of animated postgres tutorials... -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com signature.asc Description: Digital sig

Re: [HACKERS] SSI, simplified

2011-01-23 Thread Heikki Linnakangas
On 24.01.2011 03:48, Kevin Grittner wrote: If I get a solid answer on the SSI/HS issue before I post V14, I might be able to cover that, too, in that patch. I haven't wanted to totally write off the possibility of integrating them as long as discussion was ongoing; but if someone wants to assume

[HACKERS] SSI, simplified

2011-01-23 Thread Kevin Grittner
Dan is still beating up on the latest patch with DBT-2, but I expect that I'll be posting a patch tomorrow with all known issues fixed, no known bugs, and reasonable performance -- except for the issue of how this work relates to hot standby in the 9.1 release. (We did find and fix a few bugs afte