Messages by Thread
-
Postgresql initialize error
nikhil kumar
-
Re: Distinct performance dropped by multiple times in v16
Greg Sabino Mullane
-
query column in pg_stat_statements and pg_stat_activity
Satalabaha Postgres
-
Plan selection based on worst case scenario
Darwin O'Connor
-
Extremely slow to establish connection when user has a high number of roles
Michal Charemza
-
LWlock:LockManager waits
James Pang
-
maintenance_work_mem impact?
Adithya Kumaranchath
-
Separate 100 M spatial data in 100 tables VS one big table
kimaidou
-
Re: Is partition pruning impacted by data type
sud
-
Table Partitioning and Indexes Performance Questions
David Kelly
-
generic plan generate poor performance
James Pang
-
extend statistics help reduce index scan a lot of shared buffer hits.
James Pang
-
Optimizing count(), but Explain estimates wildly off
Chema
-
Re: Optimizing count(), but Explain estimates wildly off
Vitalii Tymchyshyn
-
Re: Optimizing count(), but Explain estimates wildly off
Laurenz Albe
-
Re: Optimizing count(), but Explain estimates wildly off
Chema
-
Re: Optimizing count(), but Explain estimates wildly off
Laurenz Albe
-
Re: Optimizing count(), but Explain estimates wildly off
Chema
-
Re: Optimizing count(), but Explain estimates wildly off
Greg Sabino Mullane
-
Re: Optimizing count(), but Explain estimates wildly off
Chema
-
Re: Optimizing count(), but Explain estimates wildly off
Greg Sabino Mullane
-
Re: Optimizing count(), but Explain estimates wildly off
Chema
-
Re: Optimizing count(), but Explain estimates wildly off
Alvaro Herrera
-
sql statement not using all primary key values and poor performance
James Pang
-
"not related" code blocks for removal of dead rows when using vacuum and this kills the performance
Lars Aksel Opsahl
-
PostgreSQL doesn't use index-only scan if there is an expression in index
Pavel Kulakov
-
Simple JOIN on heavy table not using expected index
kimaidou
-
Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards.
Daniel Blanch Bataller
-
huge SubtransSLRU and SubtransBuffer wait_event
James Pang (chaolpan)
-
Performance
Mehmet COKCEVIK
-
Slow query in table where many rows were deleted. VACUUM FULL fixes it
Pavlos Kallis
-
I don't understand that EXPLAIN PLAN timings
Jean-Christophe Boggio
-
Why is a sort required for this query? (IS NULL predicate on leading key column)
Jerry Brenner
-
Selection not "pushed down into" CTE
Clemens Eisserer
-
Questions about "Output" in EXPLAIN ANALYZE VERBOSE
Jerry Brenner
-
Slow GroupAggregate and Sort
Darwin Correa
-
Need help with performance tuning pg12 on linux
Wilson, Maria Louise (LARC-E301)[RSES]
-
Parallel hints in PostgreSQL with consistent perfromance
mohini mane
-
Which side of a Merge Join gets executed first? Do both sides always get executed?
Jerry Brenner
-
2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers?
Jerry Brenner
-
Question about semantics of $ variables in json explain plans in 13
Jerry Brenner
-
Include a timestamp in future versions of pg_stat_statements when when a query entered the cache?
Jerry Brenner
-
Does Postgres have consistent identifiers (plan hash value) for explain plans?
Jerry Brenner
-
Strange "actual time" in simple CTE
Jean-Christophe Boggio
-
Performance degradation with CTEs, switching from PG 11 to PG 15
Jean-Christophe Boggio
-
simple query running long time within a long transaction.
James Pang (chaolpan)
-
Awkward Join between generate_series and long table
Lincoln Swaine-Moore
-
GIN JSONB path index is not always used
Tomasz Szymański
-
Underestimated number of output rows with an aggregate function
Philippe BEAUDOIN
-
Postgres 15 SELECT query doesn't use index under RLS
Alexander Okulovich