pgsql-performance since 2009-11-08 00:00

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

Nov. 8, 2009

Thread Author Time
CREATE TABLE slowing down significantly over time Aris Samad-Yahaya 03:15
Re: CREATE TABLE slowing down significantly over time Tom Lane 03:29
Re: CREATE TABLE slowing down significantly over time Craig Ringer 03:47
Re: CREATE TABLE slowing down significantly over time Aris Samad-Yahaya 04:55
Re: CREATE TABLE slowing down significantly over time Aris Samad-Yahaya 04:58
Re: CREATE TABLE slowing down significantly over time Scott Marlowe 05:30

Nov. 9, 2009

Thread Author Time
Re: CREATE TABLE slowing down significantly over time Robert Haas 03:58
Re: CREATE TABLE slowing down significantly over time Grzegorz Jaśkiewicz 08:40
Re: CREATE TABLE slowing down significantly over time Robert Haas 12:22
random_page_cost for tablespace Laszlo Nagy 12:58
Re: random_page_cost for tablespace Robert Haas 13:48
Re: maintaining a reference to a fetched row Dimitri Fontaine 14:34
Re: CREATE TABLE slowing down significantly over time Anj Adu 14:46
Re: CREATE TABLE slowing down significantly over time Scott Marlowe 15:33
Re: CREATE TABLE slowing down significantly over time Robert Haas 15:49
Re: random_page_cost for tablespace Laszlo Nagy 16:04
Re: CREATE TABLE slowing down significantly over time Greg Smith 17:04

Nov. 10, 2009

Thread Author Time
limiting performance impact of wal archiving. Laurent Laborde 11:55
Re: limiting performance impact of wal archiving. Kenneth Marshall 13:41
Re: limiting performance impact of wal archiving. Ivan Voras 14:05
Re: limiting performance impact of wal archiving. Laurent Laborde 15:00
Re: limiting performance impact of wal archiving. Ivan Voras 15:11
Re: limiting performance impact of wal archiving. Laurent Laborde 15:29
Re: limiting performance impact of wal archiving. Laurent Laborde 15:37
Re: limiting performance impact of wal archiving. Scott Marlowe 15:43
Re: limiting performance impact of wal archiving. Kevin Grittner 15:48
Re: limiting performance impact of wal archiving. Laurent Laborde 15:53
Re: limiting performance impact of wal archiving. Greg Smith 16:35
Re: limiting performance impact of wal archiving. Laurent Laborde 16:52
Re: limiting performance impact of wal archiving. Scott Marlowe 17:01
Re: limiting performance impact of wal archiving. Craig James 17:07
Re: limiting performance impact of wal archiving. Scott Marlowe 17:10
Re: limiting performance impact of wal archiving. Greg Smith 17:26
Re: limiting performance impact of wal archiving. Greg Smith 17:34
Re: limiting performance impact of wal archiving. Greg Smith 17:48
Re: limiting performance impact of wal archiving. Scott Marlowe 18:10
Re: limiting performance impact of wal archiving. Jeff 20:29

Nov. 11, 2009

Thread Author Time
Database tuning at Duke Greg Smith 00:31
Adaptec Zero-Maintenance Cache Protection - Anyone using? Glyn Astill 12:40
Re: Adaptec Zero-Maintenance Cache Protection - Anyone using? Robert Schnabel 21:16

Nov. 12, 2009

Thread Author Time
Re: Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database. Ing . Marcos Luís Ortíz Valmaseda 06:04
Re: limiting performance impact of wal archiving. Scott Carey 06:37
Re: limiting performance impact of wal archiving. Greg Smith 06:47
Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database. Brahma Prakash Tiwari 08:18
Re: limiting performance impact of wal archiving. Laurent Laborde 14:21
Manual vacs 5x faster than autovacs? Wayne Beaver 14:33
Re: Manual vacs 5x faster than autovacs? Tom Lane 14:49
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 15:14
Re: Manual vacs 5x faster than autovacs? Wayne Beaver 16:14
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 16:33
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 16:38
activerecord-jdbc-adapter bug can affect RoR query performance Kevin Grittner 16:50
Re: Manual vacs 5x faster than autovacs? Wayne Beaver 16:58
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 17:36
Contract Web Architect Opportunity in Portland, Oregon kirk Baillie 18:11

Nov. 13, 2009

Thread Author Time
Re: Manual vacs 5x faster than autovacs? Dave Crooke 06:29
SSD + RAID Laszlo Nagy 12:46
Re: SSD + RAID 📎 Karl Denninger 13:02
Re: SSD + RAID Laszlo Nagy 13:57
Re: SSD + RAID Marcos Ortiz Valmaseda 14:07
Re: SSD + RAID Scott Marlowe 14:48
Re: SSD + RAID Merlin Moncure 15:29
Re: SSD + RAID Heikki Linnakangas 15:36
Re: SSD + RAID Merlin Moncure 15:59
Re: SSD + RAID Greg Smith 17:21
Re: SSD + RAID Scott Carey 17:22
Re: SSD + RAID 📎 Karl Denninger 17:35
Re: SSD + RAID Greg Smith 18:07
Re: SSD + RAID 📎 Karl Denninger 18:21
Re: SSD + RAID Merlin Moncure 18:31
Re: SSD + RAID Merlin Moncure 18:57
Re: SSD + RAID Brad Nicholson 19:24
Re: SSD + RAID Dave Crooke 20:22
Re: SSD + RAID Fernando Hevia 20:57
Re: Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database. Robert Haas 21:05
Re: SSD + RAID Greg Smith 21:06
Re: SSD + RAID Merlin Moncure 21:09
Re: SSD + RAID Greg Smith 21:09
Re: SSD + RAID Kenny Gorman 21:35

Nov. 14, 2009

Thread Author Time
Re: Manual vacs 5x faster than autovacs? Craig Ringer 03:31
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 03:55
Re: Manual vacs 5x faster than autovacs? Craig Ringer 04:45
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 06:02
Re: SSD + RAID Lists 09:30
Re: SSD + RAID Ivan Voras 10:42
Re: SSD + RAID Heikki Linnakangas 11:17
FTS performance with the Polish config Wojciech Knapik 11:25
Re: SSD + RAID Merlin Moncure 13:05
Re: SSD + RAID Heikki Linnakangas 13:47
Re: SSD + RAID Laszlo Nagy 15:09
Re: FTS performance with the Polish config Kenneth Marshall 15:58
Re: FTS performance with the Polish config Tom Lane 17:07
Re: FTS performance with the Polish config Pavel Stehule 17:24
Re: SSD + RAID Robert Haas 20:03
Re: SSD + RAID Merlin Moncure 21:30

Nov. 15, 2009

Thread Author Time
Re: SSD + RAID Laszlo Nagy 02:09
Re: Weird index or sort behaviour 📎 Tom Lane 02:50
Re: SSD + RAID Laszlo Nagy 03:57
Re: SSD + RAID Laszlo Nagy 06:05
Re: FTS performance with the Polish config Oleg Bartunov 07:36
Re: FTS performance with the Polish config Pavel Stehule 07:42
Re: SSD + RAID Laszlo Nagy 08:15
Re: SSD + RAID Craig Ringer 08:46
Re: FTS performance with the Polish config Oleg Bartunov 09:05
Re: FTS performance with the Polish config Pavel Stehule 09:15
Re: SSD + RAID Craig Ringer 10:17
Re: FTS performance with the Polish config Oleg Bartunov 14:06
Re: SSD + RAID Craig James 19:53
Re: SSD + RAID Heikki Linnakangas 20:42
Unexpected sequential scan on an indexed column 📎 Eddy Escardo-Raffo 22:51
Re: limiting performance impact of wal archiving. david 22:54
Re: Unexpected sequential scan on an indexed column Tom Lane 23:05
Re: Unexpected sequential scan on an indexed column Tom Lane 23:33
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 23:59

Nov. 16, 2009

Thread Author Time
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 01:06
Re: Unexpected sequential scan on an indexed column Tom Lane 01:23
Re: limiting performance impact of wal archiving. Laurent Laborde 09:00
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 11:18
Re: Manual vacs 5x faster than autovacs? Wayne Beaver 16:13
Re: Manual vacs 5x faster than autovacs? Scott Marlowe 16:39
Re: Manual vacs 5x faster than autovacs? Wayne Beaver 17:02
Is Diskeeper Automatic Mode safe? cb 17:14
Re: Unexpected sequential scan on an indexed column Dave Crooke 17:44
Re: Is Diskeeper Automatic Mode safe? Robert Haas 18:09
Re: Is Diskeeper Automatic Mode safe? Robert Schnabel 18:11
Re: Is Diskeeper Automatic Mode safe? Robert Haas 19:42
Re: Is Diskeeper Automatic Mode safe? 📎 Robert Schnabel 20:04
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 20:12
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 20:15
Re: Is Diskeeper Automatic Mode safe? Greg Smith 20:20
Re: Is Diskeeper Automatic Mode safe? 📎 Karl Denninger 20:20
Re: Is Diskeeper Automatic Mode safe? Dave Crooke 20:23
Re: Is Diskeeper Automatic Mode safe? 📎 Karl Denninger 20:32
Re: Is Diskeeper Automatic Mode safe? 📎 Robert Schnabel 20:32
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 20:45
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 20:50
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 20:52
Re: Unexpected sequential scan on an indexed column Kenneth Marshall 20:55
Re: Is Diskeeper Automatic Mode safe? 📎 Robert Schnabel 21:04
Re: Is Diskeeper Automatic Mode safe? John Rouillard 21:05
Re: Is Diskeeper Automatic Mode safe? Craig James 21:09
Re: Is Diskeeper Automatic Mode safe? Alvaro Herrera 21:25
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 21:51
Re: Unexpected sequential scan on an indexed column Dave Crooke 21:52
Re: Unexpected sequential scan on an indexed column Eddy Escardo-Raffo 22:15

