Horton
Menu

Re: DELETE and efficiency

Michelle Murrain <mpm@norwottuck.com>

View thread
From: Michelle Murrain <mpm@norwottuck.com>
To: Neil Conway <nconway@klamath.dyndns.org>, pgsql-general@postgresql.org
Cc: gateley@jriver.com
Date: 2001-03-06T22:08:41Z
Lists: 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