how to import "where exists（subquery）" EXISTS CONDITION performance?

Поиск
Список
Период
Сортировка
От shili
Тема how to import "where exists（subquery）" EXISTS CONDITION performance?
Дата
Msg-id 1449042683403-5875801.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: [GENERAL] how to import "where exists（subquery）" EXISTS CONDITION performance?  (David Rowley <david.rowley@2ndquadrant.com>)
RE: [GENERAL] how to import "where exists（subquery）" EXISTS CONDITION performance?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: how to import "where exists（subquery）" EXISTS CONDITION performance?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
I had saw this sentence: SQL statements that use the EXISTS condition in PostgreSQL are very inefficient since the sub-query is RE-RUN for EVERY row in the outer query's table. There are more efficient ways to write most queries, that do not use the EXISTS condition. So,I want to know how PostgreSQL to implement the EXISTS condition? Is that sentence true? and,if that is true,are there any methods to import the performance of the EXISTS condition?
View this message in context: how to import "where exists（subquery）" EXISTS CONDITION performance?
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

В списке pgsql-general по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Exclusively locking parent tables while disinheriting children.
Следующее
От: David Rowley
Дата:
Сообщение: Re: [GENERAL] how to import "where exists（subquery）" EXISTS CONDITION performance?