key set delete query

Поиск
Список
Период
Сортировка
От Michael McCarthy
Тема key set delete query
Дата
Msg-id Pine.GSO.3.96.1000113235142.2456A-100000@sanmarino.tcsi.com
обсуждение исходный текст
Ответы Re: [SQL] key set delete query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: [SQL] foreign key implementation
Следующее
От: Dirk Lutzebaeck
Дата:
Сообщение: Optimizing ORDER BY with indexes?