Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Patches > Re: Snapshot ma...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 10 of 11 Topic 3620 of 4098
Post > Topic >>

Re: Snapshot management, final

by tgl@[EMAIL PROTECTED] (Tom Lane) May 11, 2008 at 09:16 PM

Alvaro Herrera <alvherre@[EMAIL PROTECTED]
> writes:
> Tom Lane wrote:
>> Hmm ... but that "close" can't unregister the snapshot immediately,
>> because you'd lose if the 2nd savepoint gets rolled back, no?  Is the
>> handling of this case even correct at the moment?

> No, CLOSE is not rolled back:
> ...
> Maybe this is possible to fix, but again I think it's outside the scope
> of this patch.

I'd forgotten that ... seems a bit bogus, and it's certainly not
do***ented on the CLOSE reference page.

>> ISTM correct handling of this example would require that the "close"
>> not really discard the snap until commit.  Then, given proper ordering
>> of the cleanup operations at commit, you might be able to still have
the
>> cross-check about s_level in UnregisterSnapshot.  (IOW, maybe having
>> snapshot cleanup be late in the commit sequence wasn't such a good
>> choice...)

> Right -- I'll move them earlier.

Well, without a clear idea of where to place them instead, you might as
well leave it alone for the moment.  I'd like to see this revisited
sometime though.

			regards, tom lane

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 11 Posts in Topic:
Re: Snapshot management, final
simon@[EMAIL PROTECTED]   2008-04-22 22:45:12 
Re: Snapshot management, final
alvherre@[EMAIL PROTECTED  2008-04-22 17:50:56 
Re: Snapshot management, final
tgl@[EMAIL PROTECTED] (T  2008-05-06 17:26:34 
Re: Snapshot management, final
tgl@[EMAIL PROTECTED] (T  2008-05-06 17:59:11 
Re: Snapshot management, final
alvherre@[EMAIL PROTECTED  2008-05-07 14:48:11 
Re: Snapshot management, final
tgl@[EMAIL PROTECTED] (T  2008-05-11 19:10:23 
Re: Snapshot management, final
alvherre@[EMAIL PROTECTED  2008-05-11 20:55:38 
Re: Snapshot management, final
tgl@[EMAIL PROTECTED] (T  2008-05-11 21:03:25 
Re: Snapshot management, final
alvherre@[EMAIL PROTECTED  2008-05-11 21:10:16 
Re: Snapshot management, final
tgl@[EMAIL PROTECTED] (T  2008-05-11 21:16:33 
Re: Snapshot management, final
alvherre@[EMAIL PROTECTED  2008-05-12 16:07:35 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 20:37:05 CDT 2008.