Poor performance - need advice

From: "Mark Alliban" <MarkA(at)idnltd(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Poor performance - need advice
Date: 2000-02-02 17:33:34
Message-ID: 006a01bf6da3$a241a090$c80110ac@centauri
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a table with 95,000 records, indexed on an int8 type (ClientNumber).
It is currently taking up to 10 seconds to retrieve one row based upon the
following statement:

SELECT * FROM ClientTable WHERE ClientNumber=1234566789;

The client numbers are random and there is currently no locking on the
database. I am running SCO OpenServer, PostgreSQL version 6.5.3. Is there
any way we can reduce the time taken by this query?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Siegemund 2000-02-02 18:15:37 shared memory problems
Previous Message Bertrand Bourdon 2000-02-02 16:55:24