Thanks, but still not same. For example, is there subquery flattening , is there any other query re-write ? is there website or books have such detail ? On Thu, Nov 28, 2013 at 5:54 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On 11/28/2013 09:46 AM, N wrote: >> >> Are there documents specifying the query optimisations in Postgresql >> like the SQLite (http://www.sqlite.org/optoverview.html)? > > > http://www.postgresql.org/docs/9.3/interactive/overview.html > http://www.postgresql.org/docs/9.3/interactive/performance-tips.html > >> >>> From the web, I can say, there are index and join optimisation, but >> >> are there anything others like Subquery flattening? >> >> thanks. >> >> Bentley. >> >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
