Re: Postgres does not utilize indexes. Why?

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Artimenko Igor" <igorart7(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres does not utilize indexes. Why?
Date: 2004-08-17 18:33:21
Message-ID: opscv25vr132xio3@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> test where id = 50000;” Few times I added 100,000 records, applied

cast the 50000 to int8 and it will use the index

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Lester 2004-08-17 20:02:49 Re: shared_buffers Question
Previous Message Duane Lee - EGOVX 2004-08-17 16:58:59 Re: General performance problem!