Re: huge disparities in =/IN/BETWEEN performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: huge disparities in =/IN/BETWEEN performance
Date: 2007-02-09 01:54:28
Message-ID: 7377.1170986068@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"George Pavlov" <gpavlov(at)mynewplace(dot)com> writes:
> there is, admittedly, substantial complexity inside v_foo, with GROUP
> BYs on user_id and various subqueries, but my basic thought is that
> should not really matter...

You're unlikely to get any useful comment on this when you have not
shown any of those details, nor even an EXPLAIN.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message George Pavlov 2007-02-09 02:03:40 Re: huge disparities in =/IN/BETWEEN performance
Previous Message John DeSoi 2007-02-09 00:09:32 Re: Seeking quick way to clone a row, but give it a new pk.