Postgres under OSF/1 v3.2 -- slow searches?

From: <arthur_at_midir.ucd.ie>
Date: Fri, 25 Aug 95 17:45:01 +0100

Greetings -

We have Postgres (database) installed on two OSF/1 systems here, one being a
3000/300 LX with 32 MB memory running OSF v1.3 (which I think has a 100 MHz
CPU), the other being a 2000 4/233 with 128 MB memory running OSF v3.2. We've
just installed Postgres on the 2000.

We've experienced severe performance problems with Postgres on the 2000 which
occur when doing searches (and may occur on other actions as well). The system
is running at least 5 times slower than the equivlent search on the 3000. The
search uses the regexp library. The problem doesn't appear if we copy the
binaries from the 3000, rather than those built on the 2000.

Note that these problems are with Postgres -- the 2000 is humming along nicely
while the search goes on.

Build details are:

        2000 : Postgres v4.2 built using OSF v3.2 cc

        3000 : Postgres v4.2 built using either OSF v1.3 cc or GCC v2.5.8

My question is: is there a known problem with the regexp library supplied with
OSF v3.2?

I will summarise and reply to the list. Thanks for any and all assistance ...

 - Arthur Green
   University College Dublin Computing Services
   Tel: +353 1 7062456 Fax: +353 1 283 7077 E-mail: arthur_at_midir.ucd.ie
Received on Fri Aug 25 1995 - 19:07:51 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:45 NZDT