Messages by Thread
-
inequality predicate not pushed down in JOIN?
Paul George
-
Specific objects backup in PostgreSQL
nikhil kumar
-
Low performance between datacenters
Tamás PAPP
-
Re: How to solve my slow disk i/o throughput during index scan
Andrei Lepikhov
-
Hash Right join and seq scan
James Pang
-
a lot of shared buffers hit when planning for a simple query with primary access path
James Pang
-
Inconsistent query performance based on relation hit frequency
Laura Hausmann
-
Row level security
Thomas Simpson
-
performance of sql and plpgsql functions
Julius Tuskenis
-
BDR that performs
Smith, Travis
-
Need help on configuration SMTP
nikhil kumar
-
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