pgsql-performance since 2011-01-17 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 23 24 25 26 27 28 29 30 31

Jan. 17, 2011

Thread Author Time
Possible to improve query plan? Jeremy Palmer 03:21
Re: Possible to improve query plan? Andy Colson 04:22
Possible to improve query plan? Jeremy Palmer 04:43
Re: Possible to improve query plan? Andy Colson 04:57
Re: Possible to improve query plan? Jeremy Palmer 05:13
Bad plan when join on function Zotov 08:03
Re: Possible to improve query plan? Jayadevan M 08:44
Re: Possible to improve query plan? Ing. Marcos Ortiz Valmaseda 13:37
"NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios 15:35
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala 16:47
Re: Possible to improve query plan? Kevin Grittner 16:48
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Ing. Marcos Ortiz Valmaseda 16:52
Re: Bad plan when join on function Pavel Stehule 20:12
Re: Possible to improve query plan? Tom Lane 20:24
Re: Bad plan when join on function Kevin Grittner 20:51
Re: Possible to improve query plan? Jeremy Palmer 20:52
Re: Possible to improve query plan? Jeremy Palmer 21:01
Re: Bad plan when join on function Pavel Stehule 21:24
Re: Bad plan when join on function Tom Lane 21:33
Re: Bad plan when join on function Pavel Stehule 21:37
Re: Possible to improve query plan? Mladen Gogala 22:11
Re: Problem with query Fernando Hevia 23:42

Jan. 18, 2011

Thread Author Time
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios 08:06
Re: The good, old times Devrim GÜNDÜZ 08:43
Re: The good, old times Dave Page 08:57
Migrating to Postgresql and new hardware Lars 10:56
Re: Bad plan when join on function Shaun Thomas 14:15
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala 14:26
Re: [PERFORM] pgbench to the MAXINT Greg Smith 18:42
Re: hashed subplan 5000x slower than two sequential operations masterchief 18:56
Re: Migrating to Postgresql and new hardware Andy Colson 19:17
Re: Migrating to Postgresql and new hardware Andy Colson 19:19
Re: hashed subplan 5000x slower than two sequential operations Віталій Тимчишин 21:29
Re: Migrating to Postgresql and new hardware Strange, John W 22:06
Re: Migrating to Postgresql and new hardware Mark Felder 22:53

Jan. 19, 2011

Thread Author Time
Re: Migrating to Postgresql and new hardware mark 04:09
Re: Migrating to Postgresql and new hardware Craig Ringer 07:26
Re: Migrating to Postgresql and new hardware Scott Marlowe 07:49
Re: Migrating to Postgresql and new hardware Lars 08:17
Re: Migrating to Postgresql and new hardware Lars 08:45
Re: Migrating to Postgresql and new hardware Lars 09:09
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios 09:10
the XID question Charles.Hou 09:19
Re: the XID question Charles.Hou 10:21
Re: the XID question Filip Rembiałkowski 12:00
Re: the XID question Kevin Grittner 14:39
Re: the XID question Charles.Hou 14:54
Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian 17:07
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane 17:26
Re: Running PostgreSQL as fast as possible no matter the consequences Fabrízio de Royes Mello 17:27
Re: the XID question Chris Browne 18:06
Re: the XID question Andres Freund 18:31
Re: the XID question Kevin Grittner 18:41
Re: anti-join chosen even when slower than old plan Bruce Momjian 19:47
Re: anti-join chosen even when slower than old plan Bruce Momjian 20:03
Re: anti-join chosen even when slower than old plan Bruce Momjian 20:04
Re: the XID question Greg Smith 22:46

Jan. 20, 2011

Thread Author Time
Re: Migrating to Postgresql and new hardware Craig Ringer 00:42
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios 07:05
Re: the XID question Charles.Hou 07:26
Re: anti-join chosen even when slower than old plan Cédric Villemain 09:17
Re: anti-join chosen even when slower than old plan Robert Haas 14:19
Re: Migrating to Postgresql and new hardware Andy Colson 14:48
Re: Running PostgreSQL as fast as possible no matter the consequences Robert Haas 15:25
Re: Migrating to Postgresql and new hardware Scott Marlowe 15:43
Re: anti-join chosen even when slower than old plan Cédric Villemain 16:16
Re: anti-join chosen even when slower than old plan Cédric Villemain 16:36
Re: the XID question Kevin Grittner 17:04
copy command and blobs Madhu Ramachandran 20:12
Re: copy command and blobs Mladen Gogala 20:17
Re: copy command and blobs Tom Lane 21:11

