pgsql-performance - September 2011

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 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Sept. 1, 2011

Thread Author Time
Re: issue related to logging facility of postgres Robert Haas 00:12
Re: issue related to logging facility of postgres Justin Pitts 11:51
Re: Summaries on SSD usage? Jim Nasby 21:28
Re: Summaries on SSD usage? Stefan Keller 22:15
Re: 8.4 optimization regression? Tom Lane 23:13
Re: 8.4 optimization regression? Mark Kirkwood 23:18
Re: 8.4 optimization regression? Mark Kirkwood 23:54

Sept. 2, 2011

Thread Author Time
Re: Summaries on SSD usage? Jesper Krogh 04:14
Re: Summaries on SSD usage? Scott Marlowe 04:58
Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji 05:46
Re: Re: How to track number of connections and hosts to Postgres cluster Scott Marlowe 06:42
Re: Summaries on SSD usage? Shaun Thomas 14:30
Re: Summaries on SSD usage? Stefan Keller 22:04

Sept. 3, 2011

Thread Author Time
Embedded VACUUM C Pond 00:25
Re: Query performance issue Jayadevan 04:48
Re: Summaries on SSD usage? Jesper Krogh 06:49
Sudden drop in DBb performance Gerhard Wohlgenannt 07:26
Re: Summaries on SSD usage? Stefan Keller 08:56

Sept. 4, 2011

Thread Author Time
Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji 08:09
Re: Query performance issue Grzegorz Jaśkiewicz 10:38
Re: Query performance issue Kevin Grittner 14:30
Re: Query performance issue Tom Lane 15:18
Re: Query performance issue Jayadevan 18:06
Re: Query performance issue Tomas Vondra 20:18
Re: 8.4 optimization regression? Tom Lane 22:14

Sept. 5, 2011

Thread Author Time
Re: Query performance issue Jayadevan M 04:19
Re: Sudden drop in DBb performance pasman pasmański 07:27
Re: Sudden drop in DBb performance Tomas Vondra 07:48
Re: Slow performance Kai Otto 09:21
Re: Embedded VACUUM Craig Ringer 09:26
Rather large LA Richard Shaw 10:28
Re: Rather large LA Craig Ringer 10:49
Re: Rather large LA Richard Shaw 10:55
Re: Rather large LA Craig Ringer 11:16
Re: Rather large LA Andy Colson 13:39
Re: Sudden drop in DBb performance Andy Colson 13:51
Re: Rather large LA Richard Shaw 13:57
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 14:08
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 14:14
Re: Sudden drop in DBb performance Tomas Vondra 14:15
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 14:15
Re: Sudden drop in DBb performance Tomas Vondra 14:39
Re: Rather large LA pasman pasmański 15:14
Re: Sudden drop in DBb performance Andy Colson 15:17
Re: Rather large LA Andy Colson 16:47
Re: Rather large LA Andres Freund 17:24
Re: Sudden drop in DBb performance Scott Marlowe 18:45
Re: Sudden drop in DBb performance Andy Colson 19:07
Re: Rather large LA Alan Hodgson 20:05
Re: Rather large LA Scott Marlowe 20:23
Re: Sudden drop in DBb performance Tomas Vondra 20:38
Re: Rather large LA Richard Shaw 22:36
Re: Rather large LA Scott Marlowe 23:31

Sept. 6, 2011

Thread Author Time
Re: Query performance issue Jayadevan 03:30
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 08:26
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 08:32
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 08:40
Re: Sudden drop in DBb performance Gerhard Wohlgenannt 08:55
Re: Sudden drop in DBb performance Tomas Vondra 09:04
Fwd: Summaries on SSD usage? Stefan Keller 13:45
Re: Fwd: Summaries on SSD usage? Shaun Thomas 14:07
Re: Rather large LA Richard Shaw 14:19
Re: Rather large LA Andres Freund 14:51
Re: Sudden drop in DBb performance Tomas Vondra 16:50
how fast index works? Anibal David Acosta 18:31
Re: Rather large LA Alan Hodgson 19:07
Re: Rather large LA Richard Shaw 19:11
Re: how fast index works? Craig James 19:17
Re: Rather large LA Alan Hodgson 19:21
Re: Rather large LA Richard Shaw 19:35
Re: Rather large LA Alan Hodgson 19:47
Re: how fast index works? Anibal David Acosta 20:28
Re: Rather large LA Damon Snyder 20:37

