Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502151523.HAA14544@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Wed, 15 Feb 1995 16:16:16 +0100
From: David Bigagli <david@naxos.caspur.it>
Message-Id: <9502151516.AA18539@naxos.caspur.it>
To: postgres@postgres.Berkeley.EDU
Subject: postgres is slow?
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 15 Feb 95 07:23:12 -0800
Resent-XMts: smtp


 Hi all,
  we are using postgres as our database for users accounting. We have
  two milions of records in the db.  Each instance has 8 fields.
  We defined an index on one of these fileds. When we run a query on
  all records, i.e. from the initial time of accounting up today
  postgres takes 11 minutes to give us the answer. This seems to us to be
  very slow and not acceptable. We also have observed that if we define
  another index the performance slow down. Do you have any idea why the
  postgres is so slow?
  We are using the libpq interface to our queries. When the request to
  postgres is running whe see that the cpu is very busy
  and the VSZ and RSZ fields grow up. This is an indication that postgres
  is working in memory, (copying buffers??).  Is it possible to
  retrieve data directly from db bypassing the portal?
  Any help will be appreciated,thanks

                                David&Ruten
~

==============================================================================
   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/