pgsql-performance before 2022-02-04 09:11

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Oct. 8, 2021

Thread	Author	Time
Re: PG 12 slow selects from pg_settings	Julius Tuskenis	12:05
Re: PG 12 slow selects from pg_settings	Ranier Vilela	12:50
Re: PG 12 slow selects from pg_settings	Julius Tuskenis	13:49
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Bruce Momjian	15:12
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Bruce Momjian	15:21
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Thomas Kellerer	15:28
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Bruce Momjian	15:40
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Julien Rouhaud	15:59
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Thomas Kellerer	16:07
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Mladen Gogala	16:38

Oct. 10, 2021

Thread	Author	Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Franck Pachot	22:09

Oct. 11, 2021

Thread	Author	Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Laurenz Albe	06:54
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle	Bruce Momjian	19:04

Oct. 12, 2021

Thread	Author	Time
Lock contention high	Ashkil Dighin	07:35
Re: Lock contention high	Mikhail Zhilin	10:29
Re: Lock contention high	Laurenz Albe	14:39
Re: Lock contention high	Mladen Gogala	15:37

Oct. 13, 2021

Thread	Author	Time
Re: Lock contention high	Justin Pryzby	16:48
Re: Lock contention high	MichaelDBA	18:15
Re: Lock contention high	Paul Friedman	18:57
Re: Lock contention high	Peter Geoghegan	19:05

Oct. 14, 2021

Thread	Author	Time
Re: Lock contention high	Jeremy Schneider	01:54
Re: Lock contention high	Peter Geoghegan	02:11
Re: Lock contention high	Ashkil Dighin	06:03
Re: Lock contention high	Laurenz Albe	06:42
Re: Lock contention high	Ashkil Dighin	06:45
Re: Lock contention high	Ashkil Dighin	06:49
Re: Lock contention high	Mikhail Zhilin	07:47

Oct. 18, 2021

Thread	Author	Time
Query out of memory	aditya desai	16:42
Re: Query out of memory	aditya desai	16:43
Re: Query out of memory	Vijaykumar Jain	16:48
Re: Query out of memory	aditya desai	19:03
Re: Query out of memory	Guillaume Lelarge	21:05

Oct. 19, 2021

Thread	Author	Time
Re: Query out of memory	aditya desai	04:07
Fwd: Query out of memory	aditya desai	05:58
Re: Query out of memory	Adam Brusselback	09:54
Re: Query out of memory	Dave Cramer	09:57
Re: Fwd: Query out of memory	Justin Pryzby	10:26
Re: Query out of memory	aditya desai	10:46
Sv: Fwd: Query out of memory	Andreas Joseph Krogh	11:08
Re: Query out of memory	Michael Lewis	13:39
Re: Query out of memory	aditya desai	13:48
Postgres views cannot use both union and join/where	Mithran Kulasekaran	21:47

Oct. 20, 2021

Thread	Author	Time
Re: Postgres views cannot use both union and join/where	David G. Johnston	01:32
Re: Postgres views cannot use both union and join/where	Benedict Holland	02:36
Re: Postgres views cannot use both union and join/where	Michael Lewis	02:56
Re: Postgres views cannot use both union and join/where	David G. Johnston	03:38
Re: Lock contention high	Ashkil Dighin	10:51
Re: Postgres views cannot use both union and join/where	Tom Lane	13:58
Re: Postgres views cannot use both union and join/where	David G. Johnston	14:29

Oct. 22, 2021

Thread	Author	Time
Re: Query out of memory	Ninad Shah	14:41

Oct. 25, 2021

Thread	Author	Time
Re: Lock contention high	Andres Freund	23:35

Oct. 26, 2021

Thread	Author	Time
Re: Lock contention high	Michael Lewis	00:38
Re: Lock contention high	Andres Freund	00:43

Oct. 27, 2021

Thread	Author	Time
Re: Performance for initial copy when using pg_logical to upgrade Postgres	Westwood, Giles	13:39
Re: Lock contention high	Ashkil Dighin	21:44
Re: Lock contention high	Andres Freund	22:22

Oct. 28, 2021

