Postgres Pro
Downloads
Home   >   mailing lists

Re: huge disparities in =/IN/BETWEEN performance - Mailing list pgsql-sql

From Tom Lane
Subject Re: huge disparities in =/IN/BETWEEN performance
Date
Msg-id 7377.1170986068@sss.pgh.pa.us
Whole thread Raw
In response to huge disparities in =/IN/BETWEEN performance  ("George Pavlov" <gpavlov@mynewplace.com>)
Responses Re: huge disparities in =/IN/BETWEEN performance  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-sql
Tree view 
"George Pavlov" <gpavlov@mynewplace.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

pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: Seeking quick way to clone a row, but give it a new pk.
Next
From: "George Pavlov"
Date:
Subject: Re: huge disparities in =/IN/BETWEEN performance