RE: FDW connections

2021-01-22 Thread Hou, Zhijie
> > If I have made a query on a foreign table (using postgres_fdw), it > > establishes a connection automatically. Is there any way to > > disconnect that fdw connection without disconnecting the session that > > instigated it? > > No. > > From PostgreSQL v14 on, there is the "idle_session_time

Initplan placed at the righttree or the lefttree of joinnode

2020-10-22 Thread Hou, Zhijie
Hi, I try to make some special query plan like the following. I have tried a lot SQL, but failed. Can Initplan placed at the righttree or the lefttree of joinnode? (Fake) QUERY PLAN --- Hash Join (cost=13.15..26.48 rows=

How to get debuginfo from building source code

2020-10-21 Thread Hou, Zhijie
Hi My PostgreSQL 10.3 in Centos7.4 exited abnormally and generated core.dump. I want to analyze the core.dump but I does not find postgresql10-debuginfo-10.3 in https://download.postgresql.org/pub/repos/yum/debug/10/redhat/rhel-7.4-x86_64/ Can I get the debuginfo from building the source code ?

Fix typo in Comments of HandleProcSignalBarrierInterrupt

2020-09-03 Thread Hou, Zhijie
Hi all In master branch, I found a typo in Comments of function HandleProcSignalBarrierInterrupt. See the attachment for the patch. Best regards. fix-typo.patch Description: fix-typo.patch