Re: [GENERAL] unnest on multi-dimensional arrays

2013-11-29 Thread Glyn Astill
> 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

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 nearl