key set delete query

From: Michael McCarthy <michael(at)tcsi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: key set delete query
Date: 2000-01-14 08:09:48
Message-ID: Pine.GSO.3.96.1000113235142.2456A-100000@sanmarino.tcsi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I notice to my dismay that key set query optimization only works for
SELECT :( This could be a significant performance problem for my
application, which would like to do a key set based delete.

Any thoughts on the advisability of changing the criteria for
transformation of key set based queries?

I know that cnfify is being reworked for release 7; any comment on when
7 will be available?

How stable is the latest beta? About 10 days ago I tried building from the
daily snapshot, but didn't get very far.

Thanks for any comments!

//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
Michael McCarthy TCSI Corporation
michael(at)tcsi(dot)com 1080 Marina Village Parkway
(510) 749-8739 Alameda, CA 94501

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Lutzebaeck 2000-01-14 08:41:51 Optimizing ORDER BY with indexes?
Previous Message Oliver Elphick 2000-01-13 21:21:16 Re: [SQL] foreign key implementation