Re: What query optimisations are included in Postgresql?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What query optimisations are included in Postgresql?
Date: 2013-11-29 19:58:09
Message-ID: 5298F1D1.8080508@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/28/2013 9:46 AM, N wrote:
> 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?

There's nearly as much query plan optimization as a C compiler has code
optimization.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tjibbe 2013-11-30 14:48:05 Fwd: row_to_json() with numerical indices in stead of associative indices
Previous Message Bruce Momjian 2013-11-29 16:33:42 Re: [GENERAL] pg_upgrade ?deficiency