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 GAA21267 for postgres-redist; Wed, 30 Aug 1995 06:26:29 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199508301326.GAA21267@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 GAA26124 for ; Wed, 30 Aug 1995 06:26:24 -0700 Message-Id: <199508301326.GAA26124@nobozo.CS.Berkeley.EDU> Received: from rosiespc.ucd.ie by hermes.ucd.ie with SMTP (PP); Wed, 30 Aug 1995 14:25:16 +0100 Comments: Authenticated sender is From: Rosemarie Power Organization: University College Dublin To: postgres@postgres.Berkeley.EDU Date: Wed, 30 Aug 1995 14:24:38 +0100 (BST) Subject: Re: 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: Wed, 30 Aug 95 06:26:29 -0700 Resent-XMts: smtp >From: Rosemarie Power >Organization: University College Dublin >To: postgres@nobozo.CS.Berkeley.EDU >Date: Mon, 28 Aug 1995 09:56:15 +0100 (BST) >Subject: Slow Postgres performance >Cc: arthur@midir.ucd.ie >Priority: normal >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? > We are going to try rebuilding the OSF v3.2 version with gcc instead of cc and see what happens. I wonder if installing postgres95 is worth trying, does anyone know if it has the same problems? >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/ 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/