[Info-Ingres] Ingres 2.6 on Solaris 10: createdb slow

[martin.bowes at ctsu.ox.ac.uk]

Hi Wiliam,
>  I checked the outputs of printqry on the createdb command and there'
>  nothing that is really slow in the output (attached). The Solaris
>  version seems to be consistently slow across most of the SQL
>  statements.
Yep that seems to be the case, over a minute slower with no good 
reason. I suspect that both disk systems are running Raid 5 so I think 
we can rule out Ingres specific stuff.

Have you run iostat on the Solaris box to see if the disks are being 
swamped? Is there any sign of the Raid5 on Solaris running in a 
degraded mode? Any signs of CPU or memory stress.

>  P.S. Louie's a good boy, bonking him on the head with a bottle of
>  white wine does wonders for de-stressing ;)

I never though of Louie as a white wine sort of guy.

Tell him to warm up the barby. I expect to be placated with Red Meat.

> 
>  P.P.S. We stuck it up the Bombers -- reminded me of the 99' prelim
>  final where we beat the Dons by a point (I have fond memories of
>  being at the MCG on that day).

Mmm. I remember the 94 elim final against the Bombers when Knighter 
kept us in it with 4 goals up to half time. After the break we reeled in the 
30+ deficit and creamed 'em, in the last quarter. Happy Days!

Now if only the Tiges could win a friggen game, I'd be a lot happier. We 
got the Eagles next week and then the Cats. So things may get worse 
before they get better.

Will Feva get off?

Marty

PS. Sorry about going off topic, but I'm being forced to talk footy with 
Sydney-siders up here. They couldn't draw a crowd in Sydney with a 
pencil.