Sept. 7, 2011

Thread Author Time
Re: how fast index works? Craig Ringer 01:03
Re: Rather large LA Vitalii Tymchyshyn 06:54

Sept. 8, 2011

Thread Author Time
how delete/insert/update affects select performace? Anibal David Acosta 12:51
Re: how delete/insert/update affects select performace? Tomas Vondra 14:10
Re: how delete/insert/update affects select performace? Kevin Grittner 14:50
Re: how delete/insert/update affects select performace? Anibal David Acosta 16:40
Re: how delete/insert/update affects select performace? Kevin Grittner 17:00
Re: how fast index works? Merlin Moncure 17:35
Re: how delete/insert/update affects select performace? Anibal David Acosta 19:34
Re: how delete/insert/update affects select performace? Kevin Grittner 19:52
Re: how fast index works? Hany ABOU-GHOURY 21:04
Re: how fast index works? Kevin Grittner 21:30

Sept. 9, 2011

Thread Author Time
Re: how delete/insert/update affects select performace? Greg Smith 01:28
Re: how delete/insert/update affects select performace? Anibal David Acosta 02:36
Re: how delete/insert/update affects select performace? Kevin Grittner 12:04
Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks 16:34
PostgreSQL insights: does it use DMA? Antonio Rodriges 17:55
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner 18:16
Re: PostgreSQL insights: does it use DMA? Scott Marlowe 19:37
Re: PostgreSQL insights: does it use DMA? Antonio Rodriges 19:58
Re: PostgreSQL insights: does it use DMA? pasman pasmański 20:03
Re: PostgreSQL insights: does it use DMA? Kevin Grittner 20:29
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire 21:04
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Claudio Freire 21:05
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner 21:08
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner 21:09

Sept. 10, 2011

Thread Author Time
Re: PostgreSQL insights: does it use DMA? Craig Ringer 00:00
Re: PostgreSQL insights: does it use DMA? Antonio Rodriges 12:06
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks 14:54
should i expected performance degradation over time Anibal David Acosta 16:55
Re: should i expected performance degradation over time Andy Colson 17:20
Re: should i expected performance degradation over time Scott Marlowe 18:30

Sept. 11, 2011

Thread Author Time
Databases optimization Hany ABOU-GHOURY 10:54
Postgres for a "data warehouse", 5-10 TB Igor Chudov 12:35
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 12:52
Re: Postgres for a "data warehouse", 5-10 TB pasman pasmański 13:36
Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov 13:59
Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov 14:00
Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire 14:16
Re: Postgres for a "data warehouse", 5-10 TB Andy Colson 14:16
Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov 14:21
Re: Postgres for a "data warehouse", 5-10 TB Andy Colson 14:23
Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire 14:27
Re: Postgres for a "data warehouse", 5-10 TB Andy Colson 14:36
Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire 14:44
Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp 17:02
Re: Postgres for a "data warehouse", 5-10 TB Ogden 18:36
Re: Postgres for a "data warehouse", 5-10 TB J Sisson 19:08
Re: Postgres for a "data warehouse", 5-10 TB J Sisson 19:30
PostgreSQL performance tweaking on new hardware Ogden 19:50
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 20:10
Re: PostgreSQL performance tweaking on new hardware Scott Marlowe 20:16
Re: Databases optimization Maciek Sakrejda 22:22
RAID Controller (HP P400) beat by SW-RAID? Anthony Presley 22:44
Re: Databases optimization Hany ABOU-GHOURY 22:48
Re: RAID Controller (HP P400) beat by SW-RAID? Stephen Frost 22:51
Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost 23:01
Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov 23:16
Re: RAID Controller (HP P400) beat by SW-RAID? Tomas Vondra 23:17
Re: Postgres for a "data warehouse", 5-10 TB Claudio Freire 23:50

