Re: Regarding TODO item "%Add a separate TRUNCATE permission"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Дата
Msg-id 20060426185240.GE2302@surnet.cl
обсуждение исходный текст
Ответ на Re: Regarding TODO item "%Add a separate TRUNCATE permission"  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Regarding TODO item "%Add a separate TRUNCATE permission"