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

Aug. 1, 2011

Thread Author Time
Re: Trigger or Function Robert Klemme 07:18
How to Speed up Insert from Multiple Connections Adarsh Sharma 07:31
Re: insert Vitalii Tymchyshyn 08:52
Re: Performance die when COPYing to table with bigint PK Simon Riggs 08:54
Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn 09:06
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 09:15
Re: Trigger or Function Gavin Flower 09:26
Parameters for PostgreSQL Jayadevan M 12:09
synchronous_commit off Anibal David Acosta 13:29
Re: How to Speed up Insert from Multiple Connections Kevin Grittner 13:57
Re: insert Kevin Grittner 14:47
Re: synchronous_commit off Greg Smith 19:52
Re: synchronous_commit off Anibal David Acosta 20:05
Re: Parameters for PostgreSQL Merlin Moncure 20:25
Re: synchronous_commit off Craig Ringer 23:49
Re: Parameters for PostgreSQL Craig Ringer 23:57

Aug. 2, 2011

Thread Author Time
Tsearch2 - bad performance with concatenated ts-vectors Jan Wielgus 06:22
Which Join is better Adarsh Sharma 06:42
Re: Which Join is better Maria Arias de Reyna 06:47
Re: Which Join is better Szymon Guz 06:47
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 08:26
Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn 08:42
Array access performance Andreas Brandl 13:00
Re: Array access performance Andreas Brandl 13:11
Re: Array access performance Tom Lane 14:49
Re: Array access performance Andreas Brandl 15:16
Re: Performance die when COPYing to table with bigint PK Kevin Grittner 17:41
Re: Performance penalty when using WITH Merlin Moncure 21:48
Re: Tsearch2 - bad performance with concatenated ts-vectors Gavin Flower 23:01

Aug. 3, 2011

Thread Author Time
Re: synchronous_commit off lars hofhansl 00:08
Re: Which Join is better lars hofhansl 00:16
Re: Performance penalty when using WITH Robert Klemme 07:18
Suspected Postgres Datacorruption Sumeet Jauhar 07:35
Re: Performance penalty when using WITH Li Jin 13:27
Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Robert Haas 13:29
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 14:39
Re: Performance penalty when using WITH Robert Klemme 16:15
Re: Performance penalty when using WITH Merlin Moncure 16:24
Postgres performance on Linux and Windows Dusan Misic 16:37
Re: Postgres performance on Linux and Windows Andy Colson 17:05
Re: Performance penalty when using WITH Robert Klemme 17:13
Fwd: Suspected Postgres Datacorruption Sumeet Jauhar 17:14
Re: Postgres performance on Linux and Windows Dusan Misic 17:16
Re: Postgres performance on Linux and Windows Kevin Grittner 17:29
Re: Performance penalty when using WITH Robert Klemme 17:30

Aug. 4, 2011

Thread Author Time
Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey 01:53
Re: Parameters for PostgreSQL Jayadevan M 03:42
Re: Parameters for PostgreSQL Craig Ringer 03:54
Re: Parameters for PostgreSQL Craig Ringer 04:03
Need to tune for Heavy Write Adarsh Sharma 04:56
Re: Parameters for PostgreSQL Adarsh Sharma 05:15
Re: Need to tune for Heavy Write Dusan Misic 08:18
Re: Need to tune for Heavy Write Willy-Bas Loos 08:34
Re: Need to tune for Heavy Write Dusan Misic 08:43
Re: Need to tune for Heavy Write Scott Marlowe 08:46
Re: Need to tune for Heavy Write Dusan Misic 09:03
Re: Need to tune for Heavy Write Nicholson, Brad (Toronto, ON, CA) 12:41
Seq Scan vs. Index Scan Nassib Nassar 13:40
Re: Need to tune for Heavy Write Craig Ringer 13:49
Re: Need to tune for Heavy Write Kevin Grittner 13:57
Re: Parameters for PostgreSQL Andy Colson 13:57
Re: Need to tune for Heavy Write Scott Marlowe 15:07
Re: Seq Scan vs. Index Scan Kevin Grittner 15:07
Re: Performance die when COPYing to table with bigint PK Kevin Grittner 15:59
Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn 16:11
Re: Need to tune for Heavy Write Scott Marlowe 16:40
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 17:19
Re: Performance die when COPYing to table with bigint PK Kevin Grittner 17:22
Re: Need to tune for Heavy Write Samuel Gendler 17:40
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 18:33
table size is bigger than expected Jian Shi 18:56
Re: table size is bigger than expected Justin Pitts 20:17
Postgres 8.4 memory related parameters Claire Chang 20:27
Re: Postgres 8.4 memory related parameters Kevin Grittner 20:38
Re: Postgres 8.4 memory related parameters Shaun Thomas 21:02
Re: Postgres 8.4 memory related parameters Scott Marlowe 21:12
Re: Tsearch2 - bad performance with concatenated ts-vectors Kevin Grittner 21:16
Re: Suspected Postgres Datacorruption Scott Marlowe 21:21
Re: Postgres 8.4 memory related parameters Kevin Grittner 21:36
Re: Suspected Postgres Datacorruption Nicholson, Brad (Toronto, ON, CA) 21:47
Re: Postgres 8.4 memory related parameters Shaun Thomas 21:49
Re: Postgres 8.4 memory related parameters Kevin Grittner 21:54
Re: Postgres 8.4 memory related parameters Shaun Thomas 21:58
Re: Suspected Postgres Datacorruption Nicholson, Brad (Toronto, ON, CA) 22:00
Re: Need to tune for Heavy Write Mark Kirkwood 22:32
Re: table size is bigger than expected Steve Crawford 23:47

