| From: | Tomas Vondra <tomas(at)vondra(dot)me> |
|---|---|
| To: | Aditya Singh <aditya(dot)singh(at)lji(dot)io>, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org> |
| Subject: | Re: BUG #18600: Getting wait_type_event as IPC:BTreePage for count queries |
| Date: | 2024-09-05 13:41:41 |
| Message-ID: | 51614e50-cc94-4d23-a356-c9644e860628@vondra.me |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 9/5/24 10:11, Aditya Singh wrote:
> The query on the first table didn't hit the wait event; it hit on the
> second table. I can show you the same on RDS Database Insights. Both
> tables have the same *Indexes*, *Data*, and *Columns*. There is only a
> difference in the ID datatype. Is there any possibility of scheduling a
> call to troubleshoot this issue since it is happening in the Production
> environment?
>
As this is a RDS database, you should probably talk to AWS support?
Other than that, share the explain plans for the two queries (as I asked
in my previous response).
BTW please don't top post. It's customary to reply inline on this list.
regards
--
Tomas Vondra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2024-09-05 14:47:33 | Re: BUG #18603: Yum repo does not contain 16.x version for Centos/RH/OEL7 |
| Previous Message | Sandeep Thakkar | 2024-09-05 11:46:40 | Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |