Re: DELETE and efficiency

Поиск
Список
Период
Сортировка
От Michelle Murrain
Тема Re: DELETE and efficiency
Дата
Msg-id 01030617084102.01297@chicago.murrain.net
обсуждение исходный текст
Ответ на Re: DELETE and efficiency  (Neil Conway <nconway@klamath.dyndns.org>)
Ответы Re: DELETE and efficiency
Список pgsql-general
On Tuesday 06 March 2001 05:05 pm, Neil Conway wrote:
>
> But as I understand it, a DELETE just marks the row as deleted -- the
> data is not actually removed from disk. This means they should be
> fast, but it also means that doing a VACUUM [ANALYZE] fairly regularly
> is probably a good idea.

Is that so? If so, that means there might be a way to do an undelete? What is
it?

Michelle

--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: DELETE and efficiency
Следующее
От: Randy Hall
Дата:
Сообщение: Re: how to find DB names in Postgres 7.1?