pgsql-performance - December 2021

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)

Browse Archives

Prev | Next

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) [email protected] 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) [email protected] 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

Browse Archives

Prev | Next