Re: [PERFORM] How to improve db performance with $7K?

2005-03-25 Thread Will LaShell
e, let me know and I'll get you the information. Sincerely, Will LaShell Steve Poe wrote: Situation: An 24/7 animal hospital (100 employees) runs their business on Centos 3.3 (RHEL 3) Postgres 7.4.2 (because they have to) off a 2-CPU Xeon 2.8MHz, 4GB of RAM, (3) SCSI disks RAID 0 (zcav valu

Re: [PERFORM] Follow-Up: How to improve db performance with $7K?

2005-04-02 Thread Will LaShell
Vivek Khera wrote: On Mar 31, 2005, at 9:01 PM, Steve Poe wrote: Now, we need to purchase a good U320 RAID card now. Any suggestions for those which run well under Linux? Not sure if it works with linux, but under FreeBSD 5, the LSI MegaRAID cards are well supported. You should be able to pick

Re: [PERFORM] Tuning PostgreSQL

2003-07-29 Thread Will LaShell
On Tue, 2003-07-29 at 08:14, Vivek Khera wrote: > > "GS" == Greg Stark <[EMAIL PROTECTED]> writes: > > GS> "scott.marlowe" <[EMAIL PROTECTED]> writes: > > GS> But you have to actually test your setup in practice to see if it > GS> hurts. A big data warehousing system will be faster under RAID

Re: [PERFORM] best arrangement of 3 disks for (insert) performance

2003-09-12 Thread Will LaShell
I would like to point out though on the PERC controllers that are LSI based ( Megaraid ) there -are- settings that can be changed to fix any o the performance issues. Check the linux megaraid driver list archives to see the full description. I've seen it come up many times and basically all the pr

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Will LaShell
maintained by the guys at LSI and their tech support personnel are very good as well. If you want any specific information or have any questions about our experience or configuration please feel free to contact me. Sincerely, Will LaShell > > HTH > > > > Matt > > >

Re: [PERFORM] PostgreSQL data on a NAS device ?

2003-10-20 Thread Will LaShell
an LSI Megaraid 1650 controller. I really believe you'll find either of those options to be superior in terms of price for you. Sincerely, Will LaShell > Does anyone have experience with this NAS device or other "SCSI-to-IDE" RAID > systems? Are they O

Re: [PERFORM] PostgreSQL data on a NAS device ?

2003-10-21 Thread Will LaShell
On Tue, 2003-10-21 at 08:40, scott.marlowe wrote: > So that brings up my question, which is better, the Perc4 or Perc3 > controllers, and what's the difference between them? I find Dell's > tendency to hide other people's hardware behind their own model numbers > mildly bothersome, as it makes

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on a NAS device ?

2003-10-21 Thread Will LaShell
On Tue, 2003-10-21 at 13:36, scott.marlowe wrote: > On 21 Oct 2003, Will LaShell wrote: > > > On Tue, 2003-10-21 at 08:40, scott.marlowe wrote: > > > > > So that brings up my question, which is better, the Perc4 or Perc3 > > > controllers, and what's th

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on a

2003-10-22 Thread Will LaShell
Heya On Wed, 2003-10-22 at 01:13, Alexander Priem wrote: > So I guess the PERC4/Di RAID controller is pretty good. It seems that > RedHat9 supports it out-of-the-box (driver 1.18f), but I gather from the > sites mentioned before that upgrading this driver to 1.18i would be > better... Actually up

Re: [PERFORM] RedHat Enterprise Linux ES 3 ?!?!

2003-10-23 Thread Will LaShell
On Thu, 2003-10-23 at 01:40, Alexander Priem wrote: > Hi guys, > > This basically continues the other thread about the PERC4 RAID controller, > but since it is a bit off-topic I thought to start another thread. Thanks > for all your help so far :) > > Earlier today I read about the newly releas

Re: [PERFORM] RedHat Enterprise Linux ES 3 ?!?!

2003-10-23 Thread Will LaShell
On Thu, 2003-10-23 at 08:44, Robert Treat wrote: > On Thu, 2003-10-23 at 11:27, Will LaShell wrote: > > > Also, I cannot find any list of packages included in Enterprise Linux > > 2.1 / > > > 3. Does anyone know if PostgreSQL is included and if so, what version? > &g

Re: [PERFORM] Help with count(*)

2003-11-14 Thread Will LaShell
Hannu Krosing wrote: Christopher Browne kirjutas R, 14.11.2003 kell 16:13: Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Rajesh Kumar Mallah) wrote: INFO: "profiles": found 0 removable, 369195 nonremovable row versions in 43423 pages DETAIL: 246130 dead row versions canno