pgsql-performance - December 2020

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 2 3 4 5 11 14 16 17 18 19 23 26 28 29

Dec. 1, 2020

Thread Author Time
Pg_locks and pg_stat_activity aditya desai 16:11

Dec. 2, 2020

Thread Author Time
Re: Pg_locks and pg_stat_activity aditya desai 10:36

Dec. 3, 2020

Thread Author Time
time taking deletion on large tables Atul Kumar 08:49
time taking deletion on large tables Atul Kumar 14:45
time taking deletion on large tables Atul Kumar 14:45
time taking deletion on large tables Atul Kumar 14:46
time taking deletion on large tables Atul Kumar 14:47
time taking deletion on large tables Atul Kumar 14:49
Re: time taking deletion on large tables hubert depesz lubaczewski 14:51
Re: time taking deletion on large tables Ravikumar Reddy 15:13
Re: time taking deletion on large tables Justin Pryzby 15:36
Re: time taking deletion on large tables Ron 15:48
Re: time taking deletion on large tables Tom Lane 16:16
Re: time taking deletion on large tables Andrew Dunstan 17:00
Re: time taking deletion on large tables Rui DeSousa 18:45
Temporarily disable not null constraints Nagaraj Raj 19:58
Re: Temporarily disable not null constraints Michael Lewis 20:09
Re: Temporarily disable not null constraints Milos Babic 20:13
Re: Temporarily disable not null constraints Justin Pryzby 22:34

Dec. 4, 2020

Thread Author Time
Re: Pg_locks and pg_stat_activity aditya desai 06:13
Re: Pg_locks and pg_stat_activity Ravikumar Reddy 06:41
Re: Pg_locks and pg_stat_activity Justin Pryzby 06:48
Re: Pg_locks and pg_stat_activity Kyotaro Horiguchi 07:52
Re: Pg_locks and pg_stat_activity aditya desai 08:01
Re: Pg_locks and pg_stat_activity aditya desai 08:04
Re: Pg_locks and pg_stat_activity Justin Pryzby 08:17
Re: Pg_locks and pg_stat_activity aditya desai 08:34
PostgeSQL JSONB Column with various type of data Riswana Rahman 10:45
Index for range queries on JSON (user defined fields) Marco Colli 15:39
Re: PostgeSQL JSONB Column with various type of data Michael Lewis 16:31
Re: Index for range queries on JSON (user defined fields) Nick Cleaton 22:39

Dec. 5, 2020

Thread Author Time
Re: Index for range queries on JSON (user defined fields) Marco Colli 10:50

Dec. 11, 2020

Thread Author Time
"Required checkpoints occurs too frequently" Atul Kumar 08:12
Re: "Required checkpoints occurs too frequently" Laurenz Albe 08:51
Re: "Required checkpoints occurs too frequently" Atul Kumar 09:02
Re: "Required checkpoints occurs too frequently" Amine Tengilimoglu 09:19
Re: "Required checkpoints occurs too frequently" Atul Kumar 14:34
Re: "Required checkpoints occurs too frequently" Christophe Pettus 16:15

Dec. 14, 2020

Thread Author Time
Performance issues with composite types (partitioned table) 📎 Sebastijan Wieser 15:01

Dec. 16, 2020

Thread Author Time
Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao 11:54
RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao 11:55
Re: Autovacuum not functioning for large tables but it is working for few other small tables. Martín Marqués 15:14
Re: Autovacuum not functioning for large tables but it is working for few other small tables. Michael Lewis 15:28
Re: Autovacuum not functioning for large tables but it is working for few other small tables. Jeff Janes 18:18

Dec. 17, 2020

Thread Author Time
Re: Autovacuum not functioning for large tables but it is working for few other small tables. Tomas Vondra 01:46

Dec. 18, 2020

Thread Author Time
Oracle to postgresql bangalore umesh 10:43
Re: Oracle to postgresql Ian Lawrence Barwick 11:14

Dec. 19, 2020

Thread Author Time
Reversing NULLS in ORDER causes index not to be used? Ken Tanzer 01:53
Re: Reversing NULLS in ORDER causes index not to be used? Tom Lane 02:02
Re: Reversing NULLS in ORDER causes index not to be used? Ken Tanzer 02:30
Re: proposal: schema variables 📎 Pavel Stehule 06:57

Dec. 23, 2020

Thread Author Time
Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Gunther Schadow 18:01
Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Marco Colli 18:34
Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Bruce Momjian 19:09

Dec. 26, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 04:52
Re: proposal: schema variables Erik Rijkers 06:18
Re: proposal: schema variables Pavel Stehule 06:23

Dec. 28, 2020

Thread Author Time
Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines 14:50
Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Michael Lewis 15:12
Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Greg Spiegelberg 16:09

Dec. 29, 2020

Thread Author Time
Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines 22:40
Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines 22:45

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 11 14