What query optimisations are included in Postgresql?

From: N <ceecmm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What query optimisations are included in Postgresql?
Date: 2013-11-28 17:46:51
Message-ID: CAL1O4=VzNbMcEoLwoDTYim1r=Q3bRyu+-JhWKBnrY7Q=xBahAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are there documents specifying the query optimisations in Postgresql
like the SQLite (http://www.sqlite.org/optoverview.html)?

From the web, I can say, there are index and join optimisation, but
are there anything others like Subquery flattening?

thanks.

Bentley.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-11-28 17:54:05 Re: What query optimisations are included in Postgresql?
Previous Message Steve.Toutant 2013-11-28 16:25:41 query creates a huge toast tables