Thread	Author	Time
Views don't seem to use indexes?	Tim Slechta	02:31
Re: Views don't seem to use indexes?	David G. Johnston	04:54
Re: Views don't seem to use indexes?	Tom Lane	06:15
Re: Views don't seem to use indexes?	Tim Slechta	15:00

Nov. 2, 2021

Thread	Author	Time
PostgreSQLv14 TPC-H performance GCC vs Clang	arjun shetty	17:13
Re: PostgreSQLv14 TPC-H performance GCC vs Clang	Imre Samu	19:29

Nov. 4, 2021

Thread	Author	Time
JIT llvm11 package	ANASTACIO Tiago	20:56

Nov. 5, 2021

Thread	Author	Time
Re: PostgreSQLv14 TPC-H performance GCC vs Clang	arjun shetty	12:07
Re: PostgreSQLv14 TPC-H performance GCC vs Clang	Tomas Vondra	17:29

Nov. 7, 2021

Thread	Author	Time
EXISTS by itself vs SELECT EXISTS much slower in query. 📎	Jimmy A	22:27

Nov. 8, 2021

Thread	Author	Time
Re: EXISTS by itself vs SELECT EXISTS much slower in query.	Vasya Boytsov	09:22
Re: EXISTS by itself vs SELECT EXISTS much slower in query.	Tom Lane	20:35

Nov. 9, 2021

Thread	Author	Time
Re: EXISTS by itself vs SELECT EXISTS much slower in query.	Jimmy A	01:08

Nov. 11, 2021

Thread	Author	Time
performance of analytical query	Jiří Fejfar	19:20

Nov. 12, 2021

Thread	Author	Time
Re: performance of analytical query	Justin Pryzby	02:41
Re: Lock contention high	Ashkil Dighin	14:12
Re: performance of analytical query	Michael Lewis	17:55
Re: performance of analytical query	Justin Pryzby	18:33
Re: performance of analytical query	Jiří Fejfar	20:12

Nov. 15, 2021

Thread	Author	Time
postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64	Mladen Gogala	04:21
Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64	Pavel Stehule	05:04
Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64	Mladen Gogala	13:56
Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64	Rick Otten	14:17
Re: Lock contention high	Tom Lane	15:25

Nov. 16, 2021

Thread	Author	Time
Need help identifying a periodic performance issue.	Robert Creager	04:43
Re: Need help identifying a periodic performance issue.	Justin Pryzby	05:29
Re: Need help identifying a periodic performance issue.	Thomas Munro	05:50
PostgreSQLv14 TPC-H performance GCC vs Clang	arjun shetty	10:10
Re: Need help identifying a periodic performance issue.	Robert Creager	17:40
Re: Need help identifying a periodic performance issue.	Robert Creager	22:40
Re: Need help identifying a periodic performance issue.	Thomas Munro	22:51
Re: Need help identifying a periodic performance issue.	Thomas Munro	22:52

Nov. 17, 2021

Thread	Author	Time
Re: Lock contention high	arjun shetty	06:43
Re: Need help identifying a periodic performance issue.	Robert Creager	17:51
Re: Need help identifying a periodic performance issue.	Robert Creager	17:55
Re: Need help identifying a periodic performance issue.	Justin Pryzby	19:00
Re: Need help identifying a periodic performance issue.	Tom Lane	19:28
Re: Need help identifying a periodic performance issue.	Robert Creager	19:51
Re: Need help identifying a periodic performance issue.	Thomas Munro	21:01
Re: Need help identifying a periodic performance issue.	Robert Creager	21:54
Re: Need help identifying a periodic performance issue.	Justin Pryzby	23:18

Nov. 18, 2021

Thread	Author	Time
Re: Need help identifying a periodic performance issue.	Robert Creager	00:18
Re: Need help identifying a periodic performance issue.	Thomas Munro	03:39
Re: Need help identifying a periodic performance issue.	Justin Pryzby	05:42
Re: Need help identifying a periodic performance issue.	Robert Creager	17:03
Re: Need help identifying a periodic performance issue.	Thomas Munro	21:08
Re: Need help identifying a periodic performance issue.	Tom Lane	21:42
Re: Need help identifying a periodic performance issue.	Robert Creager	22:28
Re: Need help identifying a periodic performance issue.	Robert Creager	22:30

Nov. 19, 2021

Thread	Author	Time
Re: Need help identifying a periodic performance issue.	Robert Creager	18:47

