On Fri, Jan 22, 2021 at 01:53:26AM +, Nagaraj Raj wrote:
> Tables ddl are attached in dbfiddle -- Postgres 11 | db<>fiddle
> Postgres 11 | db<>fiddle
> Server configuration is: Version: 10.11RAM - 320GBvCPU - 32
> "maintenance_work_mem" 256MB"work_mem" 1GB"shared_buffers" 64GB
> A
Hi,
I have a query performance issue, it takes a long time, and not even getting
explain analyze the output. this query joining on 3 tables which have around a
- 176223509
b - 286887780
c - 214219514
explainselect Count(a."individual_entity_proxy_id")from "prospect" ainner join
"individual_d
Hi all,
*My top-level query is*: I'm using logical replication under pg 9.6 to do a
kind of change data capture and I'm seeing occasional extended periods of
significant lag. I'm not sure what conceptual model I'm missing in order to
understand why this happens.
*The details:*
I'm running Postgr
