Search Postgresql Archives

Re: optimization issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Lewis,

I am new to postgres.

Could you tell me how should I put the result on an analyzed temp table at least ?

Please suggest.




Regards.




On Thursday, July 8, 2021, Michael Lewis <mlewis@xxxxxxxxxxx> wrote:
((current_setting('env.groupid'::text))::integer)::numeric

If you pass this value in directly as part of the query string, how does it perform? It seems like calling the function to get this value may be creating a planning problem with the value unknown at plan time. If you were able to put the result on an analyzed temp table at least, I'd expect that the planner would have enough info to make good decisions.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux