key set delete query - Mailing list pgsql-sql

From Michael McCarthy
Subject key set delete query
Date
Msg-id Pine.GSO.3.96.1000113235142.2456A-100000@sanmarino.tcsi.com
Whole thread Raw
Responses Re: [SQL] key set delete query  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@tcsi.com                             1080 Marina Village Parkway
(510) 749-8739                               Alameda, CA 94501



pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [SQL] foreign key implementation
Next
From: Dirk Lutzebaeck
Date:
Subject: Optimizing ORDER BY with indexes?