Aug. 5, 2011

Thread Author Time
Re: Suspected Postgres Datacorruption Sumeet Jauhar 02:33
Re: Suspected Postgres Datacorruption Scott Marlowe 02:40
Re: Suspected Postgres Datacorruption Scott Marlowe 02:41
Re: Suspected Postgres Datacorruption Sumeet Jauhar 02:58
Re: Suspected Postgres Datacorruption Tom Lane 03:05
Re: Performance die when COPYing to table with bigint PK Віталій Тимчишин 07:14
Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan 08:44
Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes 09:58
Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn 10:36
Re: Postgres 8.4 memory related parameters Kevin Grittner 14:00
Re: Postgres 8.4 memory related parameters Shaun Thomas 14:21
Re: Postgres 8.4 memory related parameters Kevin Grittner 14:58
Re: Postgres 8.4 memory related parameters Kevin Grittner 15:05
PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh 16:43
Re: Postgres 8.4 memory related parameters Shaun Thomas 17:09
Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner 17:20

Aug. 6, 2011

Thread Author Time
Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh 02:16
Re: PostgreSQL 9.0.1 on Windows performance tunning help please Greg Williamson 03:09
Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh 03:43
Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner 16:07
Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner 16:26

Aug. 8, 2011

Thread Author Time
XFS options and benchmark woes mark 06:14
Re: XFS options and benchmark woes mark 06:18
Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh 18:19
Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner 18:35

Aug. 9, 2011

Thread Author Time
benchmark woes and XFS options mark 02:06
Re: benchmark woes and XFS options Greg Smith 03:42
Re: Postgres performance on Linux and Windows Greg Smith 03:52
Re: Postgres 8.4 memory related parameters Greg Smith 03:59
Re: Suspected Postgres Datacorruption Greg Smith 04:13
Re: benchmark woes and XFS options mark 04:13

Aug. 10, 2011

Thread Author Time
Re: Fwd: Suspected Postgres Datacorruption Craig Ringer 06:05
poor pefrormance with regexp searches on large tables Grzegorz Blinowski 14:26
Re: poor pefrormance with regexp searches on large tables Tomas Vondra 15:08
Re: poor pefrormance with regexp searches on large tables pasman pasmański 15:09
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 15:27
Autovacuum running out of memory Alexis Lê-Quôc 15:28
Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski 17:01
Re: poor pefrormance with regexp searches on large tables Tomas Vondra 17:15
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 17:17
Re: Autovacuum running out of memory Tom Lane 17:17
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 17:22
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 18:10
Re: Autovacuum running out of memory Alexis Lê-Quôc 18:47
Re: Autovacuum running out of memory Tom Lane 18:54
Re: Autovacuum running out of memory Alexis Lê-Quôc 19:08
Re: Autovacuum running out of memory Tom Lane 19:27

Aug. 11, 2011

Thread Author Time
Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski 08:39
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 13:56
Streaming replication performance Antonin Faltynek 14:46
Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 23:35

