Postgres Pro
Downloads
Home   >   mailing lists

Re: UNION versus SUB SELECT - Mailing list pgsql-performance

From Robert DiFalco
Subject Re: UNION versus SUB SELECT
Date
Msg-id CAAXGW-wsORadahGhttPZZeQiSgsu+Z3JAKEHncusyCE6NV5YwA@mail.gmail.com
Whole thread Raw
In response to Re: UNION versus SUB SELECT  (bricklen <bricklen@gmail.com>)
List pgsql-performance
Tree view
No I didn't, thank you.  I missed the parens.


On Thu, Nov 21, 2013 at 2:58 PM, bricklen <bricklen@gmail.com> wrote:
On Thu, Nov 21, 2013 at 2:04 PM, Robert DiFalco <robert.difalco@gmail.com> wrote:
Hmmmm...I'm not sure why the buffers option didn't work for me, maybe the heroku psql is out of date.

Did you enclose it in brackets? Eg. "EXPLAIN (ANALYZE, BUFFERS) SELECT ..."

pgsql-performance by date:

Previous
From: bricklen
Date:
Subject: Re: UNION versus SUB SELECT
Next
From: Rogerio Pereira
Date:
Subject: Re: Query in cache