pgsql-performance - July 2024

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

July 1, 2024

Thread	Author	Time
a lot of shared buffers hit when planning for a simple query with primary access path	James Pang	09:45
Re: a lot of shared buffers hit when planning for a simple query with primary access path	David Rowley	10:10
Re: a lot of shared buffers hit when planning for a simple query with primary access path	Pavel Stehule	10:20
Re: a lot of shared buffers hit when planning for a simple query with primary access path	David Rowley	10:52
Re: a lot of shared buffers hit when planning for a simple query with primary access path	James Pang	10:58
Re: a lot of shared buffers hit when planning for a simple query with primary access path	Andrei Lepikhov	11:31

July 3, 2024

Thread	Author	Time
Hash Right join and seq scan	James Pang	04:57
Re: Hash Right join and seq scan	James Pang	06:51
Re: Hash Right join and seq scan	James Pang	06:53
Re: Hash Right join and seq scan	Tomas Vondra	17:40

July 4, 2024

Thread	Author	Time
How to solve my slow disk i/o throughput during index scan	FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)	13:25
Re: How to solve my slow disk i/o throughput during index scan	Andrei Lepikhov	14:36
RE: How to solve my slow disk i/o throughput during index scan	FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)	15:23

July 5, 2024

Thread	Author	Time
Re: Hash Right join and seq scan 📎	James Pang	00:50
Re: How to solve my slow disk i/o throughput during index scan	Andrei Lepikhov	02:04
Re: Hash Right join and seq scan	David Rowley	02:15
Re: Hash Right join and seq scan	James Pang	14:43

July 6, 2024

Thread	Author	Time
Re: Hash Right join and seq scan	David Rowley	00:32

July 7, 2024

Thread	Author	Time
Low performance between datacenters	Tamás PAPP	18:17
Re: Low performance between datacenters	Fernando Hevia	20:23

July 8, 2024

Thread	Author	Time
Re: Low performance between datacenters	Vitalii Tymchyshyn	00:42
Re: Hash Right join and seq scan 📎	James Pang	02:21
Re: Hash Right join and seq scan	Justin Pryzby	02:26
Re: Low performance between datacenters	Andrei Lepikhov	07:24

July 10, 2024

Thread	Author	Time
Query performance issue	Dheeraj Sonawane	07:11
Re: Query performance issue	Tom Lane	13:40
Specific objects backup in PostgreSQL	nikhil kumar	18:05
Re: Specific objects backup in PostgreSQL	David G. Johnston	18:41
Re: Specific objects backup in PostgreSQL	Olivier Gautherot	18:42
Re: Specific objects backup in PostgreSQL	Anthony Sotolongo	20:04

July 11, 2024

Thread	Author	Time
Re: Specific objects backup in PostgreSQL	nikhil kumar	03:29
RE: How to solve my slow disk i/o throughput during index scan	FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)	14:59
RE: How to solve my slow disk i/o throughput during index scan	FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)	15:09
Re: How to solve my slow disk i/o throughput during index scan	David G. Johnston	15:19
Re: How to solve my slow disk i/o throughput during index scan	Andrei Lepikhov	15:22
Re: How to solve my slow disk i/o throughput during index scan	Andrei Lepikhov	15:34
inequality predicate not pushed down in JOIN?	Paul George	23:31
Re: inequality predicate not pushed down in JOIN?	Andrei Lepikhov	23:49

July 12, 2024

Thread	Author	Time
Re: inequality predicate not pushed down in JOIN?	Paul George	00:07
Re: inequality predicate not pushed down in JOIN?	Jerry Brenner	00:58

July 19, 2024

Thread	Author	Time
Re: proposal: schema variables	Laurenz Albe	11:41

July 20, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	19:48

July 22, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	06:37
Re: proposal: schema variables	Laurenz Albe	08:23
Re: proposal: schema variables	Pavel Stehule	08:55

July 23, 2024

Thread	Author	Time
Re: proposal: schema variables	Laurenz Albe	14:34
Re: proposal: schema variables	Laurenz Albe	21:41

July 24, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	15:19
Re: proposal: schema variables	Laurenz Albe	17:02
Re: proposal: schema variables 📎	Pavel Stehule	18:01
Re: proposal: schema variables	Pavel Stehule	19:03

July 25, 2024

Thread	Author	Time
Re: proposal: schema variables	Laurenz Albe	13:52
Re: proposal: schema variables 📎	Pavel Stehule	16:32

July 26, 2024

Thread	Author	Time
Outer cost higher than the inner cost 📎	Stanisław Skonieczny	13:25
Re: Outer cost higher than the inner cost	Tom Lane	14:30

July 27, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Laurenz Albe	14:19

July 29, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Laurenz Albe	09:56
Help with row estimate problem	Jon Zeppieri	20:51

July 30, 2024

Thread	Author	Time
Re: Help with row estimate problem	Andrei Lepikhov	15:34
Re: Help with row estimate problem	Jon Zeppieri	17:22
Re: proposal: schema variables 📎	Laurenz Albe	19:46
Re: proposal: schema variables 📎	Pavel Stehule	20:56

July 31, 2024

Thread	Author	Time
logical replication out of memory	James Pang	02:17
Re: logical replication out of memory	James Pang	02:30
Re: logical replication out of memory	khan Affan	05:41
Re: proposal: schema variables	Pavel Stehule	06:41
Re: logical replication out of memory	James Pang	06:48
Re: proposal: schema variables	Laurenz Albe	06:57
Re: proposal: schema variables	Pavel Stehule	07:04
Re: logical replication out of memory	khan Affan	07:06
Re: proposal: schema variables 📎	Laurenz Albe	09:45
Re: proposal: schema variables 📎	Pavel Stehule	22:05

Browse Archives

Prev | Next