Re: Large database

From: Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk>
To: todhunter <todhunter(at)interia(dot)pl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large database
Date: 2004-06-06 20:39:55
Message-ID: Pine.LNX.4.58.0406062134140.2203@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-06 21:37:23 Re: PostgreSQL Connection Problem via TCP/IP socket
Previous Message Tom Lane 2004-06-06 15:54:44 Re: createuser error