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.
1234 ... 162
Topics (5637)
Replies Last Post Views
neither CPU nor IO bound, but throttled performance by Gunter
1
by Justin Pryzby
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
Performance regressions found using sqlfuzz by Jung, Jinho
7
by Jung, Jinho
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
ERROR: found xmin from before relfrozenxid by Mariel Cherkassky
12
by Mariel Cherkassky
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
SELECT performance drop by Jan Nielsen
9
by Jan Nielsen
Parallel stats in execution plans by David Conlin
2
by David Rowley-3
ANALYZE accuracy problems for n_distinct, and a solution by Jim Finnerty
0
by Jim Finnerty
Very long query planning times for database with lots of partitions by Mickael van der Beek
3
by Mickael van der Beek
Re: Memory and hard ware calculation : by Fabio Pardi
0
by Fabio Pardi
autovacuum doesnt run on the pg_toast_id table by Mariel Cherkassky
7
by Mariel Cherkassky
No matching tables have ever been vacuumed by Daulat Ram-2
1
by Laurenz Albe
Detect missing combined indexes (automatically) by Thomas Güttler
5
by Julien Rouhaud
1234 ... 162