Re: huge disparities in =/IN/BETWEEN performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe <dev(at)freedomcircle(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, George Pavlov <gpavlov(at)mynewplace(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: huge disparities in =/IN/BETWEEN performance
Date: 2007-02-09 04:24:44
Message-ID: 14627.1170995084@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Joe <dev(at)freedomcircle(dot)net> writes:
> Are you saying the planner is datatype-agnostic

Certainly, but your other concerns don't follow from that. The issue at
hand here is whether it's worth expending cycles on every query to try
to detect a situation that only holds for a few.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Arulmani V A 2007-02-09 04:25:58 unsubscribe
Previous Message Joe 2007-02-09 04:12:14 Re: huge disparities in =/IN/BETWEEN performance