Re: Regarding TODO item "%Add a separate TRUNCATE permission" - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Date
Msg-id 20060426185240.GE2302@surnet.cl
Whole thread Raw
In response to Re: Regarding TODO item "%Add a separate TRUNCATE permission"  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost wrote:
> * Alvaro Herrera (alvherre@commandprompt.com) wrote:
> > Stephen Frost wrote:
> > > TRUNCATE doesn't follow MVCC...
> > 
> > We can certainly talk about fixing that.  (And CLUSTER at the same time,
> > I think.)
> 
> The issue is that it seems to be intractable to retain MVCC-ness *and*
> provide the performance savings TRUNCATE gives.  If you can solve that
> problem then we could get rid of TRUNCATE and implement
> DELETE-without-WHERE using that magic.

Doh, sorry, I was thinking in CLUSTER :-(

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Next
From: Tom Lane
Date:
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE permission"