Re: [Info-Ingres] Ingres on Itanium, not to good


Thanks for the info Karl,

I'll look into xfs, and maybe Linux LVM.


BTW: I'm really in the soup this morning.

Performance with 2.6/0604 was horrible until I deleted all the stats in our big tables.
With stats, no real QEP, just straight scans.
Without stats, the QEP will use the secondaries.

Still tweakin'

Andre





-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx [mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Karl & Betty Schendel
Sent: Thursday, December 06, 2007 9:33 AM
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] Ingres on Itanium, not to good

At 12:00 AM -0500 12/6/07, Laframboise André wrote:
Hi again Karl,

What's your view on Ingres 2006 on Linux ?

I suspect that's the first thing Ingres support will suggest.


We run our DW appliance on it. (x96_64, though, not Itanic.)

9.0.4 is good, and 9.1.0 is better. We did end up hacking around the 1024 fd thing, don't believe that's in the released code lines yet. (I think Ingres Corp wanted to fix it right and not use our hack, which I can't disagree with.) No other linux specific issues that I can think of offhand.

I do prefer xfs over ext3 for a data filesystem, however.
jfs is also good if you don't have too much write concurrency.
I have a patch to improve jfs file allocation with concurrent writers, it never got submitted though. xfs is our preference, because we've seen occasional hangs on jfs and we're not sure if it's jfs or something underneath.

--
Karl R. Schendel, Jr. schendel@xxxxxxxxxxxxxx
DATAllegro Inc
Ingres DBMS Server Development


_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

.

Relevant Pages