Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 696B39FB447
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 30 Jan 2007 19:18:15 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 33409-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 30 Jan 2007 19:18:14 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from exprod6og53.obsmtp.com (exprod6og53.obsmtp.com [64.18.1.187])
	by postgresql.org (Postfix) with SMTP id B37AA9FB446
	for <pgsql-performance@postgresql.org>;
	Tue, 30 Jan 2007 19:18:10 -0400 (AST)
Received: from source ([63.240.6.47]) (using TLSv1) by exprod6ob53.postini.com
	([64.18.5.12]) with SMTP; Tue, 30 Jan 2007 15:18:02 PST
Received: from 172.16.1.114 by mail.Mi8.com with ESMTP (- Welcome to Mi8
	Corporation www.Mi8.com (D1)); Tue, 30 Jan 2007 18:17:51 -0500
X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774
Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.164]) by
	d01smtp07.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 30 Jan
	2007 18:17:50 -0500
Received: from 63.80.24.130 ([63.80.24.130]) by MI8NYCMAIL08.Mi8.com (
	[172.16.1.190]) via Exchange Front-End Server mi8owa.mi8.com (
	[172.16.1.134]) with Microsoft Exchange Server HTTP-DAV ; Tue, 30 Jan
	2007 23:17:50 +0000
User-Agent: Microsoft-Entourage/11.3.3.061214
Date: Tue, 30 Jan 2007 15:17:48 -0800
Subject: Re: Querying distinct values from a large table
From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Josh Berkus" <josh@agliodbs.com>,
	pgsql-performance@postgresql.org
cc: "Alvaro Herrera" <alvherre@commandprompt.com>,
	"Gregory Stark" <gsstark@mit.edu>, "Chad Wagner" <chad.wagner@gmail.com>,
	"Simon Riggs" <simon@2ndquadrant.com>,
	"Igor Lobanov" <ilobanov@swsoft.com>, "Richard Huxton" <dev@archonet.com>
Message-ID: <C1E5121C.19AD1%llonergan@greenplum.com>
Thread-Topic: [PERFORM] Querying distinct values from a large table
Thread-Index: AcdExNrjGYcOI7C4EduYNwAWy4o9DA==
In-Reply-To: <200701301500.43857.josh@agliodbs.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 30 Jan 2007 23:17:50.0675 (UTC)
	FILETIME=[DC7C2230:01C744C4]
X-WSS-ID: 69A10D954GW1083488-01-01
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/441
X-Sequence-Number: 23042

Argh!

             ###                   #######
            #####        ####################
            #####    #########################
             ###             ###############
                   
                   #####
                ##########
              ##############     ##########
             #####      #####   ############
            ###             #################
            ##               ######        ###
            #               ######          ##
            #              ######            #
            ##             #####            ##
            ###           #######           ##
             #####     ######## ####     ####
              ################    ##########
               ##############       ######
                 #########
                   
                       ##
                       ##
                       ##
                       ##
                       ##
                       ##
                       ##
                       ##
                       ##
                       ##
                   
            ###                            ###
             ########                #########
             ################################
                ##########################
                    ##################
                        ##########



On 1/30/07 3:00 PM, "Josh Berkus" <josh@agliodbs.com> wrote:

> 
> -- 
> --Josh
> 
> Josh Berkus
> PostgreSQL @ Sun
> San Francisco
>