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 ... 163
Topics (5702)
Replies Last Post Views
Fwd: upgrade to PG11 on secondary fails (no initdb was launched) by Mariel Cherkassky
9
by Stephen Frost
wal_log_hints benchmarks by Fabio Pardi
0
by Fabio Pardi
UUID v1 optimizations... by Ancoron Luciferis
22
by Ancoron Luciferis
Strange query behaviour between 9.4 and 12beta1 by dis0rder
1
by Tomas Vondra-4
Shortest offline window on database migration by Haroldo Kerry
9
by Stephen Frost
JIT in PostgreSQL 12 ? by Tobias Gierke
5
by Justin Pryzby
improve wals replay on secondary by Mariel Cherkassky
11
by Fabio Pardi
Use Postgres as a column store by creating one table per column by Lev Kokotov
5
by Mark Kirkwood-2
Generic Plans for Prepared Statement are 158155 times slower than Custom Plans by Naik, Sameer
11
by Tom Lane-2
Analyze results in more expensive query plan by Jeremy Altavilla
4
by Jeremy Altavilla
pg_restore takes more time on creation of rules by Mariel Cherkassky
3
by Tomas Vondra-4
Log size in bytes of query result by Franklin Haut
4
by Dmitry Dolgov
Temporarily very slow planning time after a big delete by Walter Smith
12
by Peter Geoghegan-4
Trying to handle db corruption 9.6 by Mariel Cherkassky
10
by Tomas Vondra-4
using sequential scan instead of index for join with a union by Kent Tong-3
2
by Kent Tong-3
The wrong (?) query plan for queries with remote (postgres_fdw) tables by Vitaly Baranovsky
0
by Vitaly Baranovsky
Huge generated UNION ALL faster than JOIN? by Ancoron Luciferis
2
by Ancoron Luciferis
GCC 8.3.0 vs. 9.0.1 by Steven Winfield
6
by Steven Winfield
PostgreSQL optimizer use seq scan instead of pkey index only scan (in queries with postgres_fdw) by Vitaly Baranovsky
6
by Jeff Janes
Failure to reordering in case of a lateral join in combination with a left join (not inner join) resulting in suboptimal nested loop plan by Peter Billen-2
1
by Tom Lane-2
Out of Memory errors are frustrating as heck! by Gunter
87
by Tomas Vondra-4
Backup and Restore (pg_dump & pg_restore) by Daulat Ram-2
1
by Tomas Vondra-4
Pg10 : Client Configuration for Parallelism ? by laurent.dechambe
15
by Tom Lane-2
Best Filesystem for PostgreSQL by schmidt
6
by Robert Blayzor
Fwd: iscsi performance by Mahmoud Moharam
0
by Mahmoud Moharam
Block / Page Size Optimization by Gunter
3
by Bruce Momjian
Postgres backup & restore by Daulat Ram-2
1
by Justin Pryzby
PostgreSQL upgrade. by Daulat Ram-2
3
by Mark Kirkwood-2
Commit(?) overhead by Duncan Kinnear
6
by Laurenz Albe
Planning performance problem (67626.278ms) by Krzysztof Plocharz
10
by Andres Freund
Oracle to postgres migration by Daulat Ram-2
6
by David G Johnston
monitoring options for postgresql under AWS/RDS? by Mamet, Eric (GfK)
4
by Praveen Duraiswami
Re: RAM usage of PostgreSql by Justin Pryzby
1
by Keith
(no subject) by Mariel Cherkassky
1
by Laurenz Albe
Postgresql Sort cost Poor performance? by tank.zhang
8
by tank.zhang
1234 ... 163