pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
To: todhunter <todhunter@interia.pl>
Cc: pgsql-admin@postgresql.org
Subject: Re: Large database
Date: Sun, 6 Jun 2004 21:39:55 +0100 (BST)
Message-ID: <Pine.LNX.4.58.0406062134140.2203@localhost.localdomain> (raw)
In-Reply-To: <000a01c44a55$ba46bc50$f1d4fea9@zik>
References: <000a01c44a55$ba46bc50$f1d4fea9@zik>

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



view thread (2+ messages)

Message-ID: <Pine.LNX.4.58.0406062134140.2203@localhost.localdomain>
Permalink:  ../Pine.LNX.4.58.0406062134140.2203@localhost.localdomain/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0406062134140.2203@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: s.barnett-cormack@lancaster.ac.uk, todhunter@interia.pl
  Subject: Re: Large database
  In-Reply-To: <Pine.LNX.4.58.0406062134140.2203@localhost.localdomain>
  References: <000a01c44a55$ba46bc50$f1d4fea9@zik> <Pine.LNX.4.58.0406062134140.2203@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox