pgsql-performance - July 2015

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)

Browse Archives

Prev | Next

July 1, 2015

Thread Author Time
New server: SSD/RAID recommendations? Craig James 23:06
Re: New server: SSD/RAID recommendations? Andreas Joseph Krogh 23:56
Re: New server: SSD/RAID recommendations? Scott Marlowe 23:57

July 2, 2015

Thread Author Time
Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske) 14:01
Re: New server: SSD/RAID recommendations? Merlin Moncure 14:25
Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v 15:41
Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell 16:15
Re: New server: SSD/RAID recommendations? Craig James 17:20
Re: New server: SSD/RAID recommendations? Craig James 17:22
Re: New server: SSD/RAID recommendations? Craig James 17:44
Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske) 18:00
Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus 19:31
Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus 19:33
Re: Sudden connection and load average spikes with postgresql 9.3 Kevin Grittner 21:13
Re: Sudden connection and load average spikes with postgresql 9.3 Scott Marlowe 23:04

July 3, 2015

Thread Author Time
Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell 14:48
Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Marc Mamin 16:15

July 5, 2015

Thread Author Time
9.5alpha1 vs 9.4 Mkrtchyan, Tigran 11:10
Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran 11:46
Re: 9.5alpha1 vs 9.4 Andres Freund 12:54
Re: 9.5alpha1 vs 9.4 Tom Lane 14:33
Re: pgbouncer issue Greg Sabino Mullane 14:47
Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran 17:16

July 6, 2015

Thread Author Time
Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure 16:40
Re: 9.5alpha1 vs 9.4 Josh Berkus 16:45
Re: New server: SSD/RAID recommendations? Steve Crawford 16:56
Re: New server: SSD/RAID recommendations? Joshua D. Drake 17:20
Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran 21:14

July 7, 2015

Thread Author Time
Re: New server: SSD/RAID recommendations? Graeme B. Bell 10:22
Re: New server: SSD/RAID recommendations? Mkrtchyan, Tigran 10:28
Re: New server: SSD/RAID recommendations? Graeme B. Bell 10:38
Re: New server: SSD/RAID recommendations? 📎 Mkrtchyan, Tigran 10:56
Re: New server: SSD/RAID recommendations? Karl Denninger 11:28
Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v 11:29
Re: New server: SSD/RAID recommendations? Graeme B. Bell 11:52
Re: New server: SSD/RAID recommendations? Graeme B. Bell 12:04
Re: New server: SSD/RAID recommendations? Karl Denninger 12:39
Re: New server: SSD/RAID recommendations? Graeme B. Bell 13:08
Re: New server: SSD/RAID recommendations? Merlin Moncure 13:12
Re: New server: SSD/RAID recommendations? Graeme B. Bell 13:25
Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske) 14:15
Re: New server: SSD/RAID recommendations? Heikki Linnakangas 14:59
wildcard text filter switched to boolean column, performance is way worse Mike Broers 15:40
Re: New server: SSD/RAID recommendations? Graeme B. Bell 15:53
Re: New server: SSD/RAID recommendations? Graeme B. Bell 15:58
Re: wildcard text filter switched to boolean column, performance is way worse Tom Lane 16:02
Re: wildcard text filter switched to boolean column, performance is way worse Mike Broers 16:10
Re: New server: SSD/RAID recommendations? Vitalii Tymchyshyn 16:27
Re: wildcard text filter switched to boolean column, performance is way worse Mike Broers 16:28
Re: New server: SSD/RAID recommendations? Merlin Moncure 16:35
Re: New server: SSD/RAID recommendations? Graeme B. Bell 16:46
Re: New server: SSD/RAID recommendations? Graeme B. Bell 16:54
Re: New server: SSD/RAID recommendations? Wei Shan 16:56
Re: New server: SSD/RAID recommendations? Graeme B. Bell 16:58
Re: New server: SSD/RAID recommendations? Karl Denninger 17:05
Re: Sudden connection and load average spikes with postgresql 9.3 Scott Marlowe 17:17
Re: New server: SSD/RAID recommendations? Graeme B. Bell 17:21
Re: New server: SSD/RAID recommendations? Michael Nolan 17:28