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 ... 166
Topics (5781)
Replies Last Post Views
Searching in varchar column having 100M records by mayank rupareliya
12
by Gezeala M. Bacuño II
Perplexing, regular decline in performance by Hugh Ranalli
17
by Andres Freund
Filtering on an enum field in a foreign table by Vladimir Ryabtsev
3
by Vladimir Ryabtsev
Optimizing `WHERE x IN` query by Omar Roth
5
by Michael Lewis
Custom opclass for column statistics? by Ancoron Luciferis
6
by Ancoron Luciferis
UUID v1 optimizations... by Ancoron Luciferis
24
by Ancoron Luciferis
scans on table fail to be excluded by partition bounds by Justin Pryzby
3
by David Rowley-3
Max_connections limit by Daulat Ram-2
4
by Igor Neyman
Incorrect index used in few cases.. by AminPG Jaffer
8
by AminPG Jaffer
materialized view refresh of a foreign table by Rick Otten-2
1
by Rick Otten-2
monitoring tuple_count vs dead_tuple_count by Mariel Cherkassky
0
by Mariel Cherkassky
Using indexes in RLS policies (sub)queries by Grégory EL MAJJOUTI
0
by Grégory EL MAJJOUTI
EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction by Chris Wilson-4
11
by Chris Wilson-4
wal_log_hints benchmarks by Fabio Pardi
2
by Fabio Pardi
Fwd: upgrade to PG11 on secondary fails (no initdb was launched) by Mariel Cherkassky
9
by Stephen Frost
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
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
123456 ... 166