Thread: BUG #15924: Query Execution and variable declaration

BUG #15924: Query Execution and variable declaration

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      15924
Logged by:          Abhishek Sharma
Email address:      abhi30572@gmail.com
PostgreSQL version: 10.0
Operating system:   Windows 7
Description:

The query which is having joins and foreign table taking too much time to
get execute as compared to sql server. Also variable declaration and use in
sql server is very easy as compare to postgresql. Kindly work on variable
declaration and make it easy to use. Facing lot of due to above reason.


Re: BUG #15924: Query Execution and variable declaration

From
"David G. Johnston"
Date:
On Thursday, July 25, 2019, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15924
Logged by:          Abhishek Sharma
Email address:      abhi30572@gmail.com
PostgreSQL version: 10.0
Operating system:   Windows 7
Description:       

The query which is having joins and foreign table taking too much time to
get execute as compared to sql server. Also variable declaration and use in
sql server is very easy as compare to postgresql. Kindly work on variable
declaration and make it easy to use. Facing lot of due to above reason.

This list should be used for bug reports only. If you do re-post these to more appropriate lists consider:

Not sure what you expect to happen with your query observation.  Provide detail, self-contained example if possible.

Might want to elaborate a bit on the variable declaration part if you want to provoke a useful discussion.

David J.