PostgreSQL - performance

This forum is an archive for the mailing list pgsql-performance@postgresql.org (more options) Messages posted here will be sent to this mailing list.
123456 ... 164
Topics (5715)
Replies Last Post Views
2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use by Kristi Anderson
0
by Kristi Anderson
pgstattuple_approx for toasted table by Mariel Cherkassky
1
by Laurenz Albe
How to get the content of Bind variables by Did16
17
by Did16
Performance regressions found using sqlfuzz by Jung, Jinho
8
by Jung, Jinho
What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum by Fd Habash
3
by Fd Habash
Query slow for new participants by Kim
8
by Laurenz Albe
Aggregate and many LEFT JOIN by kimaidou
11
by Jeff Janes
Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks. by Gunter
20
by Michaeldba@sqlexec.c...
Idle backends outside a transaction holding onto large amounts of memory / swap space? by Tobias Gierke
1
by Pavel Stehule
Slow query with aggregate and many LEFT JOINS by kimaidou
2
by Igor Neyman
neither CPU nor IO bound, but throttled performance by Gunter
3
by Gunther Schadow
How can sort performance be so different by Bob Jolliffe
13
by Peter Geoghegan-4
Why isn't an index scan being used? by Abi Noda
8
by Jeff Janes
index on jsonb col with 2D array inside the json by Mariel Cherkassky
4
by Mariel Cherkassky
Re: dsa_allocate() faliure by Jakub Glapa
11
by Jakub Glapa
Fw: server hardware tuning. by suganthi Sekar
16
by Justin Pryzby
ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" by Mariel Cherkassky
6
by Mariel Cherkassky
autovacuum big table taking hours and sometimes seconds by Mariel Cherkassky
20
by Laurenz Albe
JIT overhead slowdown by Luis Carril
3
by Justin Pryzby
Q on SQL Performance tuning by Bhupathi, Kaushik (C...
3
by Greg Stark
understanding max_wal_size,wal_keep_segments and checkpoints by Mariel Cherkassky
3
by Laurenz Albe
Bloom index cost model seems to be wrong by Thomas Kellerer
5
by Jeff Janes
Partitioning Optimizer Questions and Issues by keith anderson
2
by keith anderson
(no subject) by evandro.abreu
4
by Tumasgiu Rossini
Managing High Availability in PostgreSQL – Part I by Kristi Anderson
0
by Kristi Anderson
Transaction size and Wal2Json by Mai Peng
1
by Peter Eisentraut-6
dsa_allocate() faliure by Rick Otten-2
23
by Justin Pryzby
Setting effective_cache size by Nandakumar M
2
by Laurenz Albe
Re: pgstattupple vs pg_total_relation_size by Tom Lane-2
0
by Tom Lane-2
Will higher shared_buffers improve tpcb-like benchmarks? by Saurabh Nanda
4
by Saurabh Nanda
Interpreting shared_buffers setting by Bob Jolliffe
5
by Jerry Sievers-3
Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"? by Saurabh Nanda
21
by Jeff Janes
pg_locks - what is a virtualxid locktype by Mariel Cherkassky
0
by Mariel Cherkassky
upgrade from 9.6 to 10/11 by Mariel Cherkassky
2
by Justin Pryzby
Zero throughput on a query on a very large table. by ldhasson
14
by ldhasson
123456 ... 164