| 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: | Whole Thread | Raw Message | 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
| 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 |