Is there any good optimization solution to improve the query efficiency?

Hi everyone, I'm running into some performance issues with my SQL query. The following SQL query is taking a long time to execute. Execution Plan： explain analyse select * from TBL_RES left outer join(select T_CUST.RSNO RSNO2 , T_CUST.KNO , T_CUST.AGE , T_CUST.GST from TBL_CUST T_CUST , (select

Re: Pg 16: will pg_dump & pg_restore be faster?

On Sat, 3 Jun 2023 at 00:14, Jonathan S. Katz wrote: > Typically once a release announcement is out, we'll only edit it if it's > inaccurate. I don't think the statement in the release announcement is > inaccurate, as it specifies that concurrent bulk loading is faster. Understood. I had thought

[Question]What will happen if the server active close the connection?

Hi team, when I study the tcp connection, I found that if the server active close the connection, the server will send a fin package to the client and the client will reply a ack package. As this: Server >(FIN) Client Server <(ACK) Client My question is, in so many articles, the follo

Re: "pgsql-zh-general" can't send chinese mail.

Sorry, it's all my fault, I use error mail-box settings. Yours, Wen Yi   -- Original -- From: "postgresql439848"

Re: "pgsql-zh-general" can't send chinese mail.

Hi, Am 04.06.23 um 11:15 schrieb Wen Yi: Hi team, I want to use the list "pgsql-zh-general" to communicate with chinese user. But it can't send chinese mail,  because he recognizes all Chinese emails as spam. before this message your mail was listed at https://www.postgresql.org/list/pgsql-zh-

"pgsql-zh-general" can't send chinese mail.

Hi team, I want to use the list "pgsql-zh-general" to communicate with chinese user. But it can't send chinese mail,  because he recognizes all Chinese emails as spam. Can someone provide some solution? Thanks in advance! Yours, Wen Yi

Re: Connection error to new pg15 instance

It turns out RDS by default forces ssl connections for pg15 instances. I have turned this off for now while I work out how that impacts my code and I can now connect to the pg15 instance. Thanks, Steve On Sun, Jun 4, 2023 at 3:10 PM Steve Baldwin wrote: > I suspect it may have something to do

Re: How to remove user specific grant and revoke

Hi! >From your first message I was under the impression that pgAdmin shows one REVOKE ALL for every GRANT, i.e. all REVOKE commands at once. If that is not the case you may have found a bug in pgAdmin. Please ask on the pgadmin-support list or open a GitHub issue. Speaking of which, I foundh