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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 13 14 15 16 17 19 20 22 23 29 30

April 1, 2015

Thread Author Time
Re: Some performance testing? Przemysław Deć 09:02
Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 13:56
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Ilya Kosmodemiansky 14:27
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Aidan Van Dyk 14:32
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Wei Shan 14:44
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Jeff Janes 16:38

April 2, 2015

Thread Author Time
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Gerardo Herzig 02:19
Poor performing query re-write using tsrange index Burgess, Freddie 03:26
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 10:33
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 10:47
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 10:51
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 10:57
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Mkrtchyan, Tigran 12:22
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL didier 12:29
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Aidan Van Dyk 12:51
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 13:23
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 13:52
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Aidan Van Dyk 14:00
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 14:25
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL didier 15:11

April 3, 2015

Thread Author Time
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 13:43
Re: PATCH: adaptive ndistinct estimator v4 Greg Stark 13:46
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 13:55
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Josh Krupka 15:00
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 15:10
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Josh Krupka 15:21
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 15:33
Re: Some performance testing? Mel Llaguno 17:44

April 4, 2015

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v4 Tomas Vondra 23:57

April 6, 2015

Thread Author Time
Re: Some performance testing? Josh Berkus 20:51

April 7, 2015

Thread Author Time
Re: Some performance testing? Mel Llaguno 16:46
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 16:49
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 17:17
Re: Some performance testing? Josh Berkus 17:41
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 17:45
Re: Some performance testing? Mel Llaguno 18:07
Re: views much slower in 9.3 than 8.4 Jim Nasby 23:30
Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Jim Nasby 23:38
Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Qingqing Zhou 23:50

April 8, 2015

Thread Author Time
Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL Pietro Pugni 10:37
Re: Some performance testing? Josh Berkus 19:05
Re: Some performance testing? Mel Llaguno 21:29
Re: Some performance testing? Michael Nolan 22:09

April 9, 2015

Thread Author Time
Re: Some performance testing? Graeme B. Bell 09:04
Re: Some performance testing? Przemysław Deć 10:39
Re: Some performance testing? Graeme B. Bell 11:01
Re: Some performance testing? Przemysław Deć 11:56
Re: Some performance testing? Graeme B. Bell 13:35
NVMe or AHCI PCI-express? A comment for people benchmarking... Graeme B. Bell 14:45
Re: Some performance testing? Scott Marlowe 15:15
Re: Some performance testing? Wes Vaske (wvaske) 15:20
Cannot get query to use btree-gin index when ORDER BY Andreas Joseph Krogh 21:39

April 10, 2015

Thread Author Time
Re: Some performance testing? Michael Nolan 13:21
Re: Some performance testing? Graeme B. Bell 13:29

April 13, 2015

Thread Author Time
Re: unlogged tables dgabriel 19:31
Re: unlogged tables Matheus de Oliveira 19:36
Re: unlogged tables dgabriel 20:16
Re: unlogged tables Yves Dorfsman 20:30
Re: unlogged tables Matheus de Oliveira 20:40
Re: unlogged tables David G. Johnston 20:49
Re: unlogged tables Jim Nasby 20:58
Re: unlogged tables Alvaro Herrera 21:13
Re: unlogged tables Jim Nasby 22:38
Re: unlogged tables Jeff Janes 23:49

April 14, 2015

Thread Author Time
Re: unlogged tables David G. Johnston 00:32
Re: unlogged tables Jim Nasby 02:45
Re: unlogged tables David G. Johnston 03:28
Re: unlogged tables Yves Dorfsman 15:41
Re: unlogged tables dgabriel 15:56
Re: unlogged tables Jeff Janes 16:58
Re: unlogged tables Jeff Janes 17:37
Re: Some performance testing? Josh Berkus 19:58
Re: unlogged tables Jim Nasby 20:34

April 15, 2015

Thread Author Time
Performance of vacuumlo Andreas Joseph Krogh 01:46
Re: PATCH: adaptive ndistinct estimator v4 Jeff Janes 06:45

April 16, 2015

Thread Author Time
Re: [PERFORM] pushing order by + limit to union subqueries Qingqing Zhou 18:49

April 17, 2015

Thread Author Time
Postgresql Host Swapping Hard With Abundant Free Memory Christian Gough 18:25

April 19, 2015

Thread Author Time
extract(year from date) doesn't use index but maybe could? Jon Dufresne 17:16
Re: extract(year from date) doesn't use index but maybe could? Tomas Vondra 17:42
Re: extract(year from date) doesn't use index but maybe could? Jon Dufresne 20:10
Re: extract(year from date) doesn't use index but maybe could? Adam Tauno Williams 21:03
Re: extract(year from date) doesn't use index but maybe could? Tomas Vondra 21:12
Re: extract(year from date) doesn't use index but maybe could? Tom Lane 21:33
Re: extract(year from date) doesn't use index but maybe could? Yves Dorfsman 22:05
Re: extract(year from date) doesn't use index but maybe could? Tom Lane 22:29

April 20, 2015

Thread Author Time
Re: extract(year from date) doesn't use index but maybe could? Gavin Flower 00:13
Re: PATCH: adaptive ndistinct estimator v4 Jeff Janes 05:13

April 22, 2015

Thread Author Time
Re: extract(year from date) doesn't use index but maybe could? Jim Nasby 16:15
Query plan with missing timespans Andomar 17:37
Re: Query plan with missing timespans Kevin Grittner 19:47
Re: Query plan with missing timespans Andomar 19:59
Re: Query plan with missing timespans Jason Petersen 20:18
Re: Postgresql Host Swapping Hard With Abundant Free Memory Jim Nasby 23:33

April 23, 2015

Thread Author Time
Re: Query plan with missing timespans Kyotaro HORIGUCHI 04:40
PostgreSQL disk fragmentation causes performance problems on Windows Jan Gunnar Dyrset 19:47

April 29, 2015

Thread Author Time
Re: PostgreSQL disk fragmentation causes performance problems on Windows Andres Freund 08:06
Re: PostgreSQL disk fragmentation causes performance problems on Windows Andres Freund 08:08
Re: PostgreSQL disk fragmentation causes performance problems on Windows Joshua D. Drake 14:07
Re: PostgreSQL disk fragmentation causes performance problems on Windows [email protected] 14:35
Re: PostgreSQL disk fragmentation causes performance problems on Windows Andrew Dunstan 14:56

April 30, 2015

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v4 Robert Haas 20:57
Re: PATCH: adaptive ndistinct estimator v4 Heikki Linnakangas 21:31
Re: PATCH: adaptive ndistinct estimator v4 Robert Haas 22:18

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 13 14 15 16 17 19 20 22 23 29 30