Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Christopher Browne
> 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 thr

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

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 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 card

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 s

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 t

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 c

[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] >= 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 spac

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] 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

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 ab

[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 table