Nov. 23, 2021

Thread	Author	Time
Re: performance of analytical query	Justin Pryzby	19:42

Nov. 24, 2021

Thread	Author	Time
Out of memory error	aditya desai	05:27
Re: Out of memory error	Tom Lane	05:52
Re: Out of memory error	aditya desai	06:25
Re: Out of memory error	Thomas Kellerer	06:31
Re: Out of memory error	aditya desai	06:36
Re: Out of memory error	Michael Lewis	06:45
Re: Out of memory error	aditya desai	07:31
Re: Out of memory error	aditya desai	07:35
Postgres process count GCC vs Clang is Different on autovaccum=on	hpc researcher_mspk	12:05
Re: Out of memory error	Thomas Kellerer	12:10
Re: Out of memory error	Thomas Kellerer	12:12
Re: Postgres process count GCC vs Clang is Different on autovaccum=on	Tomas Vondra	12:22
Re: Out of memory error	aditya desai	14:32
Re: Need help identifying a periodic performance issue.	Robert Creager	21:13
Re: Need help identifying a periodic performance issue.	Robert Creager	22:44
Re: Need help identifying a periodic performance issue.	Justin Pryzby	23:15

Nov. 25, 2021

Thread	Author	Time
pg_dump backup verification	Daulat	09:11
AW: [External] pg_dump backup verification	Dirk Krautschick	09:21
Re: pg_dump backup verification	Justin Pryzby	17:09

Nov. 29, 2021

Thread	Author	Time
Re: Lock contention high	arjun shetty	12:39
Re: Need help identifying a periodic performance issue. 📎	Robert Creager	23:04

Nov. 30, 2021

Thread	Author	Time
pg_trgm word_similarity query does not use index for input strings longer than 8 characters	pgsql-performance	21:38

Dec. 1, 2021

Thread	Author	Time
LwLockRelease performance	Ashkil Dighin	14:26

Dec. 2, 2021

Thread	Author	Time
Re: LwLockRelease performance	Tom Lane	22:19
Re: LwLockRelease performance	Andres Freund	23:50

Dec. 4, 2021

Thread	Author	Time
An I/O error occurred while sending to the backend (PG 13.4)	ldh@laurent-hasson.com	17:32
Re: An I/O error occurred while sending to the backend (PG 13.4)	Justin Pryzby	17:59
RE: An I/O error occurred while sending to the backend (PG 13.4)	ldh@laurent-hasson.com	19:18
Re: An I/O error occurred while sending to the backend (PG 13.4)	Justin Pryzby	19:53

Dec. 7, 2021

Thread	Author	Time
Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters	Laurenz Albe	03:10
Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters	Tom Lane	17:08

Dec. 8, 2021

Thread	Author	Time
Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters	pgsql-performance	18:43

Dec. 10, 2021

Thread	Author	Time
Re: PostgreSQLv14 TPC-H performance GCC vs Clang	Imre Samu	18:21

Dec. 16, 2021

Thread	Author	Time
PostgreSQLv14 performance client-server-HammerDB	arjun shetty	15:35

Dec. 21, 2021

Thread	Author	Time
Query is slower with a large proportion of NULLs in several columns	Lars Bergeson	01:23
Re: Query is slower with a large proportion of NULLs in several columns	David G. Johnston	01:49
Re: Query is slower with a large proportion of NULLs in several columns	Tom Lane	01:51
Re: Query is slower with a large proportion of NULLs in several columns	Lars Bergeson	04:11
Re: Query is slower with a large proportion of NULLs in several columns	Justin Pryzby	04:51
Re: Query is slower with a large proportion of NULLs in several columns	Tom Lane	05:01
Re: Query is slower with a large proportion of NULLs in several columns	David G. Johnston	05:07
Re: Query is slower with a large proportion of NULLs in several columns	David G. Johnston	05:08
Re: Query is slower with a large proportion of NULLs in several columns	Tom Lane	05:33
Re: Lock contention high 📎	Yura Sokolov	05:45
Re: Query is slower with a large proportion of NULLs in several columns	Justin Pryzby	21:13
Re: Query is slower with a large proportion of NULLs in several columns	Lars Bergeson	22:53
Re: Query is slower with a large proportion of NULLs in several columns	Tom Lane	23:07