Nov. 17, 2009

Thread Author Time
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 00:01
Re: Is Diskeeper Automatic Mode safe? cb 01:12
Re: Is Diskeeper Automatic Mode safe? cb 01:22
Re: Is Diskeeper Automatic Mode safe? Tom Lane 01:31
Re: Is Diskeeper Automatic Mode safe? Greg Smith 02:45
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 04:41
Re: Is Diskeeper Automatic Mode safe? cb 04:57
Re: Is Diskeeper Automatic Mode safe? Greg Smith 10:33
Performance regression 8.3.8 -> 8.4.1 with NOT EXISTS Wiktor Wodecki 13:20
Re: Is Diskeeper Automatic Mode safe? Kevin Grittner 14:59
Re: Is Diskeeper Automatic Mode safe? Scott Marlowe 15:22
Re: Is Diskeeper Automatic Mode safe? Craig James 15:51
Re: Performance regression 8.3.8 -> 8.4.1 with NOT EXISTS Tom Lane 16:30
Re: SSD + RAID Merlin Moncure 16:36
Re: SSD + RAID Brad Nicholson 16:54
Re: SSD + RAID Scott Marlowe 17:04
Re: Is Diskeeper Automatic Mode safe? Brad Nicholson 17:10
Re: SSD + RAID Peter Eisentraut 17:30
Re: SSD + RAID Greg Smith 18:51
Re: SSD + RAID Merlin Moncure 19:19
Re: SSD + RAID Mark Mielke 20:09

Nov. 18, 2009

Thread Author Time
Re: SSD + RAID Greg Smith 06:32
Re: SSD + RAID david 06:58
Re: Performance regression 8.3.8 -> 8.4.1 with NOT EXISTS Grzegorz Jaśkiewicz 08:17
Re: Weird index or sort behaviour Matthew Wakeling 11:39
Too much blocks read Waldomiro 16:22
Re: Too much blocks read Matthew Wakeling 16:23
Re: Too much blocks read Craig James 16:29
Re: Too much blocks read A. Kretschmer 16:30
Re: SSD + RAID Kenny Gorman 22:59

Nov. 19, 2009

Thread Author Time
Re: SSD + RAID Scott Carey 04:06
Re: SSD + RAID Scott Carey 04:22
Re: SSD + RAID Tom Lane 04:24
Re: SSD + RAID Scott Carey 04:35
Re: SSD + RAID Scott Carey 04:39
Re: SSD + RAID Craig Ringer 12:29
Re: SSD + RAID Greg Smith 14:44
Re: SSD + RAID 📎 Karl Denninger 14:44
Re: SSD + RAID Greg Smith 14:49
Re: SSD + RAID Merlin Moncure 17:01
View based upon function won't use index on joins Jonathan Foy 17:06
Re: SSD + RAID Scott Marlowe 17:19
Re: SSD + RAID Anton Rommerskirchen 18:01
FSM - per database or per installation? Craig James 18:12
Re: FSM - per database or per installation? Heikki Linnakangas 18:33
Re: SSD + RAID Brad Nicholson 18:57
Re: SSD + RAID Greg Smith 21:04
Re: SSD + RAID Greg Smith 21:10
Re: SSD + RAID Merlin Moncure 21:39
Re: SSD + RAID Scott Marlowe 21:52

Nov. 20, 2009

Thread Author Time
Partitions and max_locks_per_transaction Hrishikesh (हृषीकेश मेहेंदळे) 01:22
Postgres query completion status? Richard Neill 05:32
Re: Postgres query completion status? Greg Williamson 06:07
Re: Postgres query completion status? Richard Neill 06:32
Re: Postgres query completion status? Richard Neill 06:50

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