> From: Pavel Stehule
>To: bricklen
>Cc: "pgsql-general@postgresql.org"
>Sent: Thursday, 28 November 2013, 16:03
>Subject: Re: [GENERAL] unnest on multi-dimensional arrays
>
>2013/11/28 bricklen
>
>On Wed, Nov 27, 2013 at 11:28 PM, Pavel Stehule
>wrote:
>>
>>Hello
>>>
>>>
>>>postgres=# CR
Tobadao wrote:
> Hello everyone.
> I'm using PostgreSQl 9.2 on the windows XP
> in recovery.conf use command
>
>
> *standby_mode = 'on'
> primary_conninfo = 'host=10.0.10.2 port=5432 user=postgres password =
> password'
> restore_command = 'copy 10.0.10.2\\archiver\\%f %p'
> restore_command
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 is subquery flattening:
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 nearl