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 ... 156
Topics (5438)
Replies Last Post Views
Bitmap scan is undercosted? by Vitaliy Garnashevich
28
by Justin Pryzby
CPU 100% usage caused by unknown postgres process.. by Dinesh Chandra 12108
3
by Tomas Vondra-4
PostgreSQL database size is not reasonable by Mariel Cherkassky
5
by Tom Lane-2
Prepared Transactions by Riaan Stander
2
by Jeremy Whiting
Learning EXPLAIN by Flávio Henrique
5
by Samuel Gendler
Table with large number of int columns, very slow COPY FROM by Alex Tokarev
2
by Andres Freund
Setting effective_io_concurrency in VM? by Don Seiler
7
by Mark Kirkwood-2
pg_dump 3 times as slow after 8.4 -> 9.5 upgrade by Henrik Cednert (Film...
27
by Claudio Freire
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE by Ulf Lohbrügge
3
by Tom Lane-2
insert and query performance on big string table with pg_trgm by Matthew Hall
7
by Matthew Hall
Different plan chosen when in lateral subquery by Alex Reece
3
by Laurenz Albe
Half billion records in one table? RDS by Jean Baro
2
by Aaron Werman
Extremely slow DELETE with cascade foreign keys by Rodrigo Rosenfeld Ro...
9
by Rodrigo Rosenfeld Ro...
vacuum after truncate by Mariel Cherkassky
1
by Laurenz Albe
Bad plan for ltree predicate <@ by Roman Konoval
2
by Roman Konoval
Delete tables difference involves seq scan by abcz2.uprola
2
by abcz2.uprola
CREATE TABLE vs CREATE MATERIALIZED VIEW by Caio Guimarães Figue...
0
by Caio Guimarães Figue...
ODBC--call failed :: Bindings were not allocated properly by Dinesh Chandra 12108
0
by Dinesh Chandra 12108
Bad plan chosen for union all by Alex Reece
3
by Alex Reece
Invalid mem alloc request on function by bima p
0
by bima p
Query became very slow after 9.6 -> 10 upgrade by Dmitry Shalashov
16
by Dmitry Shalashov
Issue with postgres login by Daulat Ram
6
by Daulat Ram
pgpool + repmgr - who should be responsible for failover by Mariel Cherkassky
0
by Mariel Cherkassky
Bad estimates by Artur Zając
6
by Artur Zając
Using GROUPING SETS with more than one set disables predicate pushdown? by Zakhar Shapurau
2
by Andres Freund
POWA doesn't show queries executed by Neto pr
2
by Marco Nietz
Migration to PGLister - After by Stephen Frost
0
by Stephen Frost
PostgreSQL 9.6 wals management by Mariel Cherkassky
2
by Mariel Cherkassky
CREATE STATISTICS and join selectivity by Justin Pryzby
1
by David Rowley-3
query performance issue by Samir Magar
6
by Pavel Stehule
Query planner gaining the ability to replanning after start of query execution. by Oliver Mattos
7
by Gunter
DB slowness after upgrade from Postgres 9.1 to 9.4 by p kirti
1
by Tom Lane-2
overestimate on empty table by Justin Pryzby
3
by Tom Lane-2
Slow execution of SET ROLE, SET search_path and RESET ROLE by Ulf Lohbrügge
8
by Ulf Lohbrügge
Performance loss upgrading from 9.3 to 9.6 by Adam Torres
4
by Justin Pryzby
1234 ... 156