Re: TRUNCATE SERIALIZABLE and frozen COPY

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Simon Riggs" <simon(at)2ndQuadrant(dot)com>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>,"Marti Raudsepp" <marti(at)juffo(dot)org>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TRUNCATE SERIALIZABLE and frozen COPY
Date: 2012-11-09 15:40:29
Message-ID: 20121109154030.77880@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:

>> This seems like a subset of the issues which one might want to
>> address by making DDL statement behave in a more strictly MVCC
>> fashion. Does it make sense to pick those off one at a time, or
>> should something like this be done only in the context of an
>> overall plan to deal with all of it?
>
> TRUNCATE is not DDL

You're right, I should have said utility commands.

> I have no interest in this other than speeding up COPY.

I would love to have that!

> Scope creep just kills features.

Well, I wasn't saying it should all be *done* at the same time, but
this is not the only utility command which could benefit from such an
effort, and if each one is done with no consideration of what it
takes for them all to be done, we could wind up with something that
doesn't hang together very coherently. Per perhaps this one could
serve as a "pilot", to identify issues and help develop such a plan.

-Kevin

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-11-09 15:46:13 Re: TRUNCATE SERIALIZABLE and frozen COPY
Previous Message Kevin Grittner 2012-11-09 15:34:06 Re: TRUNCATE SERIALIZABLE and frozen COPY