Re: Performance inside and outside view ( WAS Re: Select the max on a field )

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Performance inside and outside view ( WAS Re: Select the max on a field )
Date: 2002-09-12 14:50:23
Message-ID: 7350.1031842223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Gaetano Mendola" <mendola(at)bigfoot(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-09-12 15:22:54 Re: Performance inside and outside view ( WAS Re: Select the
Previous Message Gaetano Mendola 2002-09-12 14:31:04 Performance inside and outside view ( WAS Re: Select the max on a field )