pgsql-performance - November 2009

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

Nov. 1, 2009

Thread Author Time
Compression in PG Shaul Dar 14:51
Re: Compression in PG Pavel Stehule 14:56
Re: Compression in PG Jesper Krogh 15:45
Re: Compression in PG Scott Marlowe 15:57
Re: Compression in PG Shaul Dar 16:53
Re: Compression in PG Adam Tauno Williams 17:23
Re: Compression in PG Scott Marlowe 18:27

Nov. 2, 2009

Thread Author Time
Re: Compression in PG Robert Haas 04:24
Re: Compression in PG Eduardo Morras 09:51
Re: database size growing continously Peter Meszaros 12:50
Problem with database performance, Debian 4gb ram ? Massan 13:58
Problem with database performance, Debian 4gb ram ? Grant Masan 14:16
Re: Problem with database performance, Debian 4gb ram ? Grzegorz Jaśkiewicz 14:19
Re: Problem with database performance, Debian 4gb ram ? Ivan Voras 14:22
Re: [PERFORM] Problem with database performance, Debian 4gb ram ? Grzegorz Jaśkiewicz 14:33
Re: database size growing continously Anj Adu 16:14
Re: database size growing continously Robert Haas 20:34
Re: Queryplan within FTS/GIN index -search. Kevin Grittner 22:06

Nov. 3, 2009

Thread Author Time
Re: Queryplan within FTS/GIN index -search. Tom Lane 00:18
Re: Queryplan within FTS/GIN index -search. Kevin Grittner 14:56
Re: Problem with database performance, Debian 4gb ram ? Kevin Grittner 15:13
Re: Queryplan within FTS/GIN index -search. Tom Lane 15:35
Re: Queryplan within FTS/GIN index -search. Kevin Grittner 16:49
Re: Queryplan within FTS/GIN index -search. Kevin Grittner 17:03
Re: Problem with database performance, Debian 4gb ram ? Jeff Janes 17:23
Optimizer + bind variables David Kerr 17:47
Re: Problem with database performance, Debian 4gb ram ? Kevin Grittner 17:54
Re: Queryplan within FTS/GIN index -search. Jesper Krogh 18:36
Free memory usage Sol10, 8.2.9 Subbiah Stalin-XCGF84 19:16
maintaining a reference to a fetched row Brian Karlak 20:30
Re: Free memory usage Sol10, 8.2.9 Jeremy Harris 20:42
Re: Queryplan within FTS/GIN index -search. Kevin Grittner 21:50
Re: Optimizer + bind variables Craig Ringer 23:43
Re: Optimizer + bind variables David Kerr 23:52

Nov. 4, 2009

Thread Author Time
Re: Optimizer + bind variables Chris 00:02
Re: maintaining a reference to a fetched row Craig Ringer 00:03
Re: maintaining a reference to a fetched row Brian Karlak 00:12
Re: Optimizer + bind variables David Kerr 00:18
High Frequency Inserts to Postgres Database vs Writing to a File Jay Manni 03:02
High Frequency Inserts to Postgres Database vs Writing to a File Jay Manni 03:12
Re: High Frequency Inserts to Postgres Database vs Writing to a File Scott Marlowe 03:35
Re: High Frequency Inserts to Postgres Database vs Writing to a File David Saracini 03:42
Re: High Frequency Inserts to Postgres Database vs Writing to a File Greg Smith 04:42
Re: maintaining a reference to a fetched row Tom Lane 05:31
Re: Free memory usage Sol10, 8.2.9 Ivan Voras 10:35
Re: High Frequency Inserts to Postgres Database vs Writing to a File Merlin Moncure 13:59
Re: High Frequency Inserts to Postgres Database vs Writing to a File Greg Smith 14:28
Re: High Frequency Inserts to Postgres Database vs Writing to a File Jeff Janes 16:39
Re: maintaining a reference to a fetched row Jeff Janes 16:47
Re: High Frequency Inserts to Postgres Database vs Writing to a File Anj Adu 16:58
Re: maintaining a reference to a fetched row Brian Karlak 17:25
Re: maintaining a reference to a fetched row Brian Karlak 17:41
Re: maintaining a reference to a fetched row Tom Lane 20:43
vacuum'ing toast crumbs, detecting dangling transactions Dave Crooke 21:18
Re: vacuum'ing toast crumbs, detecting dangling transactions Kevin Grittner 21:30
Re: vacuum'ing toast crumbs, detecting dangling transactions Scott Marlowe 21:51
Followup: vacuum'ing toast Dave Crooke 23:52

Nov. 5, 2009

Thread Author Time
Re: High Frequency Inserts to Postgres Database vs Writing to a File Craig Ringer 01:12
Re: Followup: vacuum'ing toast Greg Smith 01:27
Re: Followup: vacuum'ing toast Craig Ringer 03:01
Re: maintaining a reference to a fetched row Jeff Janes 04:27
Re: Optimizer + bind variables Scott Carey 05:47
Re: High Frequency Inserts to Postgres Database vs Writing to a File Jay Manni 08:01
Re: Followup: vacuum'ing toast Eduardo Morras 09:04
Running some query in low priority S Arvind 09:36
Re: Running some query in low priority Grzegorz Jaśkiewicz 09:38
Re: Running some query in low priority Greg Stark 11:32
Re: Followup: vacuum'ing toast Craig Ringer 11:49
Re: Followup: vacuum'ing toast Craig Ringer 12:09
Re: Running some query in low priority S Arvind 13:20
Re: Running some query in low priority Grzegorz Jaśkiewicz 13:25
Re: Running some query in low priority Matthew Wakeling 13:39
Re: Running some query in low priority Grzegorz Jaśkiewicz 13:42
Re: Followup: vacuum'ing toast Greg Smith 14:28
Re: Running some query in low priority Scott Marlowe 18:02

Nov. 6, 2009

Thread Author Time
Re: Followup: vacuum'ing toast Craig Ringer 08:22
Re: Problem with database performance, Debian 4gb ram ? Craig James 14:37
Re: Problem with database performance, Debian 4gb ram ? Kevin Grittner 15:26
Re: Problem with database performance, Debian 4gb ram ? Alvaro Herrera 15:39

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

Browse Archives

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