Mark Alliban wrote:
>
> 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?
Pardon me for asking what may be obvious, but are you running 'vacuum
analyze' regularly? If not, that may fix the problem.
Cheers,
Ed Loehr