Dec. 22, 2021

Thread	Author	Time
Re: Query is slower with a large proportion of NULLs in several columns	David G. Johnston	00:45
WAL files keep piling up	Zbigniew Kostrzewa	15:34
Re: WAL files keep piling up	Ninad Shah	18:01
Re: WAL files keep piling up	Zbigniew Kostrzewa	18:11
Re: WAL files keep piling up	Tom Lane	18:18
Re: WAL files keep piling up	Zbigniew Kostrzewa	19:26

Dec. 23, 2021

Thread	Author	Time
Re: WAL files keep piling up	Laurenz Albe	10:04

Dec. 28, 2021

Thread	Author	Time
9.6 write time	Marc Millas	16:52
Re: 9.6 write time	Tom Lane	17:46
Re: 9.6 write time	Marc Millas	17:55
Re: 9.6 write time	Tom Lane	18:34
Re: 9.6 write time	Marc Millas	18:59

Jan. 3, 2022

Thread	Author	Time
Re: WAL files keep piling up	Zbigniew Kostrzewa	22:48

Jan. 4, 2022

Thread	Author	Time
VACUUM: Nonremovable rows due to wal sender process	Steve Nixon	17:16
Re:VACUUM: Nonremovable rows due to wal sender process	Sergei Kornilov	20:17
Re: VACUUM: Nonremovable rows due to wal sender process	Steve Nixon	21:01

Jan. 6, 2022

Thread	Author	Time
Same query 10000x More Time	Avi Weinberg	07:43
Re: Same query 10000x More Time	Vijaykumar Jain	08:20
Re: Same query 10000x More Time	Kyotaro Horiguchi	09:39
RE: Same query 10000x More Time	Avi Weinberg	10:20
Re: Same query 10000x More Time	Vijaykumar Jain	12:52
RE: Same query 10000x More Time	Avi Weinberg	14:31
Re: Same query 10000x More Time	Vijaykumar Jain	16:50

Jan. 11, 2022

Thread	Author	Time
About Query Performaces Problem	Hüseyin Ellezer	08:41
Re: About Query Performaces Problem	Pavel Stehule	13:31

Jan. 12, 2022

Thread	Author	Time
Re: About Query Performaces Problem	Hüseyin Ellezer	08:23
Re: About Query Performaces Problem	Pavel Stehule	08:31
Re: About Query Performaces Problem	Julien Rouhaud	08:35

Jan. 13, 2022

Thread	Author	Time
PGBench connection issue with -C option only	T T	01:47

Jan. 18, 2022

Thread	Author	Time
Re: PostgreSQLv14 TPC-H performance GCC vs Clang	arjun shetty	14:22
Unique constraint blues	Mladen Gogala	17:13
Re: Unique constraint blues	David G. Johnston	17:29

Jan. 19, 2022

Thread	Author	Time
PostgreSQL 12.8 Same Query Same Execution Plan Different Time	Ludwig Isaac Lim	13:52
Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time	David G. Johnston	15:11

Jan. 20, 2022

Thread	Author	Time
RE: PostgreSQL 12.8 Same Query Same Execution Plan Different Time	Michel SALAIS	13:15
Slow query fixed by replacing equality with a nested query	Valentin Janeiko	19:04
Poor performance PostgreSQL 13/ PostGIS 3.x	Lugosi, Jim	22:50
PostgreSQL and Linux CPU's	Sbob	23:21
Re: PostgreSQL and Linux CPU's	David G. Johnston	23:27

Jan. 21, 2022

Thread	Author	Time
Re: Slow query fixed by replacing equality with a nested query	Michael Lewis	03:33
RE: Slow query fixed by replacing equality with a nested query	val.janeiko	11:37

Jan. 24, 2022

Thread	Author	Time
Re: Slow query fixed by replacing equality with a nested query	Valentin Janeiko	13:22
Re: Slow query fixed by replacing equality with a nested query	Michael Lewis	17:50
Re: Slow query fixed by replacing equality with a nested query	Michael Lewis	17:52

Jan. 26, 2022

Thread	Author	Time
Query runs slower as prepared statement - identical execution plans	Thomas Kellerer	07:18

Browse Archives

Prev | Next