pgsql-performance - October 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 4 5 6 7 8 10 11 12 13 14 18 19 20 22 25 26 27 28

Oct. 1, 2021

Thread Author Time
Query going to all paritions aditya desai 07:28
Re: Query going to all paritions Laurenz Albe 07:53
Re: Query going to all paritions 📎 aditya desai 08:54
Re: Query going to all paritions hubert depesz lubaczewski 10:33
Re: Query going to all paritions aditya desai 11:33
Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeff Holt 20:06

Oct. 4, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe 06:34

Oct. 5, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 01:51
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle [email protected] 02:25
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 03:08
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 03:30
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 04:04
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 04:40
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe 08:26
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Ranier Vilela 11:44
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 14:41
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan 20:24
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 21:27

Oct. 6, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Tim 00:02
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 02:39
Installation of PostgreSQL on fedora zVM Manish Lad 05:13
Troubleshooting a long running delete statement Dirschel, Steve 18:00
Re: Troubleshooting a long running delete statement Mladen Gogala 18:54
Re: Troubleshooting a long running delete statement Justin Pryzby 19:20
Re: Troubleshooting a long running delete statement Laurenz Albe 19:48
RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve 20:26
RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve 20:32

Oct. 7, 2021

Thread Author Time
Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala 01:25
Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala 01:30
Re: Troubleshooting a long running delete statement Michael Lewis 04:44
Re: [EXT] Re: Troubleshooting a long running delete statement Maciek Sakrejda 05:15
Re: [EXT] Re: Troubleshooting a long running delete statement Corey Huinker 19:30

Oct. 8, 2021

Thread Author Time
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 01:09
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider 02:15
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian 02:38
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala 03:35
Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider 05:22
PG 12 slow selects from pg_settings Julius Tuskenis 07:01
Re: PG 12 slow selects from pg_settings Ranier Vilela 11:00
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

Browse Archives

Prev | Next
Jump to day: 1 4 5 6 7 8 10 11 12 13 14 18 19 20 22 25 26 27 28