Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance inside and outside view ( WAS Re: Select the max on a field ) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Performance inside and outside view ( WAS Re: Select the max on a field )
Date
Msg-id 7350.1031842223@sss.pgh.pa.us
Whole thread Raw
In response to Performance inside and outside view ( WAS Re: Select the max on a field )  ("Gaetano Mendola" <mendola@bigfoot.com>)
Responses Re: Performance inside and outside view ( WAS Re: Select the  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> Yes that's right it's help me,
> but here the optimizer have some problems:

What's the datatype of id_user, and why are you quoting the compared
constant in some cases but not others?  I don't think the difference
has anything to do with the view here ...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Performance inside and outside view ( WAS Re: Select the max on a field )
Next
From: Stephan Szabo
Date:
Subject: Re: Performance inside and outside view ( WAS Re: Select the