Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Discussion on missing optimizations - Mailing list pgsql-hackers

From Adam Brusselback
Subject [HACKERS] Discussion on missing optimizations
Date
Msg-id CAMjNa7cC4X9YR-vAJS-jSYCajhRDvJQnN7m2sLH1wLh-_Z2bsw@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Discussion on missing optimizations
List pgsql-hackers
Tree view
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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Discussion on missing optimizations