Aug. 12, 2011

Thread Author Time
Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 00:03
Re: Recommended optimisations slows down PostgreSQL 8.4 [email protected] 00:18
Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 00:27
Re: Recommended optimisations slows down PostgreSQL 8.4 Greg Smith 01:17
Re: Recommended optimisations slows down PostgreSQL 8.4 Craig Ringer 02:17
pgpool master or slave goes down java access error jenopob 10:58
Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski 15:07
Re: poor pefrormance with regexp searches on large tables Kevin Grittner 15:25
Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 16:28
Re: Recommended optimisations slows down PostgreSQL 8.4 Merlin Moncure 16:32
Re: pgpool master or slave goes down java access error Waldo Nell 16:44
Re: Streaming replication performance Merlin Moncure 16:47
Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 16:54
Re: Recommended optimisations slows down PostgreSQL 8.4 Kevin Grittner 17:10
Re: Recommended optimisations slows down PostgreSQL 8.4 Greg Smith 17:15
Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell 17:19
Re: Recommended optimisations slows down PostgreSQL 8.4 Tom Lane 18:41
Re: Recommended optimisations slows down PostgreSQL 8.4 Stephen Frost 21:07
How to see memory usage using explain analyze ? hyelluas 21:29
strange pgbench results (as if blocked at the end) Tomas Vondra 23:37

Aug. 13, 2011

Thread Author Time
Re: strange pgbench results (as if blocked at the end) Craig Ringer 00:18
Re: strange pgbench results (as if blocked at the end) Greg Smith 03:09

Aug. 14, 2011

Thread Author Time
Re: strange pgbench results (as if blocked at the end) tv 12:51
Re: strange pgbench results (as if blocked at the end) Scott Marlowe 13:15
Re: strange pgbench results (as if blocked at the end) tv 14:10
Re: strange pgbench results (as if blocked at the end) Tom Lane 17:33

Aug. 15, 2011

Thread Author Time
Re: strange pgbench results (as if blocked at the end) Greg Smith 00:28
Re: How to see memory usage using explain analyze ? Igor Neyman 18:19
Re: How to see memory usage using explain analyze ? hyelluas 18:32
Re: strange pgbench results (as if blocked at the end) Greg Smith 20:36
Reports from SSD purgatory Greg Smith 23:49

Aug. 16, 2011

Thread Author Time
Re: Reports from SSD purgatory David Boreham 04:13
index not being used when variable is sent Eyal Wilde 04:30
Re: index not being used when variable is sent Tom Lane 13:40
Re: Streaming replication performance Pin007 20:03

Aug. 17, 2011

Thread Author Time
Tuning Tips for a new Server Ogden 01:35
Re: index not being used when variable is sent Eyal Wilde 06:49
Re: Tuning Tips for a new Server Andy Colson 13:41
Re: Tuning Tips for a new Server Ogden 14:28
Re: Tuning Tips for a new Server Tomas Vondra 14:44
Re: Tuning Tips for a new Server Tomas Vondra 15:08
Re: How to see memory usage using explain analyze ? Igor Neyman 15:27
Re: DBT-5 & Postgres 9.0.3 bobbyw 15:29
Re: Tuning Tips for a new Server Ogden 16:39
Re: DBT-5 & Postgres 9.0.3 Andy Colson 17:28
Re: DBT-5 & Postgres 9.0.3 bobbyw 17:59
Re: DBT-5 & Postgres 9.0.3 [email protected] 18:14
Calculating statistic via function rather than with query is slowing my query Anish Kejariwal 18:20
Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden 18:26
Re: Calculating statistic via function rather than with query is slowing my query Pavel Stehule 18:27
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ [email protected] 18:31
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden 18:32
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Gary Doades 18:33
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ [email protected] 18:35
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Andy Colson 18:48
Re: How to see memory usage using explain analyze ? hyelluas 18:51
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden 18:55
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden 18:56
Re: Tuning Tips for a new Server Tomas Vondra 18:56
Re: Calculating statistic via function rather than with query is slowing my query Anish Kejariwal 19:00
Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Gary Doades 19:04
Re: Calculating statistic via function rather than with query is slowing my query Pavel Stehule 19:08
Re: Tuning Tips for a new Server Ogden 19:09

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 29 30 31