pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedbig databases & hospitals
6+ messages / 5 participants
[nested] [flat]
* big databases & hospitals
@ 2006-01-14 12:13 Tomka Gergely <tomka@zeus.gau.hu>
2006-01-14 14:51 ` Re: big databases & hospitals Javier Carlos <nediam@nediam.com.mx>
2006-01-14 17:37 ` Re: big databases & hospitals Chris Mair <list@1006.org>
2006-01-14 20:31 ` Re: big databases & hospitals Jaime Casanova <systemguards@gmail.com>
2006-01-17 20:36 ` Re: big databases & hospitals Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 4 replies; 6+ messages in thread
From: Tomka Gergely @ 2006-01-14 12:13 UTC (permalink / raw)
To: pgsql-performance
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.
Thanks.
--
Tomka Gergely
Tudom, anyu. Sapka, sál, doksi.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: big databases & hospitals
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
@ 2006-01-14 14:51 ` Javier Carlos <nediam@nediam.com.mx>
3 siblings, 0 replies; 6+ messages in thread
From: Javier Carlos @ 2006-01-14 14:51 UTC (permalink / raw)
To: Tomka Gergely <tomka@zeus.gau.hu>; pgsql-performance
This is the homepage of a Hospital/Healthservice Information System, I'm
not so sure but I think it can use various DBMS, including PostgreSQL:
http://www.care2x.org/
Regards,
Javier
On Sat, 14 Jan 2006 13:13:02 +0100 (CET), 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.
>
> Thanks.
>
> --
> Tomka Gergely
> Tudom, anyu. Sapka, sál, doksi.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
nediam.com.mx
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: big databases & hospitals
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
@ 2006-01-14 17:37 ` Chris Mair <list@1006.org>
2006-01-14 17:55 ` Re: big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
3 siblings, 1 reply; 6+ messages in thread
From: Chris Mair @ 2006-01-14 17:37 UTC (permalink / raw)
To: Tomka Gergely <tomka@zeus.gau.hu>; +Cc: pgsql-performance
> 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.
Hi,
have you seen this case study:
http://www.postgresql.org/about/casestudies/shannonmedical
Bye, Chris.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: big databases & hospitals
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
2006-01-14 17:37 ` Re: big databases & hospitals Chris Mair <list@1006.org>
@ 2006-01-14 17:55 ` Tomka Gergely <tomka@zeus.gau.hu>
0 siblings, 0 replies; 6+ messages in thread
From: Tomka Gergely @ 2006-01-14 17:55 UTC (permalink / raw)
To: Chris Mair <list@1006.org>; +Cc: pgsql-performance
2006-01-14 ragyogó napján Chris Mair ezt üzente:
>
> > 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.
>
> Hi,
>
> have you seen this case study:
> http://www.postgresql.org/about/casestudies/shannonmedical
Yes, and i found this page:
http://advocacy.daemonnews.org/viewtopic.php?t=82
which is better than this small something on the postgres page. Quotes
like this:
"The FreeBSD/PostgreSQL combination is extremely flexible and
robust."
the sweetest music for us. But two example better than one, and i can't
find technical details, the size of the data, by example. I can only guess
the architecture (single node, single cpu, no HA or expensive RAID,
because AFAIK FreeBSD in 2000 was not to good in this areas).
Thanks, of course!
--
Tomka Gergely
Tudom, anyu. Sapka, sál, doksi.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: big databases & hospitals
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
@ 2006-01-14 20:31 ` Jaime Casanova <systemguards@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Jaime Casanova @ 2006-01-14 20:31 UTC (permalink / raw)
To: Tomka Gergely <tomka@zeus.gau.hu>; +Cc: pgsql-performance
On 1/14/06, Tomka Gergely <tomka@zeus.gau.hu> 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.
>
here you can see some limits of postgresql:
http://www.postgresql.org/about/
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: big databases & hospitals
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
@ 2006-01-17 20:36 ` Jim C. Nasby <jnasby@pervasive.com>
3 siblings, 0 replies; 6+ messages in thread
From: Jim C. Nasby @ 2006-01-17 20:36 UTC (permalink / raw)
To: Tomka Gergely <tomka@zeus.gau.hu>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-01-17 20:36 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-14 12:13 big databases & hospitals Tomka Gergely <tomka@zeus.gau.hu>
2006-01-14 14:51 ` Javier Carlos <nediam@nediam.com.mx>
2006-01-14 17:37 ` Chris Mair <list@1006.org>
2006-01-14 17:55 ` Tomka Gergely <tomka@zeus.gau.hu>
2006-01-14 20:31 ` Jaime Casanova <systemguards@gmail.com>
2006-01-17 20:36 ` Jim C. Nasby <jnasby@pervasive.com>
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