Re: DELETE and efficiency - Mailing list pgsql-general

From Michelle Murrain
Subject Re: DELETE and efficiency
Date
Msg-id 01030617084102.01297@chicago.murrain.net
Whole thread Raw
In response to Re: DELETE and efficiency  (Neil Conway <nconway@klamath.dyndns.org>)
Responses Re: DELETE and efficiency  (Dan Lyke <danlyke@flutterby.com>)
List 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 by date:

Previous
From: Neil Conway
Date:
Subject: Re: DELETE and efficiency
Next
From: Randy Hall
Date:
Subject: Re: how to find DB names in Postgres 7.1?