Re: Unclamped row estimates whith OR-ed subplans

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Unclamped row estimates whith OR-ed subplans
Дата
Msg-id CAHOFxGobHxN5euHRcEs2WPg3WsYev4WAd9xFAUwHwhyzUztfDw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unclamped row estimates whith OR-ed subplans  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
While you're waiting, you might think about recasting the query to
avoid the OR.  Perhaps you could do a UNION of two scans of the
transactions table?

Minor note- use UNION ALL to avoid the dedupe work if you already know those will be distinct sets, or having duplicates is fine.

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