[PERFORM] Anyone running Intel S3700 SSDs?

2013-03-07 Thread CSS
Considering this list is where I first learned of the Intel 320 drives (AFAIK, the only non-enterprise SSDs that are power-failure safe), I thought I'd see if any of the folks here that tend to test new stuff have got their hands on these yet. I had no idea these drives were out (but they still

Re: [PERFORM] Poor plan when joining against a union containing a join

2013-03-07 Thread Tom Lane
David Leverton writes: > On 7 March 2013 05:52, Tom Lane wrote: >> Josh Berkus writes: >>> Actually, in case #4, Postgres *is* pushing down the join qual into the >>> segments of the Union. >> Yeah, but not further. I believe the core issue here (as of 9.2) is >> that we're not willing to gene

Re: [PERFORM] Poor plan when joining against a union containing a join

2013-03-07 Thread David Leverton
On 7 March 2013 05:52, Tom Lane wrote: > Josh Berkus writes: >> On 03/06/2013 06:54 AM, David Leverton wrote: >>> I'm encountering very poor query plans when joining against a union, > >> Actually, in case #4, Postgres *is* pushing down the join qual into the >> segments of the Union. > > Yeah, b