Re: Proposal for CSN based snapshots

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Greg Stark <stark(at)mit(dot)edu>, Robert Haas <robertmhaas(at)gmail(dot)com>, "Andres Freund" <andres(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, Ants Aasma <ants(at)cybertec(dot)at>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Markus Wanner <markus(at)bluegap(dot)ch>
Subject: Re: Proposal for CSN based snapshots
Date: 2014-08-27 06:42:20
Message-ID: 53FD7DCC.5020005@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08/27/2014 09:40 AM, Heikki Linnakangas wrote:
> On 08/27/2014 08:23 AM, Jeff Davis wrote:
>> On Tue, 2014-08-26 at 13:45 +0300, Heikki Linnakangas wrote:
>>> Yeah. This patch in the current state is likely much much slower than
>>> unpatched master, except in extreme cases where you have thousands of
>>> connections and short transactions so that without the patch, you spend
>>> most of the time acquiring snapshots.
>>
>> What else are you looking to accomplish with this patch during this
>> 'fest? Bug finding? Design review? Performance testing?
>
> Design review, mostly. I know the performance still sucks. Although if
> you can foresee some performance problems, aside from the extra CSNLOG
> lookups, it would be good to know.

I think for this commitfest, I've gotten as much review of this patch
that I can hope for. Marking as "Returned with Feedback". But of course,
feel free to continue reviewing and commenting ;-).

- Heikki

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2014-08-27 06:53:40 Re: REINDEX CONCURRENTLY 2.0
Previous Message Andres Freund 2014-08-27 06:41:20 Re: REINDEX CONCURRENTLY 2.0