DELETE and efficiency - Mailing list pgsql-general

From gateley@jriver.com
Subject DELETE and efficiency
Date
Msg-id 3AA554CF.8D34C81C@jriver.com
Whole thread Raw
Responses Re: DELETE and efficiency  (Neil Conway <nconway@klamath.dyndns.org>)
List 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@jriver.com

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: epoch <-> timestamp
Next
From: "Martin A. Marques"
Date:
Subject: Re: PHP and PostgresSQL beta