Re: optimizing Postgres queries - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: optimizing Postgres queries
Date
Msg-id 3FF97F8F.6040305@familyhealth.com.au
Whole thread Raw
In response to Re: optimizing Postgres queries  (David Teran <david.teran@cluster9.com>)
List 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

pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: optimizing Postgres queries
Next
From: Tom Lane
Date:
Subject: Re: optimizing Postgres queries