PGBench connection issue with -C option only

2022-01-12 Thread T T
Hi Team , We are getting below error while running pgbench - could not connect to server: Cannot assign requested address Is the server running on host " tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com" (100.10.11.4) and accepting TCP/IP connections on port 5432? clie

Re: About Query Performaces Problem

2022-01-12 Thread Julien Rouhaud
Hi, On Wed, Jan 12, 2022 at 11:23:33AM +0300, Hüseyin Ellezer wrote: > I mean, despite the execution times shown here PostgreSQL 10 is working > faster compared to PostgreSQL 14. Please don't top-post here, see https://wiki.postgresql.org/wiki/Mailing_Lists for more details. > Is this speed perf

Re: About Query Performaces Problem

2022-01-12 Thread Pavel Stehule
st 12. 1. 2022 v 9:23 odesílatel Hüseyin Ellezer napsal: > I mean, despite the execution times shown here PostgreSQL 10 is working > faster compared to PostgreSQL 14. Is this speed performance about the > cached or disk data? How can we see where the data comes from? > use EXPLAIN (ANALYZE, BUFF

Re: About Query Performaces Problem

2022-01-12 Thread Hüseyin Ellezer
I mean, despite the execution times shown here PostgreSQL 10 is working faster compared to PostgreSQL 14. Is this speed performance about the cached or disk data? How can we see where the data comes from? Best regards Pavel Stehule , 11 Oca 2022 Sal, 16:31 tarihinde şunu yazdı: > > > út 11. 1. 2