pgsql-performance - February 2018

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 6 7 8 9 10 13 14 15 18 19 21 22 23 24 25 26

Feb. 1, 2018

Thread Author Time
Re: effective_io_concurrency on EBS/gp2 📎 hzzhangjiazhi 02:21
Re: 8.2 Autovacuum BUG ? pavan95 06:18
bad plan using nested loops Johan Fredriksson 10:42
Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used 📎 Nandakumar M 14:30
Re: bad plan using nested loops Tom Lane 15:00
Re: effective_io_concurrency on EBS/gp2 Claudio Freire 18:39
SV: bad plan using nested loops Johan Fredriksson 20:34

Feb. 2, 2018

Thread Author Time
Re: SV: bad plan using nested loops Johan Fredriksson 09:02
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Laurenz Albe 09:36
Re: effective_io_concurrency on EBS/gp2 📎 Vitaliy Garnashevich 11:46
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Nandakumar M 14:04
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Tom Lane 15:00
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Nandakumar M 15:49
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used David G. Johnston 15:58
Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Nandakumar M 17:01
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 22:06

Feb. 3, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 David G. Johnston 00:48
Re: [HACKERS] proposal: schema variables Pavel Stehule 06:58
Re: effective_io_concurrency on EBS/gp2 📎 Vitaliy Garnashevich 23:05

Feb. 4, 2018

Thread Author Time
postgresql 10.1 scanning all partitions instead of 1 Mariel Cherkassky 09:23
Re: postgresql 10.1 scanning all partitions instead of 1 Mariel Cherkassky 09:28
postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 10:14
Re: postgresql 10.1 wrong plan in when using partitions bug Tomas Vondra 12:03
Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten 12:15
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 12:19
Re: postgresql 10.1 wrong plan in when using partitions bug legrand legrand 13:19
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 13:22
Re: postgresql 10.1 wrong plan in when using partitions bug legrand legrand 13:29
Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten 13:38
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 13:43
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 14:41
Re: postgresql 10.1 wrong plan in when using partitions bug Andreas Kretschmer 14:54
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 15:06
Re: postgresql 10.1 wrong plan in when using partitions bug Justin Pryzby 15:25
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 15:28
Re: postgresql 10.1 wrong plan in when using partitions bug Tom Lane 15:35
Re: postgresql 10.1 wrong plan in when using partitions bug Tom Lane 15:39
Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky 15:42
Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten 16:04

Feb. 5, 2018

Thread Author Time
Re: effective_io_concurrency on EBS/gp2 Claudio Freire 02:27
Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich 11:26
OT: Performance of VM Thomas Güttler 13:14
Re: OT: Performance of VM Andreas Kretschmer 13:26
Re: OT: Performance of VM Andrew Kerber 16:22
Re: OT: Performance of VM Andreas Kretschmer 16:33
Re: SV: bad plan using nested loops Tomas Vondra 19:15
Re: postgresql 10.1 wrong plan in when using partitions bug Justin Pryzby 19:19
Re: effective_io_concurrency on EBS/gp2 Claudio Freire 20:14

Feb. 6, 2018

Thread Author Time
Details after Load Peak was: OT: Performance of VM Thomas Güttler 14:31
Re: Details after Load Peak was: OT: Performance of VM Alan Hodgson 15:30
Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug) Justin Pryzby 18:18
Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug) Rick Otten 20:02
Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug) Rick Otten 20:03

Feb. 7, 2018

Thread Author Time
Re: effective_io_concurrency on EBS/gp2 Justin Pryzby 05:42
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 06:34
RE: pg_xlog unbounded growth Alex Ignatov 17:11

Feb. 8, 2018

Thread Author Time
Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug) Rick Otten 11:04
Re: effective_io_concurrency on EBS/gp2 📎 Vitaliy Garnashevich 16:05
Re: effective_io_concurrency on EBS/gp2 📎 Vitaliy Garnashevich 16:40

Feb. 9, 2018

Thread Author Time
Same plans different performance? 📎 Elias Panagiotidis 11:56

Feb. 10, 2018

Thread Author Time
Re: OT: Performance of VM Robert Klemme 11:20
Re: OT: Performance of VM Andrew Kerber 14:58

Feb. 13, 2018

Thread Author Time
Efficiently searching for the most recent rows where a column matches any result from a different query mkslaf 13:28
Re: Efficiently searching for the most recent rows where a column matches any result from a different query Hellmuth Vargas 21:13
Re: Details after Load Peak was: OT: Performance of VM Gunnar "Nick" Bluth 21:15
Re: Details after Load Peak was: OT: Performance of VM Micky Gough 21:55

Feb. 14, 2018

Thread Author Time
Re: OT: Performance of VM Mark Kirkwood 03:43

Feb. 15, 2018

Thread Author Time