Re: [HACKERS] SERIALIZABLE with parallel query

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Kevin Grittner <kgrittn(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] SERIALIZABLE with parallel query
Date: 2018-06-29 10:28:50
Message-ID: CAEepm=03wAv0ko9qHRiVtx6h5CWd1-L3hqP9XN2oXA__8HtryA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 28, 2018 at 7:55 PM, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> I'd like to test and review this patches but they seem to conflict
> with current HEAD. Could you please rebase them?

Hi Sawada-san,

Thanks! Rebased and attached. The only changes are: the LWLock
tranche is now shown as "serializable_xact" instead of "sxact" (hmm,
LWLock tranches have lower_case_names_with_underscores, but individual
LWLocks have CamelCaseName...), and ShareSerializableXact() no longer
does Assert(!IsParallelWorker()). These changes are based on the last
feedback from Robert.

--
Thomas Munro
http://www.enterprisedb.com

Attachment Content-Type Size
0001-Enable-parallel-query-with-SERIALIZABLE-isolatio-v14.patch application/octet-stream 30.2 KB
0002-Enable-the-read-only-SERIALIZABLE-optimization-f-v14.patch application/octet-stream 13.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message amul sul 2018-06-29 11:07:46 Failed assertion due to procedure created with SECURITY DEFINER option
Previous Message Yugo Nagata 2018-06-29 09:46:19 Re: CREATE TABLE .. LIKE .. EXCLUDING documentation