pgsql-performance since 2022-12-14 00:00

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

Dec. 14, 2022

Thread	Author	Time
Re: Increased iowait and blk_read_time with higher shared_buffers	Samed YILDIRIM	12:38
Re: Increased iowait and blk_read_time with higher shared_buffers	Jordan Hurwich	18:12
Re: Increased iowait and blk_read_time with higher shared_buffers	Tom Lane	18:27
Re: Increased iowait and blk_read_time with higher shared_buffers	Jordan Hurwich	18:32
Re: Increased iowait and blk_read_time with higher shared_buffers	Samed YILDIRIM	18:41
Re: Increased iowait and blk_read_time with higher shared_buffers	Jordan Hurwich	18:43
creating hash indexes	Rick Otten	20:03
Re: creating hash indexes	Peter Geoghegan	20:28
time sorted UUIDs	Tim Jones	21:56

Dec. 15, 2022

Thread	Author	Time
DML sql execution time slow down PGv14 compared with PGv13 📎	James Pang (chaolpan)	08:12
DML sql execution time slow down PGv14 compared with PGv13 📎	James Pang (chaolpan)	08:22
Re: DML sql execution time slow down PGv14 compared with PGv13	Samed YILDIRIM	08:38
RE: DML sql execution time slow down PGv14 compared with PGv13 📎	James Pang (chaolpan)	08:44
RE: DML sql execution time slow down PGv14 compared with PGv13	James Pang (chaolpan)	08:46
Re: DML sql execution time slow down PGv14 compared with PGv13	David Rowley	10:42
RE: DML sql execution time slow down PGv14 compared with PGv13	James Pang (chaolpan)	11:34
Re: time sorted UUIDs	Laurenz Albe	11:59
Re: time sorted UUIDs	Adrien Nayrat	12:05
RE: DML sql execution time slow down PGv14 compared with PGv13	James Pang (chaolpan)	12:19

Dec. 16, 2022

Thread	Author	Time
JSON down performacen when id:1	Render Comunicacion S.L.	13:30
Re: JSON down performacen when id:1	Tom Lane	15:06
Postgres12 looking for possible HashAggregate issue workarounds?	João Paulo Luís	15:24
Re: Postgres12 looking for possible HashAggregate issue workarounds?	Justin Pryzby	16:06
Re: JSON down performacen when id:1	Render Comunicacion S.L.	17:01
RE: Postgres12 looking for possible HashAggregate issue workarounds?	João Paulo Luís	17:47

Dec. 18, 2022

Thread	Author	Time
Re: Postgres12 looking for possible HashAggregate issue workarounds?	David Rowley	11:06
temp_file_limit?	Frits Jalvingh	11:48
Re: temp_file_limit?	Justin Pryzby	15:57
Fwd: temp_file_limit?	Frits Jalvingh	17:29
Re: Fwd: temp_file_limit?	Tom Lane	19:28
Re: Fwd: temp_file_limit?	Justin Pryzby	20:10

Dec. 19, 2022

Thread	Author	Time
Re: Fwd: temp_file_limit?	Thomas Munro	00:51
Re: Fwd: temp_file_limit?	Thomas Munro	00:53
Re: Fwd: temp_file_limit?	Frits Jalvingh	09:47
Re: Fwd: temp_file_limit?	Ranier Vilela	12:15
Re: Fwd: temp_file_limit?	Frits Jalvingh	14:45
Re: Fwd: temp_file_limit?	Ranier Vilela	14:52
Re: Fwd: temp_file_limit?	Frits Jalvingh	15:01
RE: Postgres12 looking for possible HashAggregate issue workarounds?	João Paulo Luís	16:50
Re: Fwd: temp_file_limit?	Frits Jalvingh	16:57
Re: Fwd: temp_file_limit?	Justin Pryzby	17:15
Re: Fwd: temp_file_limit? 📎	Frits Jalvingh	17:27
Re: Fwd: temp_file_limit?	Justin Pryzby	17:46
Re: Fwd: temp_file_limit?	Frits Jalvingh	19:29
Re: Fwd: temp_file_limit?	Ranier Vilela	19:42
Re: Fwd: temp_file_limit?	Justin Pryzby	19:50
Re: Fwd: temp_file_limit?	Frits Jalvingh	19:59
Re: Fwd: temp_file_limit?	Thomas Munro	20:07
Re: Fwd: temp_file_limit?	Frits Jalvingh	20:10
Re: Fwd: temp_file_limit?	Frits Jalvingh	20:32

Dec. 20, 2022

Thread	Author	Time
Re: Fwd: temp_file_limit?	Justin Pryzby	21:11

Dec. 23, 2022

Thread	Author	Time
Re: Fwd: temp_file_limit?	Frits Jalvingh	08:12

Dec. 28, 2022

Thread	Author	Time
When you really want to force a certain join type?	Gunther Schadow	15:39
Re: When you really want to force a certain join type?	Justin Pryzby	15:48

Dec. 29, 2022

Thread	Author	Time
Re: When you really want to force a certain join type?	Gunther Schadow	07:31
Re: When you really want to force a certain join type?	Tom Lane	07:52

Dec. 31, 2022

Thread	Author	Time
How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)	Maxim Boguk	12:26
Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)	Justin Pryzby	14:32

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	Michaeldba@sqlexec.com	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	hehaochen@hotmail.com	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

Feb. 1, 2023

Thread	Author	Time
Getting an index scan to be a parallel index scan	Alex Kaiser	05:39
Re: Getting an index scan to be a parallel index scan	Ranier Vilela	11:17
Re: Getting an index scan to be a parallel index scan	David Rowley	11:30
Re: Getting an index scan to be a parallel index scan	Alex Kaiser	19:22
Re: Getting an index scan to be a parallel index scan	Justin Pryzby	20:02
Re: Getting an index scan to be a parallel index scan	Thomas Munro	21:51

Feb. 2, 2023

Thread	Author	Time
Re: Getting an index scan to be a parallel index scan	Alex Kaiser	00:54
Re: Getting an index scan to be a parallel index scan	Thomas Munro	01:48
Re: Getting an index scan to be a parallel index scan	David Rowley	02:11
Re: Getting an index scan to be a parallel index scan	Alex Kaiser	05:00

Feb. 3, 2023

Thread	Author	Time
Re: Database Stalls	Craig Jackson	16:25

Feb. 7, 2023

Thread	Author	Time
Routing & Concurrency with trigger functions	chanukya SDS	09:03

Feb. 8, 2023

Thread	Author	Time
Domain check taking place unnecessarily?	Mark Hills	18:01
Re: Domain check taking place unnecessarily?	David G. Johnston	18:09
Window Functions & Table Partitions	Benjamin Tingle	19:45
Re: Domain check taking place unnecessarily?	Laurenz Albe	19:47
Re: Window Functions & Table Partitions 📎	David Rowley	22:35
max_wal_senders	Rick Otten	23:07

Feb. 9, 2023

Thread	Author	Time
Re: max_wal_senders	Laurenz Albe	05:59
Re: max_wal_senders	Andres Freund	06:40
Re: Domain check taking place unnecessarily?	Mark Hills	10:56
Re: Domain check taking place unnecessarily?	Mark Hills	11:01
Re: Domain check taking place unnecessarily?	Tom Lane	15:10
Re: Window Functions & Table Partitions	Benjamin Tingle	17:40

Feb. 10, 2023

Thread	Author	Time
Re: Domain check taking place unnecessarily?	Mark Hills	10:49
For loop execution times in PostgreSQL 12 vs 15	Adithya Kumaranchath	18:53
Re: For loop execution times in PostgreSQL 12 vs 15	Pavel Stehule	19:35
Re: For loop execution times in PostgreSQL 12 vs 15	Pavel Stehule	19:45

Feb. 13, 2023

Thread	Author	Time
Performance of UPDATE operation	Mkrtchyan, Tigran	15:09
Re: Performance of UPDATE operation	Laurenz Albe	17:47
Re: Performance of UPDATE operation	Oluwatobi Ogunsola	20:52
Re: For loop execution times in PostgreSQL 12 vs 15	Andres Freund	21:21
Re: Performance of UPDATE operation	Jeff Janes	21:49

Feb. 14, 2023

Thread	Author	Time
Re: For loop execution times in PostgreSQL 12 vs 15	Pavel Stehule	05:53

Feb. 15, 2023

Thread	Author	Time
Connection forcibly closed remote server error.	aditya desai	12:13
Re: Connection forcibly closed remote server error.	aditya desai	12:35
Re: Connection forcibly closed remote server error.	Tom Lane	14:58
Re: Connection forcibly closed remote server error.	Jeff Janes	18:36
Re: Connection forcibly closed remote server error.	aditya desai	18:55
Re: Connection forcibly closed remote server error.	Ranier Vilela	19:02

Feb. 21, 2023

Thread	Author	Time
Re: Window Functions & Table Partitions	David Rowley	03:18

Feb. 24, 2023

Thread	Author	Time
BRIN index worse than sequential scan for large search set	Mickael van der Beek	16:40
Re: BRIN index worse than sequential scan for large search set	Justin Pryzby	17:19
Re: BRIN index worse than sequential scan for large search set	Mickael van der Beek	17:51
Re: BRIN index worse than sequential scan for large search set	Justin Pryzby	20:37

Feb. 25, 2023

Thread	Author	Time
Re: BRIN index worse than sequential scan for large search set	Tomas Vondra	16:18

March 1, 2023

Thread	Author	Time
INSERT statement going in IPC Wait_event	aditya desai	20:40
Re: INSERT statement going in IPC Wait_event	Andrew Dunstan	21:36

March 7, 2023

Thread	Author	Time
Planner choosing nested loop in place of Hashjoin	Praneel Devisetty	12:14

March 11, 2023

Thread	Author	Time
Re: Planner choosing nested loop in place of Hashjoin	Samed YILDIRIM	10:31
Re: INSERT statement going in IPC Wait_event	Samed YILDIRIM	10:37
Huge Tables	André Rodrigues	11:47
Re: Planner choosing nested loop in place of Hashjoin	Jeff Janes	22:13

March 12, 2023

Thread	Author	Time
multicolumn partitioning help	James Robertson	17:59

March 13, 2023

Thread	Author	Time
Re: Huge Tables	Rick Otten	12:45
Re: Huge Tables	André Rodrigues	12:51

March 14, 2023

Thread	Author	Time
Re: multicolumn partitioning help	Justin Pryzby	17:54
Re: multicolumn partitioning help	Laurenz Albe	21:41
Re: multicolumn partitioning help	James Robertson	23:33

March 15, 2023

Thread	Author	Time
Re: multicolumn partitioning help	Laurenz Albe	07:37
Re: multicolumn partitioning help	David Rowley	20:46
Re: multicolumn partitioning help	David Rowley	21:20

April 4, 2023

Thread	Author	Time
Explain plan shows fewer shared blocks when index+table compared to index alone?	Amin Jaffer	06:21
Re:Explain plan shows fewer shared blocks when index+table compared to index alone?	Sergei Kornilov	07:51
Why are commits consuming most of the database time?	Tim Slechta	14:46
Re: Why are commits consuming most of the database time?	Tom Lane	14:57
Re: Why are commits consuming most of the database time?	Tim Slechta	20:24

April 6, 2023

Thread	Author	Time
Query unable to utilize index without typecast to fixed length character	ahi	10:23
Re: Query unable to utilize index without typecast to fixed length character	Tom Lane	14:50

April 7, 2023

Thread	Author	Time
Re: Query unable to utilize index without typecast to fixed length character	ahi	07:09
Is there any tool which will help me run and explain analyze about 150 queries?	kunwar singh	17:57
Re: Is there any tool which will help me run and explain analyze about 150 queries?	Achilleas Mantzios	18:19
Re: Is there any tool which will help me run and explain analyze about 150 queries?	kyle Hailey	18:40
Re: Is there any tool which will help me run and explain analyze about 150 queries?	kunwar singh	20:48

April 8, 2023

Thread	Author	Time
Re: Is there any tool which will help me run and explain analyze about 150 queries?	Jerry Sievers	04:40
RE: Query unable to utilize index without typecast to fixed length character	msalais	17:58
Re: Is there any tool which will help me run and explain analyze about 150 queries?	kyle Hailey	21:44

April 9, 2023

Thread	Author	Time
Re: Is there any tool which will help me run and explain analyze about 150 queries?	kunwar singh	22:15

April 11, 2023

Thread	Author	Time
Re: Replication lag due to lagging restart_lsn	milist ujang	03:39

April 12, 2023

Thread	Author	Time
Re: Is there any tool which will help me run and explain analyze about 150 queries?	Michael Christofides	09:17

April 15, 2023

Thread	Author	Time
Re: Replication lag due to lagging restart_lsn	milist ujang	10:41
Postgres Metrics	André Rodrigues	11:04
Re: Postgres Metrics	Joe Conway	14:53

April 16, 2023

Thread	Author	Time
speeding up grafana sensor-data query on raspberry pi 3	Clemens Eisserer	17:00
Re: speeding up grafana sensor-data query on raspberry pi 3	Justin Pryzby	17:15
Re: speeding up grafana sensor-data query on raspberry pi 3	David Rowley	20:50
Re: speeding up grafana sensor-data query on raspberry pi 3	Andres Freund	22:10

April 17, 2023

Thread	Author	Time
Re: speeding up grafana sensor-data query on raspberry pi 3	Luiz Felipph	19:06

April 18, 2023

Thread	Author	Time
Re: time sorted UUIDs	peter plachta	00:25
High QPS, random index writes and vacuum	peter plachta	00:35
Re: High QPS, random index writes and vacuum	Peter Geoghegan	00:38
Re: High QPS, random index writes and vacuum	Tom Lane	02:01
Re: High QPS, random index writes and vacuum	David Rowley	02:40
Re: High QPS, random index writes and vacuum	peter plachta	02:43
Re: High QPS, random index writes and vacuum	peter plachta	02:44
Re: High QPS, random index writes and vacuum	Thomas Munro	02:49
Re: High QPS, random index writes and vacuum	Peter Geoghegan	02:52
Re: speeding up grafana sensor-data query on raspberry pi 3	Clemens Eisserer	12:14

April 20, 2023

Thread	Author	Time
What is equivalent of v$sesstat and v$sql_plan in postgres?	kunwar singh	13:37
Re: What is equivalent of v$sesstat and v$sql_plan in postgres?	MichaelDBA	13:40
Re: speeding up grafana sensor-data query on raspberry pi 3	Clemens Eisserer	16:39

April 22, 2023

Thread	Author	Time
How do Monitoring tools capture explain plan of a query	kunwar singh	15:28
Re: How do Monitoring tools capture explain plan of a query	kyle Hailey	16:17

April 23, 2023

Thread	Author	Time
Re: How do Monitoring tools capture explain plan of a query	kunwar singh	19:28

April 24, 2023

Thread	Author	Time
Re: Postgres Metrics	Jesper Pedersen	08:23

April 28, 2023

Thread	Author	Time
Performance issues in query with multiple joins	Παρασκευη Πασσαρη	12:19
Performance issues in query with multiple joins	David G. Johnston	13:03
Re: Performance issues in query with multiple joins	Tom Lane	14:07

Browse Archives

Prev | Next