agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: David Bigagli <david@naxos.caspur.it>
To: postgres@postgres.Berkeley.EDU
Subject: postgres is slow?
Date: Wed, 15 Feb 1995 16:16:16 +0100
Message-ID: <9502151516.AA18539@naxos.caspur.it> (raw)


 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/

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: david@naxos.caspur.it
  Subject: Re: postgres is slow?
  In-Reply-To: <9502151516.AA18539@naxos.caspur.it>

* 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