Performance difference between Primary & Secondary in the query execution

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Performance difference between Primary & Secondary in the query execution
Date: 2024-10-17 14:08:06
Message-ID: CAC5iy60Fju3h0qrOS5M70G58fc_d69YTOD20vwr5bWnW1B5AQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Experts!

We have a PgSQL instance running with HA (secondary is being in sync with
streaming replication). Both the ends, we have same version, but not sure a
few SQLs behave badly in the secondary:

Primary:
PostgreSQL 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit

OS: Ubuntu 20.04.6 LTS \n \l

Secondary:
ostgreSQL 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit

OS: Ubuntu 20.04.6 LTS \n \l

The application consumes more data from secondary, hence the server has
extra vCPUs.

Can you please advise what needs to be checked.

FYI, I am attaching the query with the different execution plans.

Regards
Siraj

Attachment Content-Type Size
bad-explain-secondary application/octet-stream 5.6 KB
explain-primary application/octet-stream 5.0 KB
query application/octet-stream 2.4 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2024-10-17 15:12:30 Re: Download of v16.1 for Windows 64B
Previous Message Carlos Oliva 2024-10-17 14:06:20 Download of v16.1 for Windows 64B