Horton

Re: optimizing Postgres queries

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: David Teran <david.teran@cluster9.com>
Cc: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>, pgsql-performance@postgresql.org
Date: 2004-01-05T15:15:27Z
Lists: pgsql-performance 
> explain analyze SELECT --columns-- FROM KEY_VALUE_META_DATA t0 WHERE 
> t0.ID_FOREIGN_TABLE = 21110::bigint;
> 
> an index is used. Very fine, the performance is about 10 to 100 times 
> faster for the single select.

An alternative technique is to do this:

... t0.ID_FOREIGN_TABLE = '21110';

Chris