From: Jim C. Nasby <jnasby@pervasive.com>
To: Tomka Gergely <tomka@zeus.gau.hu>
Cc: psql performance list <pgsql-performance@postgresql.org>
Subject: Re: big databases & hospitals
Date: Tue, 17 Jan 2006 14:36:24 -0600
Message-ID: <20060117203624.GC17896@pervasive.com> (raw)
In-Reply-To: <Pine.LNX.4.58.0601141307480.26994@zeus.gau.hu>
References: <Pine.LNX.4.58.0601141307480.26994@zeus.gau.hu>
On Sat, Jan 14, 2006 at 01:13:02PM +0100, Tomka Gergely wrote:
> Hi!
>
> I need to write a few pages about Postgresql, to convince some suits. They
> have a few millions of records, on a few site, but they want to know the
> practical limits of Postgresql. So i need some information about the
> biggest (in storage space, in record number, in field number, and maybe
> table number) postgresql databases.
>
> Additionally, because this company develops hospital information systems,
> if someone knows about a medical institute, which uses Postgresql, and
> happy, please send me infomation. I only now subscribed to the advocacy
> list, and only started to browse the archives.
We have a customer that has around 5000 tables and hasn't had any
serious issues from that number of tables (other than \d sometimes not
working in psql, but IIRC Tom put a fix in for that already).
As for raw size, 100G databases are pretty common. If you search through
the list archives you can probably find some examples.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, tomka@zeus.gau.hu
Subject: Re: big databases & hospitals
In-Reply-To: <20060117203624.GC17896@pervasive.com>
* 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