From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TRUNCATE SERIALIZABLE and frozen COPY |
Date: | 2012-11-08 19:51:01 |
Message-ID: | CA+U5nM+GddEnXu1W6A0deJpRXr+vH63QpozjiN2NjxdRQVtvZw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8 November 2012 17:07, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Nov 7, 2012 at 10:34 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> For 9.2 we discussed having COPY setting tuples as frozen. Various
>> details apply.
>> Earlier threads:
>> "RFC: Making TRUNCATE more "MVCC-safe"
>> "COPY with hints, rebirth"
>>
>> I was unhappy with changing the behaviour of TRUNCATE, and still am.
>> So the proposal here is to have a specific modifier on TRUNCATE
>> command that makes it MVCC safe by throwing a serialization error.
>
> I don't think I understand the proposal. Under what circumstances
> would it throw a serialization error?
If you ask for TRUNCATE SERIALIZABLE then if someone asks for data in
the table and has a snapshot that can see earlier data then it will
throw a serializable error. So its a new kind of TRUNCATE that is MVCC
safe.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Rasheed | 2012-11-08 20:29:22 | Re: Proof of concept: auto updatable views [Review of Patch] |
Previous Message | David Fetter | 2012-11-08 19:40:14 | Re: Tweaking ResolveNew's API |