Home > mailing lists

Re: Overhead of union versus union all - Mailing list pgsql-general

From	Jeff Davis
Subject	Re: Overhead of union versus union all
Date	July 10, 2009 17:51:00
Msg-id	1247248307.26589.329.camel@monkey-cat.sm.truviso.com Whole thread Raw
In response to	Re: Overhead of union versus union all (Greg Stark <gsstark@mit.edu>)
List	pgsql-general

Tree view

On Fri, 2009-07-10 at 18:47 +0100, Greg Stark wrote:
> > -- foo has a primary key

> Well no, it's equivalent to SELECT DISTINCT * FROM foo;

I think you missed that "foo" has a primary key.

Regards,
    Jeff Davis

pgsql-general by date:

From: artacus@comcast.net
Date: 10 July 2009, 17:50:34
Subject: Re: XML import with DTD

From: Scott Marlowe
Date: 10 July 2009, 17:51:07
Subject: Re: Overhead of union versus union all

Re: Overhead of union versus union all - Mailing list pgsql-general

Previous

Next