X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C285454D07 for ; Tue, 1 Mar 2005 12:40:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33677-05 for ; Tue, 1 Mar 2005 12:40:11 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id D1ABF5445B for ; Tue, 1 Mar 2005 12:40:10 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id D794A32098; Tue, 1 Mar 2005 13:40:12 +0100 (MET) From: Thomas Ganss X-Newsgroups: pgsql.performance Subject: Re: multi billion row tables: possible or insane? Date: Tue, 01 Mar 2005 13:40:23 +0100 Organization: T-Online Lines: 10 Message-ID: References: <42243725.6060804@sara.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet-abuse@t-online.de X-ID: VsS8k6Z-gepkdxZ98-3JKL1o0OnQ0qItSJQRlmArdCbQp85eSPMPUi User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: de-DE, de, en-us, en In-Reply-To: <42243725.6060804@sara.nl> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.174 tagged_above=0 required=5 tests=FORGED_YAHOO_RCVD X-Spam-Level: ** X-Archive-Number: 200503/22 X-Sequence-Number: 10727 Ramon Bastiaans schrieb: > My currect estimate is that I have to store (somehow) > around 1 billion values each month (possibly more). You should post the actual number or power of ten, since "billion" is not always interpreted the same way... rgds thomas