Thread: Re: [GENERAL] Re: Poor performance - need advice

Re: [GENERAL] Re: Poor performance - need advice

From
"Mark Alliban"
Date:
Thnks Phil,

You hit the nail on the head. Problem solved :)

Mark.

>I'm pretty sure I have seen a similar post before. The problem is that
>Postgres assumes the constant you are using is an int4.  Try casting it to
>int8 and see if that helps.
>
>SELECT * FROM ClientTable WHERE ClientNumber=1234566789::int8;
>
>
>Phil Culberson
>DAT Services
>
>-----Original Message-----
>From: Mark Alliban [mailto:MarkA@idnltd.com]
>Sent: Wednesday, February 02, 2000 10:16 AM
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] Re: Poor performance - need advice
>
>
>>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?
>
>
>I have tried an EXPLAIN of the above statement, and it tells me that
>Postgres is doing a Seq Scan on the table to return the results, even
though
>it should be using the index. How can I make sure that it will always use
>the index when I specify ClientNumber?
>
>
>************
>
>************
>