Robert Haas wrote:
> On Tue, Aug 23, 2016 at 10:10 AM, Antonin Houska 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
Cybe
On Tue, Aug 23, 2016 at 10:10 AM, Antonin Houska wrote:
> I'm failing to understand why [1] mentions "table-rewriting forms of ALTER
> TABLE" besides TRUNCATE command.
>
> For TRUNCATE it seems clear: if transaction A takes the snapshot before it
> accesses the table first time (typically because
I'm failing to understand why [1] mentions "table-rewriting forms of ALTER
TABLE" besides TRUNCATE command.
For TRUNCATE it seems clear: if transaction A takes the snapshot before it
accesses the table first time (typically because isolation level is at least
REPEATABLE READ) and transaction B man
