DELETE and efficiency

From: gateley(at)jriver(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: DELETE and efficiency
Date: 2001-03-06 21:21:19
Message-ID: 3AA554CF.8D34C81C@jriver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am working on an application with
very dynamic data: it gets added and
deleted often. How effecient are the
searches in this situation?

In other words: most DB situations I've
seen don't use DELETE, and so the underlying
algorithms are probably optimized for this.
Is using DELETE going to kill my performance?

Thanks,

John Gateley, gateley(at)jriver(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin A. Marques 2001-03-06 21:22:12 Re: PHP and PostgresSQL beta
Previous Message Bruno Wolff III 2001-03-06 21:15:19 Re: epoch <-> timestamp