From todhunter@interia.pl Fri Jun 4 17:02:43 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 605ADD1B187 for ; Fri, 4 Jun 2004 14:02:43 -0300 (ADT) 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 20242-03 for ; Fri, 4 Jun 2004 17:02:39 +0000 (GMT) Received: from eri.interia.pl (eri.interia.pl [217.74.65.138]) by svr1.postgresql.org (Postfix) with ESMTP id 7A4EBD1BAF8 for ; Fri, 4 Jun 2004 14:02:35 -0300 (ADT) Received: from poczta.interia.pl (egaheer.interia.pl [217.74.65.182]) by eri.interia.pl (Postfix) with ESMTP id CCCB826E62 for ; Fri, 4 Jun 2004 19:02:28 +0200 (CEST) Received: from 127.0.0.1 (localhost [127.0.0.1]) by system.wewnetrzny9 (poczta.interia.pl) with SMTP id 41FAB374171 for ; Fri, 4 Jun 2004 19:02:34 +0200 (CEST) Received: by poczta.interia.pl (poczta.interia.pl, from userid 502) id 27426374213; Fri, 4 Jun 2004 19:02:34 +0200 (CEST) Received: from zik (wi30.internetdsl.tpnet.pl [80.55.190.30]) by poczta.interia.pl (poczta.interia.pl) with ESMTP id 4E14637421C for ; Fri, 4 Jun 2004 19:02:33 +0200 (CEST) Message-ID: <000a01c44a55$ba46bc50$f1d4fea9@zik> From: "todhunter" To: Subject: Large database Date: Fri, 4 Jun 2004 19:02:32 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C44A66.7D323AE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/59 X-Sequence-Number: 13719 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C44A66.7D323AE0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable I'm considering using Postgresql for an application which could very likely= require a database to grow up to about 200 000 000 records in one table. 1. Is this possible with Postresql on Linux? 2. What's the biggest known database currently running on Postgresql? Thanks for your help! ------=_NextPart_000_0007_01C44A66.7D323AE0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
I'm considering using Postgresql for an ap= plication=20 which could very likely require a database to grow up to about 200 000= 000=20 records in one table.
 
1. Is this possible with Postresql on=20 Linux?
2. What's the biggest known database curre= ntly=20 running on Postgresql?
 
 
Thanks for your help!
<= /HTML> ------=_NextPart_000_0007_01C44A66.7D323AE0-- From s.barnett-cormack@lancaster.ac.uk Sun Jun 6 20:38:52 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2CEB2D1B1D1 for ; Sun, 6 Jun 2004 17:38:52 -0300 (ADT) 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 78576-10 for ; Sun, 6 Jun 2004 20:38:51 +0000 (GMT) Received: from ptb-relay03.plus.net (ptb-relay03.plus.net [212.159.14.214]) by svr1.postgresql.org (Postfix) with ESMTP id C3CF8D1B189 for ; Sun, 6 Jun 2004 17:38:47 -0300 (ADT) Received: from [212.159.87.229] (helo=thelabyrinth.force9.co.uk) by ptb-relay03.plus.net with esmtp (Exim) id 1BX4Po-0000xq-7l; Sun, 06 Jun 2004 20:38:48 +0000 Received: from ruth.localdomain (ruth.localdomain [192.168.0.1]) by thelabyrinth.force9.co.uk (Postfix) with ESMTP id B6D8930081; Sun, 6 Jun 2004 20:39:30 +0100 (BST) Date: Sun, 6 Jun 2004 21:39:55 +0100 (BST) From: Sam Barnett-Cormack X-X-Sender: sdb@localhost.localdomain To: todhunter Cc: pgsql-admin@postgresql.org Subject: Re: Large database In-Reply-To: <000a01c44a55$ba46bc50$f1d4fea9@zik> Message-ID: References: <000a01c44a55$ba46bc50$f1d4fea9@zik> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/64 X-Sequence-Number: 13724 On Fri, 4 Jun 2004, todhunter wrote: > I'm considering using Postgresql for an application which could very > likely require a database to grow up to about 200 000 000 records in > one table. > > 1. Is this possible with Postresql on Linux? Given that there are no theoretical limits of table length (IIRC), then yes. Performance may suffer. > 2. What's the biggest known database currently running on Postgresql? Well, UKMS is running a database that has a table with one record for every file or page served to any user. It's pretty big, at least of the order you describe. The size on disk of the database is 167GiB. It runs just fine, and that's on linux on intel hardware. -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University