Aggregate leads to superfluous projection from the scan

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема Aggregate leads to superfluous projection from the scan
Дата
Msg-id CALNJ-vTbeo5GN67tm_Wz89LrpnBXuh-KZQ8EeqNVpV0QL05WCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Aggregate leads to superfluous projection from the scan  (Zhihong Yu <zyu@yugabyte.com>)
Список pgsql-hackers
Дерево обсуждения
Hi,
Here is the query which involves aggregate on a single column:


As you can see from `Output:`, there are many columns added which are not needed by the query executor.

I wonder if someone has noticed this in the past.
If so, what was the discussion around this topic ?

Thanks

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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Add last_vacuum_index_scans in pg_stat_all_tables