Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id BAA06314 for postgres-redist; Mon, 28 Aug 1995 01:57:37 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199508280857.BAA06314@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from hermes.ucd.ie (hermes.ucd.ie [137.43.1.49]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id BAA07421 for ; Mon, 28 Aug 1995 01:57:27 -0700 Message-Id: <199508280857.BAA07421@nobozo.CS.Berkeley.EDU> Received: from rosiespc.ucd.ie by hermes.ucd.ie with SMTP (PP); Mon, 28 Aug 1995 09:56:46 +0100 Comments: Authenticated sender is From: Rosemarie Power Organization: University College Dublin To: postgres@postgres.Berkeley.EDU Date: Mon, 28 Aug 1995 09:56:15 +0100 (BST) Subject: Slow Postgres performance CC: arthur@midir.ucd.ie Priority: normal X-mailer: Pegasus Mail for Windows (v2.01) Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Mon, 28 Aug 95 01:57:36 -0700 Resent-XMts: smtp 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/