[PERFORM] big databases hospitals

2006-01-14 Thread Tomka Gergely
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

Re: [PERFORM] big databases hospitals

2006-01-14 Thread Javier Carlos
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

Re: [PERFORM] big databases hospitals

2006-01-14 Thread Tomka Gergely
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

Re: [PERFORM] Hanging Query

2006-01-14 Thread Tom Lane
[EMAIL PROTECTED] writes: We have to inserts a records(15000- 2) into a table which also contains (15000-2) records, then after insertion, we have to delete the records according to a business rule. Above process is taking place in a transaction and we are using batches of 128 to

Re: [PERFORM] = forces row compare and not index elements compare when possible

2006-01-14 Thread Tom Lane
Bernard Dhooghe [EMAIL PROTECTED] writes: So = (or =) is not optimized against an index where it could be. Work in progress... regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

[PERFORM] Ensuring data integrity with fsync=off

2006-01-14 Thread Benjamin Arai
I have been working on optimizing a PostgreSQL server for weekly updates where data is only updated once a week then for the remaining portion of the week the data is static. So far I have set fsync to off and increased the segment size among other things. I need to ensure that at the end

Re: [PERFORM] big databases hospitals

2006-01-14 Thread Chris Mair
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

Re: [PERFORM] Ensuring data integrity with fsync=off

2006-01-14 Thread Tom Lane
Benjamin Arai [EMAIL PROTECTED] writes: Right now I run sync afte the updates have finished to ensure that the data is synced to disk but I am concerned about the segment data and anything else I am missing that PostgreSQL explicitly handles. Is there something I can do in addition to sync to

Re: [PERFORM] big databases hospitals

2006-01-14 Thread Jaime Casanova
On 1/14/06, Tomka Gergely [EMAIL PROTECTED] 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

Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Charles Sprickman
Following up to myself again... On Wed, 14 Dec 2005, Charles Sprickman wrote: Hello all, Supermicro 1U w/SCA backplane and 4 bays 2x2.8 GHz Xeons Adaptec 2015S zero channel RAID card I don't want to throw away the four machines like that that we have. I do want to throw away the ZCR

Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Charles Sprickman
On Sat, 14 Jan 2006, Luke Lonergan wrote: Charles, On 1/14/06 6:37 PM, Charles Sprickman [EMAIL PROTECTED] wrote: I'm vaguely considering pairing these two devices: http://www.areca.us/products/html/products.htm That's an Areca 16 channel SATA II (I haven't even read up on what's new in

Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Luke Lonergan
Charles, On 1/14/06 6:37 PM, Charles Sprickman [EMAIL PROTECTED] wrote: I'm vaguely considering pairing these two devices: http://www.areca.us/products/html/products.htm That's an Areca 16 channel SATA II (I haven't even read up on what's new in SATA II) RAID controller with an optional