agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Rosemarie Power <rosemarie.power@ucd.ie>
To: postgres@postgres.Berkeley.EDU
Cc: arthur@midir.ucd.ie
Subject: Slow Postgres performance
Date: Mon, 28 Aug 1995 09:56:15 +0100 (BST)
Message-ID: <199508280857.BAA07421@nobozo.CS.Berkeley.EDU> (raw)
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 equivalent 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?
Thanks for any and all assistance ...
Regards,
Rosemarie Power,
Systems Management Group,
U.C.D. Computing Services.
Tel.: +353 1 7062429.
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: rosemarie.power@ucd.ie, arthur@midir.ucd.ie
Subject: Re: Slow Postgres performance
In-Reply-To: <199508280857.BAA07421@nobozo.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox