pgsql-performance - January 2023

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

Jan. 1, 2023

Thread Author Time
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 11:34
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA 13:27
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 16:30
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA 16:43
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 16:51
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA 16:54
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 17:06

Jan. 5, 2023

Thread Author Time
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 10:57
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA 11:31
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk 11:44
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA 11:46

Jan. 6, 2023

Thread Author Time
Max write throughput for single COPY Joe Wildish 21:09

Jan. 8, 2023

Thread Author Time
Advice on best way to store a large amount of data in postgresql spiral 12:02

Jan. 9, 2023

Thread Author Time
Re: Advice on best way to store a large amount of data in postgresql [email protected] 10:39
Re: Advice on best way to store a large amount of data in postgresql Justin Pryzby 17:56
Re: Advice on best way to store a large amount of data in postgresql Samed YILDIRIM 23:14

Jan. 10, 2023

Thread Author Time
Re: Advice on best way to store a large amount of data in postgresql spiral 09:25

Jan. 14, 2023

Thread Author Time
change the default value of enable_bitmapscan to off [email protected] 14:51
Re: change the default value of enable_bitmapscan to off Pavel Stehule 15:00
Re: change the default value of enable_bitmapscan to off Tom Lane 15:57

Jan. 19, 2023

Thread Author Time
ALTER STATEMENT getting blocked aditya desai 17:30
Re: ALTER STATEMENT getting blocked Tom Lane 17:45
Re: ALTER STATEMENT getting blocked MichaelDBA 21:06

Jan. 22, 2023

Thread Author Time
Re: ALTER STATEMENT getting blocked aditya desai 11:29
LIKE CLAUSE on VIEWS aditya desai 11:33
Re: LIKE CLAUSE on VIEWS Samed YILDIRIM 11:40
Re: LIKE CLAUSE on VIEWS Rick Otten 15:55
Re: LIKE CLAUSE on VIEWS Jeff Janes 17:49

Jan. 30, 2023

Thread Author Time
Database Stalls Mok 17:47
Re: Database Stalls Justin Pryzby 17:51
Re: Database Stalls José Arthur Benetasso Villanova 18:10
Re: Database Stalls Shiv Iyer 18:47
Re: Database Stalls Mok 21:31
Fwd: Database Stalls Rick Otten 22:47

Browse Archives

Prev | Next