pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
key set delete query 2+ messages / 2 participants [nested] [flat]
* key set delete query @ 2000-01-14 08:09 Michael McCarthy <michael@tcsi.com> 0 siblings, 1 reply; 2+ messages in thread From: Michael McCarthy @ 2000-01-14 08:09 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] key set delete query @ 2000-01-14 15:02 Tom Lane <tgl@sss.pgh.pa.us> parent: Michael McCarthy <michael@tcsi.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2000-01-14 15:02 UTC (permalink / raw) To: Michael McCarthy <michael@tcsi.com>; +Cc: pgsql-sql Michael McCarthy <michael@tcsi.com> writes: > 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 have no intention of putting any effort into KSQO, other than removing it as soon as the rest of the optimizer does a reasonable job with OR queries ;-). You could try removing the check for a SELECT and see what happens, though. > I know that cnfify is being reworked for release 7; any comment on when > 7 will be available? Current plan is to go to beta mode on 1 Feb. Final release, hard to say. Marc will probably say "1 March for sure", but I lean more towards the "when it's ready" approach... > How stable is the latest beta? About 10 days ago I tried building from the > daily snapshot, but didn't get very far. We seem to be in the usual pre-beta flurry of committing half-tested code :-(. I think the underlying stability of the system has been amazingly good throughout this development cycle, but there have been a lot of minor build and regress test problems in the past couple weeks. If you have the know-how to get past those, things pretty much work. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-01-14 15:02 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-01-14 08:09 key set delete query Michael McCarthy <michael@tcsi.com> 2000-01-14 15:02 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox