savepoint commit performance

Lists: pgsql-hackers
From: Andy Colson <andy(at)squeakycode(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: savepoint commit performance
Date: 2011-09-05 17:56:04
Message-ID: 4E650D34.2010501@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

This patch:

https://commitfest.postgresql.org/action/patch_view?id=605

Seems to have been after thoughts, and back burner stuff, and forgotten about...

Has it already been commit?

http://archives.postgresql.org/pgsql-committers/2011-07/msg00206.php

Oh, wait, nevermind, it was revoked and reworked:

http://archives.postgresql.org/pgsql-hackers/2011-07/msg01041.php

but that was posted Jul 19, 2011. And the Patch linked from commitfest is Jun 6, 2011. So is that an old patch? Or a new patch?

I'm confused.

-Andy


From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: savepoint commit performance
Date: 2011-09-06 02:32:56
Message-ID: CA+Tgmoa8DGNupF2urdYRF06WQ-0mfygO+TCB_JySp4_KoB7JwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, Sep 5, 2011 at 1:56 PM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> This patch:
>
> https://commitfest.postgresql.org/action/patch_view?id=605
>
> Seems to have been after thoughts, and back burner stuff, and forgotten
> about...
>
> Has it already been commit?
>
> http://archives.postgresql.org/pgsql-committers/2011-07/msg00206.php
>
> Oh, wait, nevermind, it was revoked and reworked:
>
> http://archives.postgresql.org/pgsql-hackers/2011-07/msg01041.php
>
> but that was posted Jul 19, 2011.  And the Patch linked from commitfest is
> Jun 6, 2011.  So is that an old patch?  Or a new patch?
>
> I'm confused.

As far as I can see, Simon stated that he would revert it but never did so.

Perhaps we should go do that...

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: savepoint commit performance
Date: 2011-09-06 20:12:37
Message-ID: 19938.1315339957@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Mon, Sep 5, 2011 at 1:56 PM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
>> This patch:
>>
>> https://commitfest.postgresql.org/action/patch_view?id=605
>>
>> Seems to have been after thoughts, and back burner stuff, and forgotten
>> about...
>>
>> Has it already been commit?
>>
>> http://archives.postgresql.org/pgsql-committers/2011-07/msg00206.php
>>
>> Oh, wait, nevermind, it was revoked and reworked:
>>
>> http://archives.postgresql.org/pgsql-hackers/2011-07/msg01041.php
>>
>> but that was posted Jul 19, 2011. And the Patch linked from commitfest is
>> Jun 6, 2011. So is that an old patch? Or a new patch?
>>
>> I'm confused.

> As far as I can see, Simon stated that he would revert it but never did so.

> Perhaps we should go do that...

The patch is definitely still in the tree. Given the dangling-pointer
concerns raised by Heikki, I think we had better revert it before
shipping 9.1. Also, the entry in the September commitfest can be marked
"returned with feedback", since it clearly predates the discussion on
-hackers.

regards, tom lane


From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: savepoint commit performance
Date: 2011-09-06 20:18:00
Message-ID: CA+U5nM+XhpFTAooDwof44PvFp51Fj08wrnJWFJ29iUkrO5PBRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, Sep 6, 2011 at 9:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Mon, Sep 5, 2011 at 1:56 PM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
>>> This patch:
>>>
>>> https://commitfest.postgresql.org/action/patch_view?id=605
>>>
>>> Seems to have been after thoughts, and back burner stuff, and forgotten
>>> about...
>>>
>>> Has it already been commit?
>>>
>>> http://archives.postgresql.org/pgsql-committers/2011-07/msg00206.php
>>>
>>> Oh, wait, nevermind, it was revoked and reworked:
>>>
>>> http://archives.postgresql.org/pgsql-hackers/2011-07/msg01041.php
>>>
>>> but that was posted Jul 19, 2011.  And the Patch linked from commitfest is
>>> Jun 6, 2011.  So is that an old patch?  Or a new patch?
>>>
>>> I'm confused.
>
>> As far as I can see, Simon stated that he would revert it but never did so.
>
>> Perhaps we should go do that...
>
> The patch is definitely still in the tree.  Given the dangling-pointer
> concerns raised by Heikki, I think we had better revert it before
> shipping 9.1.  Also, the entry in the September commitfest can be marked
> "returned with feedback", since it clearly predates the discussion on
> -hackers.

It's not a 9.1 patch, so that is not a concern.

I'm back now and will act as advertised.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: savepoint commit performance
Date: 2011-09-07 11:15:50
Message-ID: CA+U5nML3yHw=gMtZEgLc5oWg0SVAKYKLDJ1Jf9jx4rL0aC0XdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, Sep 6, 2011 at 9:18 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

> I'm back now and will act as advertised.

I've revoked the performance aspect. The difference between release
and commit has been maintained since it makes the code easier to
understand.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services