Jan. 21, 2011

Thread Author Time
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas 17:09
Re: Best way to get the latest revision from a table Robert Haas 17:13
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala 17:42
Re: the XID question Robert Haas 17:49
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas 17:51
Fun little performance IMPROVEMENT... grant 18:12
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala 18:12
Re: Fun little performance IMPROVEMENT... Andy Colson 18:29
Re: Best way to get the latest revision from a table Nikolas Everett 18:55
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane 19:26
Re: Fun little performance IMPROVEMENT... Tom Lane 19:50
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Kevin Grittner 20:00
Re: Fun little performance IMPROVEMENT... grant 20:18
Re: Fun little performance IMPROVEMENT... Greg Smith 20:19
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane 20:22
Re: Fun little performance IMPROVEMENT... grant 20:23
Re: Fun little performance IMPROVEMENT... Scott Carey 21:10
Re: Fun little performance IMPROVEMENT... grant 21:24
Re: Fun little performance IMPROVEMENT... grant 21:26
Re: copy command and blobs Madhu Ramachandran 22:10

Jan. 23, 2011

Thread Author Time
Re: copy command and blobs Robert Haas 03:41

Jan. 24, 2011

Thread Author Time
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios 15:40
Re: Possible to improve query plan? Robert Haas 16:33
Re: Possible to improve query plan? Kevin Grittner 16:50
Re: Possible to improve query plan? Tom Lane 17:31
Re: Possible to improve query plan? Tom Lane 17:33
Re: Possible to improve query plan? Kevin Grittner 17:38
How to use indexes for GROUP BY Dimi Paun 18:29
Re: How to use indexes for GROUP BY Shaun Thomas 19:27
Re: How to use indexes for GROUP BY Scott Marlowe 19:33
Re: How to use indexes for GROUP BY hubert depesz lubaczewski 20:07
Re: Possible to improve query plan? Jeremy Palmer 21:55
Re: Possible to improve query plan? Kevin Grittner 23:54

Jan. 25, 2011

Thread Author Time
Re: Possible to improve query plan? Kevin Grittner 00:01
Re: Possible to improve query plan? Jeremy Palmer 00:24
Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus 02:26
Re: How to use indexes for GROUP BY Dimi Paun 05:03
Re: Possible to improve query plan? Cédric Villemain 13:44
Re: Fun little performance IMPROVEMENT... Ivan Voras 15:27
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Robert Haas 16:41
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus 18:28
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Mark Kirkwood 21:29
Queries becoming slow under heavy load Anne Rosset 21:37
Re: Queries becoming slow under heavy load Kevin Grittner 22:12
Re: Queries becoming slow under heavy load Andy Colson 22:12
Re: Queries becoming slow under heavy load Ing. Marcos Ortiz Valmaseda 22:27

Jan. 26, 2011

Thread Author Time
Re: Running PostgreSQL as fast as possible no matter the consequences 📎 Bruce Momjian 01:32
Re: Queries becoming slow under heavy load Ivan Voras 13:25
FW: Queries becoming slow under heavy load Anne Rosset 16:04
Re: FW: Queries becoming slow under heavy load Shaun Thomas 17:16
Real vs Int performance David Greco 19:31
Re: Real vs Int performance Kevin Grittner 21:52
Re: Real vs Int performance Tom Lane 22:12

Jan. 27, 2011

