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 RAID5 GS than under

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

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Will LaShell
, Will LaShell HTH Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Jones Sent: 27 September 2003 18:25 To: [EMAIL PROTECTED] Subject: [PERFORM] advice on raid controller Hi, i'm on the verge of buying

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

2003-10-20 Thread Will LaShell
for you. Sincerely, Will LaShell Does anyone have experience with this NAS device or other SCSI-to-IDE RAID systems? Are they OK in terms of performance and reliability? Kind regards, Alexander. ---(end of broadcast)--- TIP 7: don't forget

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: SNIP 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

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: SNIP 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

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

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 released

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? You have two options as I understand

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 cannot

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

2005-03-25 Thread Will LaShell
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 value 35MB per sec

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