pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Trying to eliminate union and sort
Date: Fri, 12 Jul 2013 15:43:45 -0700
Message-ID: <51E086A1.2080504@agliodbs.com> (raw)
In-Reply-To: <WM!f93ebef783f3ebd764319211a1fc2a061e1b3ac620f3e9be03f5427bcf9d16398234b8a0e70686bf34046da632bacb2e!@asav-1.01.com>
References: <51DEF924.1040809@consistentstate.com>
	<WM!193bd65d81fa7c39e56918332a81c274363f4bb6c8de7151691ea39398f8f9117cf6aec5b0fd2887b97b4b5a921c1aa8!@asav-1.01.com>
	<51DF51DA.7010509@agliodbs.com>
	<51E082D8.4030503@consistentstate.com>
	<WM!f93ebef783f3ebd764319211a1fc2a061e1b3ac620f3e9be03f5427bcf9d16398234b8a0e70686bf34046da632bacb2e!@asav-1.01.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>


> As for the counts on the tables:
> table1      3,653,472
> table2      2,191,314
> table3    25,676,589
> 
> I think it's safe to assume right now that any resulting joins are not
> one-to-one

Hmmm?  How is doing a subselect in the SELECT clause even working, then?


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

view thread (7+ messages)  latest in thread

Message-ID: <51E086A1.2080504@agliodbs.com>
Permalink:  ../51E086A1.2080504@agliodbs.com/
Also on:    postgresql.org/message-id/51E086A1.2080504@agliodbs.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: Trying to eliminate union and sort
  In-Reply-To: <51E086A1.2080504@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox