Re: DELETE and efficiency

From: Michelle Murrain <mpm(at)norwottuck(dot)com>
To: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, pgsql-general(at)postgresql(dot)org
Cc: gateley(at)jriver(dot)com
Subject: Re: DELETE and efficiency
Date: 2001-03-06 22:08:41
Message-ID: 01030617084102.01297@chicago.murrain.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)norwottuck(dot)com
http://www.norwottuck.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randy Hall 2001-03-06 22:10:02 Re: how to find DB names in Postgres 7.1?
Previous Message Neil Conway 2001-03-06 22:05:26 Re: DELETE and efficiency