Thread Author Time
Re: anti-join chosen even when slower than old plan Bruce Momjian 01:40
Re: Queries becoming slow under heavy load mark 02:34
Re: FW: Queries becoming slow under heavy load Scott Marlowe 04:18
Re: FW: Queries becoming slow under heavy load Scott Marlowe 05:07
High load, Michael Kohl 10:31
Re: High load, Cédric Villemain 11:24
Re: High load, Michael Kohl 11:36
Re: High load, Cédric Villemain 11:58
Why I lost the last pg_xlog file? Waldomiro 12:10
Re: High load, Justin Pitts 12:30
Re: High load, Andres Freund 12:35
Re: High load, Michael Kohl 12:56
Re: High load, Cédric Villemain 13:23
Re: High load, Andres Freund 13:26
Re: Real vs Int performance David Greco 13:48
Re: Why I lost the last pg_xlog file? Shaun Thomas 14:17
Re: Real vs Int performance Tom Lane 14:18
Re: Real vs Int performance Shaun Thomas 14:30
Re: Why I lost the last pg_xlog file? Kevin Grittner 14:51
Re: High load, Andy Colson 15:06
Re: High load, Michael Kohl 15:09
Re: Real vs Int performance Mladen Gogala 15:11
Postgres 9.0 has a bias against indexes Mladen Gogala 15:41
Re: Postgres 9.0 has a bias against indexes Kenneth Marshall 15:45
Re: Postgres 9.0 has a bias against indexes Kevin Grittner 15:49
Re: Postgres 9.0 has a bias against indexes J Sisson 15:51
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 15:56
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 15:57
Re: Postgres 9.0 has a bias against indexes David Wilson 16:09
Re: Real vs Int performance Igor Neyman 16:17
Re: Postgres 9.0 has a bias against indexes Tom Lane 16:40
Re: Running PostgreSQL as fast as possible no matter the consequences Jeff Janes 16:51
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 17:00
Re: High load, Scott Marlowe 17:05
Re: Running PostgreSQL as fast as possible no matter the consequences 📎 Bruce Momjian 17:07
Re: High load, Andy Colson 17:20
Re: High load, Stephen Frost 17:54
Re: High load, Scott Marlowe 18:13
Re: High load, Scott Marlowe 18:14
Re: High load, Andres Freund 18:19
Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1 DM 19:26
Re: Postgres 9.0 has a bias against indexes Igor Neyman 20:10
Re: High load, Ing. Marcos Ortiz Valmaseda 20:21
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 20:31
Re: Postgres 9.0 has a bias against indexes Scott Marlowe 20:37
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 20:44
Re: Postgres 9.0 has a bias against indexes Scott Marlowe 20:59
Re: Postgres 9.0 has a bias against indexes Igor Neyman 21:12
Re: Postgres 9.0 has a bias against indexes Scott Marlowe 21:16
Re: Postgres 9.0 has a bias against indexes Igor Neyman 21:18
Re: Postgres 9.0 has a bias against indexes Kenneth Marshall 21:20
Re: Postgres 9.0 has a bias against indexes Scott Marlowe 21:25
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 21:31
Re: Postgres 9.0 has a bias against indexes Igor Neyman 21:32
Re: Postgres 9.0 has a bias against indexes Scott Marlowe 21:33
Re: Postgres 9.0 has a bias against indexes Mladen Gogala 21:33
Re: Postgres 9.0 has a bias against indexes Kevin Grittner 21:43
How to best use 32 15k.7 300GB drives? Robert Schnabel 23:01
Re: How to best use 32 15k.7 300GB drives? david 23:19

Jan. 28, 2011

Thread Author Time
Re: How to best use 32 15k.7 300GB drives? Alan Hodgson 00:11
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel 00:27
Re: How to best use 32 15k.7 300GB drives? david 00:53
Re: FW: Queries becoming slow under heavy load Anne Rosset 05:12
Re: High load, Michael Kohl 08:46
Re: How to best use 32 15k.7 300GB drives? Stephen Frost 13:14
Re: High load, Mladen Gogala 13:17
Re: How to best use 32 15k.7 300GB drives? Grant Johnson 13:24
Re: High load, Ivan Voras 14:06
Re: FW: Queries becoming slow under heavy load Shaun Thomas 15:31
Re: How to best use 32 15k.7 300GB drives? 📎 Robert Schnabel 16:39
Re: How to best use 32 15k.7 300GB drives? Scott Marlowe 17:00
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel 17:09
Re: How to best use 32 15k.7 300GB drives? Stephen Frost 17:14
Re: How to best use 32 15k.7 300GB drives? Stephen Frost 17:28
postgres 9 query performance yazan suleiman 17:30
Re: How to best use 32 15k.7 300GB drives? Scott Carey 17:44

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 23 24 25 26 27 28 29 30 31