Horton

Re: [HACKERS] MERGE SQL Statement for PG11

Jesper Pedersen <jesper.pedersen@redhat.com>

View thread View on postgr.es
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Simon Riggs <simon@2ndquadrant.com>, Pavan Deolasee <pavan.deolasee@gmail.com>
Cc: Peter Geoghegan <pg@bowt.ie>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Robert Haas <robertmhaas@gmail.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Andrew Dunstan <andrew.dunstan@2ndquadrant.com>, Pavan Deolasee <pavan.deolasee@2ndquadrant.com>, Stephen Frost <sfrost@snowman.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-04-05T11:38:07Z
Lists: pgsql-hackers

Attachments

Hi Simon and Paven,

On 04/04/2018 08:46 AM, Jesper Pedersen wrote:
> On 03/30/2018 07:10 AM, Simon Riggs wrote:
>> No problems found, but moving proposed commit to 2 April pm
>>
> 
> There is a warning for this, as attached.
> 

Updated version due to latest refactoring.

Best regards,
   Jesper

Commits

  1. Add support for MERGE SQL command

  2. Avoid repeated name lookups during table and index DDL.

  3. Use an MVCC snapshot, rather than SnapshotNow, for catalog scans.