Messages by Thread
-
Re: Has gen_random_uuid() gotten much slower in v17?
Peter Eisentraut
-
many backends hang on MultiXactOffsetSLRU
James Pang
-
Estimate of the inner_rows
陈雁飞
-
Re: checking for a NULL date in a partitioned table kills performance
Tom Lane
-
checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before)
Sbob
-
Trying to understand why a query is filtering when there is a composite index
Stephen Samuel (Sam)
-
Partition pruning with array-contains check and current_setting function
Marcelo Zabani
-
logical replication out of memory
James Pang
-
Help with row estimate problem
Jon Zeppieri
-
Outer cost higher than the inner cost
Stanisław Skonieczny
-
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