agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Rosemarie Power <rosemarie.power@ucd.ie>
To: postgres@postgres.Berkeley.EDU
Cc: arthur@midir.ucd.ie
Subject: Re: Slow Postgres performance
Date: Wed, 30 Aug 1995 14:24:38 +0100 (BST)
Message-ID: <199508301326.GAA26124@nobozo.CS.Berkeley.EDU> (raw)

>From:          Rosemarie Power <rosemarie.power@ucd.ie>
>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/

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: <199508301326.GAA26124@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