Re: [HACKERS] Assertion failure twophase.c (3) (testing HS/SR)

2010-03-14 Thread Erik Rijkers
On Thu, March 4, 2010 17:00, Erik Rijkers wrote: > in a 9.0devel, primary+standby, cvs from 2010.03.04 01:30 > > With three patches: > > new_smart_shutdown_20100201.patch > extend_format_of_recovery_info_funcs_v4.20100303.patch > fix-KnownAssignedXidsRemoveMany-1.patch > > pg_dump -d $db8.4

Re: [HACKERS] Getting to beta1

2010-03-14 Thread David E. Wheeler
On Mar 14, 2010, at 3:38 PM, Josh Berkus wrote: > I'm planning on writing a "Guide to HS & SR" for the beta. Originally I > planned to put this in the main docs, but I couldn't figure out how to > fit it in there structurally. Plus, it needs more examples, output > samples, and a tutorial feel.

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Josh Berkus
Devs, Also, I would like to have a Beta or at least a new alpha release before April 3 for the test-fest, so that our volunteers aren't testing bugs which are already patched. --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Josh Berkus
On 3/14/10 9:02 AM, Simon Riggs wrote: > An explanation in the docs would be good. And also a hint of how to > failover if you decide in an emergency that the absence was a mistake, > in retrospect. I'm planning on writing a "Guide to HS & SR" for the beta. Originally I planned to put this in the

Re: [HACKERS] [BUGS] PD_ALL_VISIBLE flag error on 9.0 alpha 4

2010-03-14 Thread Josh Berkus
> I can imagine and have done so. That patch was completed more than 6 > weeks ago and can still be included in this release. See, this is why you're a committer and I'm not. ;-) > http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg145951.html Cool! Will test. We'll make this thing w

Re: [HACKERS] idle in txn query cancellation

2010-03-14 Thread Simon Riggs
On Sun, 2010-03-14 at 19:50 +0100, Andres Freund wrote: > On Sunday 14 February 2010 06:29:45 Simon Riggs wrote: > > On Sat, 2010-02-13 at 22:37 +0100, Andres Freund wrote: > > > I know it is late in the cycle > > > > No problem here. Thanks for your diligence. Will review. > Got a chance to look

Re: [HACKERS] idle in txn query cancellation

2010-03-14 Thread Andres Freund
On Sunday 14 February 2010 06:29:45 Simon Riggs wrote: > On Sat, 2010-02-13 at 22:37 +0100, Andres Freund wrote: > > I know it is late in the cycle > > No problem here. Thanks for your diligence. Will review. Got a chance to look at it? Andres -- Sent via pgsql-hackers mailing list (pgsql-hacke

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Simon Riggs
On Sun, 2010-03-14 at 16:53 +0200, Heikki Linnakangas wrote: > Simon Riggs wrote: > > I have these things on my list > > > > * Minor page xid bug fix > > * btree delete standby-side derivation of xid > > * review of StartupXLog issue, on open items list, has an effect on HS > > > > I expect to be

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Heikki Linnakangas
Simon Riggs wrote: > I have these things on my list > > * Minor page xid bug fix > * btree delete standby-side derivation of xid > * review of StartupXLog issue, on open items list, has an effect on HS > > I expect to be finished with those by Wed, perhaps Thurs. Don't forget the "start from shu

[HACKERS] how to use advanced gist options

2010-03-14 Thread Sergej Galkin
Hello all, Now I'm trying to realize index in GiST. Everything is Ok, but I would like to know about advanced index programming options. 1) For example - can I delete entry in my picksplit procedure ? 2) Or to add logical conditions - when picksplit node ? For exampe change default "when number o