Re: optimizing Postgres queries

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: optimizing Postgres queries
Date: 2004-01-05 15:15:27
Message-ID: 3FF97F8F.6040305@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-01-05 15:22:32 Re: optimizing Postgres queries
Previous Message Shridhar Daithankar 2004-01-05 12:37:53 Re: optimizing Postgres queries