Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to eliminate union and sort - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Trying to eliminate union and sort
Date
Msg-id 51E086A1.2080504@agliodbs.com
Whole thread Raw
In response to Trying to eliminate union and sort  (Brian Fehrle <brianf@consistentstate.com>)
Responses Re: Trying to eliminate union and sort  (Brian Fehrle <brianf@consistentstate.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Brian Fehrle
Date:
Subject: Re: Trying to eliminate union and sort
Next
From: Jeff Janes
Date:
Subject: Re: In progress INSERT wrecks plans on table