X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id B917111F6106 for ; Thu, 20 Apr 2006 11:32:00 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.964 X-Spam-Level: X-Spam-Status: No, score=-0.964 required=5 tests=[BAYES_00=-2.599, FORGED_RCVD_HELO=0.135, RCVD_NUMERIC_HELO=1.5] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id roKH-eqEb9CD for ; Thu, 20 Apr 2006 11:31:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw04.mi8.com [63.240.6.44]) by postgresql.org (Postfix) with ESMTP id 1429111F6558 for ; Thu, 20 Apr 2006 11:31:48 -0300 (ADT) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Thu, 20 Apr 2006 10:31:37 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 20 Apr 2006 10:31:35 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Thu, 20 Apr 2006 14:31:34 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Thu, 20 Apr 2006 07:31:33 -0700 Subject: Re: Quick Performance Poll From: "Luke Lonergan" To: jim@contactbda.com, "Simon Dale" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Quick Performance Poll Thread-Index: AcZkf612f9UYUtDBQT2OSMGGcRl8iwAB3GKr In-Reply-To: <20060420133326.M88248@contactbda.com> MIME-Version: 1.0 X-OriginalArrivalTime: 20 Apr 2006 14:31:35.0523 (UTC) FILETIME=[207F8B30:01C66487] X-WSS-ID: 685944CD20C48462936-02-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/448 X-Sequence-Number: 18532 Jim, On 4/20/06 6:36 AM, "Jim Buttafuoco" wrote: > The access is very fast when looking for a small subset of the data. I guess you are not using indexes because building a (non bitmap) index on 6TB on a single machine would take days if not weeks. So if you are using table partitioning, do you have to refer to each child table separately in your queries? - Luke