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.
12345 ... 163
Topics (5691)
Replies Last Post Views
impact of auto explain on overall performance by schmidt
4
by jer
ERROR: found xmin from before relfrozenxid by Mariel Cherkassky
18
by Adrien Nayrat-2
Planner not choosing GIN index by Corey Huinker
3
by Flo Rance
Shared_buffers by Daulat Ram-2
5
by Michaeldba@sqlexec.c...
Performance regression related to parallel execution by Jinho Jung-2
0
by Jinho Jung-2
Wired execution in my benchmark using postgresql 9.6 by tayeb merabti
0
by tayeb merabti
IS NOT DISTINCT FROM statement by Artur Zając
5
by Tom Lane-2
Performance regressions found using sqlfuzz by Jinho Jung-2
0
by Jinho Jung-2
JIT performance question by Tobias Gierke
3
by Andres Freund
autovacuum just stop vacuuming specific table for 7 hours by Mariel Cherkassky
2
by Mariel Cherkassky
Server upgrade advice [xpost] by Rory Campbell-Lange
1
by Ian Harding
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
12345 ... 163