Sept. 12, 2011

Thread Author Time
Re: RAID Controller (HP P400) beat by SW-RAID? Alan Hodgson 02:12
Re: RAID Controller (HP P400) beat by SW-RAID? Scott Marlowe 02:25
Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost 02:28
Re: Postgres for a "data warehouse", 5-10 TB Stephen Frost 02:29
Re: Databases optimization J Sisson 02:46
Re: Postgres for a "data warehouse", 5-10 TB Ondrej Ivanič 02:56
Re: RAID Controller (HP P400) beat by SW-RAID? mark 03:10
Re: RAID Controller (HP P400) beat by SW-RAID? Gavin Flower 03:31
Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas 16:09
Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas 16:22
Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas 16:36
Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley 16:42
Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley 16:56
Re: Re: How to track number of connections and hosts to Postgres cluster Merlin Moncure 17:00
Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme 17:04
Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme 17:15
Re: Postgres for a "data warehouse", 5-10 TB Andy Colson 17:22
Allow sorts to use more available memory Robert Schnabel 17:33
Re: Allow sorts to use more available memory Andy Colson 17:47
Re: Allow sorts to use more available memory Shaun Thomas 17:57
Re: Allow sorts to use more available memory Andy Colson 18:02
Re: Allow sorts to use more available memory Robert Schnabel 18:22
Re: Allow sorts to use more available memory Andy Colson 18:38
Re: Allow sorts to use more available memory Andy Colson 18:57
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 19:08
Re: Allow sorts to use more available memory pasman pasmański 19:12
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 19:48
Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas 20:04
Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp 20:19
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 20:44
Re: Postgres for a "data warehouse", 5-10 TB Shaun Thomas 20:55
Re: Allow sorts to use more available memory Scott Marlowe 20:58
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 21:00
Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme 21:26
Re: Allow sorts to use more available memory Robert Schnabel 22:09
Re: Allow sorts to use more available memory Robert Schnabel 22:21
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ david 22:57
Re: Sudden drop in DBb performance Marinos Yannikos 23:11
Re: Allow sorts to use more available memory Tom Lane 23:20
Re: Databases optimization Hany ABOU-GHOURY 23:28

Sept. 13, 2011

Thread Author Time
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk 00:05
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ david 00:47
Re: Allow sorts to use more available memory Stephen Frost 01:13
Re: Allow sorts to use more available memory Stephen Frost 01:15
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk 02:15
Re: Databases optimization Anthony Presley 02:49
Re: Databases optimization Hany ABOU-GHOURY 03:14
Re: RAID Controller (HP P400) beat by SW-RAID? Arjen van der Meijden 06:22
Re: RAID Controller (HP P400) beat by SW-RAID? Anthony Presley 11:33
PG 9.x prefers slower Hash Joins? Anthony Presley 11:56
Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp 15:13
Re: Postgres for a "data warehouse", 5-10 TB 📎 Robert Klemme 16:34
Re: Postgres for a "data warehouse", 5-10 TB Marc Mamin 17:54
Re: Postgres for a "data warehouse", 5-10 TB Marti Raudsepp 18:11
Re: Postgres for a "data warehouse", 5-10 TB Igor Chudov 18:38
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Carlo Stonebanks 18:56
Re: Postgres for a "data warehouse", 5-10 TB Stefan Keller 18:57
raid array seek performance Samuel Gendler 19:13
Re: Postgres for a "data warehouse", 5-10 TB Scott Marlowe 19:27
Re: Postgres for a "data warehouse", 5-10 TB Gianni Ciolli 19:48
Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme 20:22
Re: Postgres for a "data warehouse", 5-10 TB Robert Klemme 20:26
Re: Postgres for a "data warehouse", 5-10 TB Kevin Grittner 20:34
Re: Migrated from 8.3 to 9.0 - need to update config (re-post) Kevin Grittner 21:13
Hash index use presently(?) discouraged since 2005: revive or bury it? Stefan Keller 23:04
Re: raid array seek performance Samuel Gendler 23:27

Sept. 14, 2011

Thread Author Time
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Peter Geoghegan 00:04

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30