Home > mailing lists

Re: Postgres does not utilize indexes. Why? - Mailing list pgsql-performance

From	Pierre-Frédéric Caillaud
Subject	Re: Postgres does not utilize indexes. Why?
Date	August 17, 2004 18:32:48
Msg-id	opscv25vr132xio3@musicbox Whole thread Raw
In response to	Postgres does not utilize indexes. Why? (Artimenko Igor <igorart7@yahoo.com>)
List	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

From: Duane Lee - EGOVX
Date: 17 August 2004, 16:59:16
Subject: Re: General performance problem!

From: Joe Lester
Date: 17 August 2004, 20:03:06
Subject: Re: shared_buffers Question