Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DF5199FA66C; Thu, 18 Jan 2007 18:42:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 41626-01; Thu, 18 Jan 2007 18:41:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exprod6og52.obsmtp.com (exprod6og52.obsmtp.com [64.18.1.185]) by postgresql.org (Postfix) with SMTP id A61B49FA2FC; Thu, 18 Jan 2007 18:42:00 -0400 (AST) Received: from source ([63.240.6.46]) (using TLSv1) by exprod6ob52.postini.com ([64.18.5.12]) with SMTP; Thu, 18 Jan 2007 14:41:42 PST Received: from 172.16.1.110 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Thu, 18 Jan 2007 17:41:32 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.164]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 18 Jan 2007 17:41:31 -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 ; Thu, 18 Jan 2007 22:41:32 +0000 User-Agent: Microsoft-Entourage/11.3.3.061214 Date: Thu, 18 Jan 2007 14:41:30 -0800 Subject: Re: Postgres and really huge tables From: "Luke Lonergan" To: "Chris Mair" , "Brian Hurt" cc: pgsql-performance@postgresql.org, pgsql-advocacy@postgresql.org Message-ID: Thread-Topic: [pgsql-advocacy] Postgres and really huge tables Thread-Index: Acc7Ucu+Ckj2kqdFEdubbAAWy4o9DA== In-Reply-To: <45AFE9D0.6060205@1006.org> MIME-Version: 1.0 X-OriginalArrivalTime: 18 Jan 2007 22:41:31.0946 (UTC) FILETIME=[CCE778A0:01C73B51] X-WSS-ID: 69B128160K02250227-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/58 X-Sequence-Number: 10540 Chris, On 1/18/07 1:42 PM, "Chris Mair" wrote: > A lot of data, but not a lot of records... I don't know if that's > valid. I guess the people at Greenplum and/or Sun have more exciting > stories ;) You guess correctly :-) Given that we're Postgres 8.2, etc compatible, that might answer Brian's coworker's question. Soon we will be able to see that Greenplum/Postgres are handling the world's largest databases both in record count and size. While the parallel scaling technology we employ is closed source, we are still contributing scaling technology to the community (partitioning, bitmap index, sort improvements, resource management, more to come), so Postgres as a "bet" is likely safer and better than a completely closed source commercial product. - Luke