Re: Question about MVCC-unsafe commands

From: Antonin Houska <ah(at)cybertec(dot)at>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question about MVCC-unsafe commands
Date: 2016-08-23 19:39:33
Message-ID: 23079.1471981173@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Tue, Aug 23, 2016 at 10:10 AM, Antonin Houska <ah(at)cybertec(dot)at> wrote:

> CLUSTER preserves xmin/xmax when rewriting, but ALTER TABLE does not.

Indeed, CLUSTER was the command I picked for my experiments. I didn't expect
such a subtle difference. Thanks for answer.

--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Martín Marqués 2016-08-23 19:46:42 Re: pg_dump with tables created in schemas created by extensions
Previous Message Tom Lane 2016-08-23 19:20:05 Re: SP-GiST support for inet datatypes