[HACKERS] Discussion on missing optimizations

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема [HACKERS] Discussion on missing optimizations
Дата
Msg-id CAMjNa7cC4X9YR-vAJS-jSYCajhRDvJQnN7m2sLH1wLh-_Z2bsw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] Discussion on missing optimizations  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения
Hopefully it's alright for me to post this here, please let me know if not.

I ran across an article on blog.jooq.org comparing all the major RDBMS' with their ability to optimize away unnecessary work with queries which are less than optimal, and saw some discussion on hackernews and reddit, but I hadn't seen any discussion here.


Commercial databases seem to have a serious leg up in this area, and there are even some that MySQL has that Postgres doesn't.

I was wondering which of these are planned, which have had discussion before and decided not to support, and which just haven't been thought of?

I thought i'd bring it up and hopefully others who are more knowledgeable can chime in.

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Discussion on missing optimizations