Re: [GENERAL] unnest on multi-dimensional arrays

2013-11-29 Thread Glyn Astill
From: Pavel Stehule pavel.steh...@gmail.com To: bricklen brick...@gmail.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Thursday, 28 November 2013, 16:03 Subject: Re: [GENERAL] unnest on multi-dimensional arrays 2013/11/28 bricklen brick...@gmail.com On Wed, Nov 27,

Re: [GENERAL] Error pg_standby 'pg_standby' is not recognized as an internal or external command!!

2013-11-29 Thread Albe Laurenz
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 =

Re: [GENERAL] What query optimisations are included in Postgresql?

2013-11-29 Thread Albe Laurenz
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:

Re: [GENERAL] What query optimisations are included in Postgresql?

2013-11-29 Thread John R Pierce
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