pgsql-performance since 2005-12-25 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

Dec. 25, 2005

Thread Author Time
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 01:51
Re: What's the best hardver for PostgreSQL 8.1? David Lang 03:03
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 03:13
Re: What's the best hardver for PostgreSQL 8.1? William Yu 03:43
Re: What's the best hardver for PostgreSQL 8.1? Joshua D. Drake 04:18
Re: What's the best hardver for PostgreSQL 8.1? David Lang 12:13
Re: What's the best hardver for PostgreSQL 8.1? Steinar H. Gunderson 12:29
Re: What's the best hardver for PostgreSQL 8.1? Bruno Wolff III 15:15
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 17:37

Dec. 26, 2005

Thread Author Time
Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai 09:22
vacuuming template0 gave ERROR Gourish Singbal 11:34
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 12:13
Fwd: vacuuming template0 gave ERROR Gourish Singbal 12:32
Re: vacuuming template0 gave ERROR Tom Lane 16:02
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 17:32
Re: What's the best hardver for PostgreSQL 8.1? David Lang 18:11
Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai 18:21
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 18:50
Performance hit on large row counts 📎 David Scott 21:03
Bitmap indexes etc. Ivan Voras 21:32
Re: Performance hit on large row counts Tom Lane 21:36
Re: Bitmap indexes etc. Tom Lane 21:57
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 22:54
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 23:04
Re: Performance hit on large row counts David Scott 23:07
Re: What's the best hardver for PostgreSQL 8.1? David Lang 23:27
Re: Performance hit on large row counts Tom Lane 23:52

Dec. 27, 2005

Thread Author Time
Re: vacuuming template0 gave ERROR Gourish Singbal 07:05
Re: vacuuming template0 gave ERROR Tom Lane 07:16
Re: vacuuming template0 gave ERROR Gourish Singbal 07:20
Re: What's the best hardver for PostgreSQL 8.1? Dawid Kuroczko 07:24
Re: Bitmap indexes etc. Ivan Voras 13:19
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 13:35
Performance problems with 8.1.1 compared to 7.4.7 Albert Cervera Areny 16:09
Re: What's the best hardver for PostgreSQL 8.1? Ron 16:50
Re: Performance problems with 8.1.1 compared to 7.4.7 Michael Fuhr 17:13
Re: What's the best hardver for PostgreSQL 8.1? Bruce Momjian 17:51
Re: Performance problems with 8.1.1 compared to 7.4.7 Albert Cervera Areny 18:02
Re: Performance problems with 8.1.1 compared to 7.4.7 Frank Wiles 18:56
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 19:05
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 19:18
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 19:24
Re: What's the best hardver for PostgreSQL 8.1? Ron 19:57
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 21:15
Re: What's the best hardver for PostgreSQL 8.1? Ron 22:47

Dec. 29, 2005

Thread Author Time
How import big amounts of data? Arnau 09:48
Re: How import big amounts of data? Steinar H. Gunderson 10:50
Re: How import big amounts of data? Dennis Bjorklund 11:39
Re: How import big amounts of data? Ron 14:20
Re: How import big amounts of data? Teemu Torma 14:41
Re: How import big amounts of data? Arnau 16:19
Re: How import big amounts of data? Teemu Torma 17:05
Process executing COPY opens and reads every table on the system Jeffrey W. Baker 21:21
Invulnerable VACUUM process thrashing everything Jeffrey W. Baker 22:09
Re: Invulnerable VACUUM process thrashing everything Ron 22:42
Re: Invulnerable VACUUM process thrashing everything Russ Garrett 22:53

Dec. 30, 2005

Thread Author Time
Re: Invulnerable VACUUM process thrashing everything Jeffrey W. Baker 02:16
Re: Invulnerable VACUUM process thrashing everything Tom Lane 03:03
unsubscribe Arup Dutta 07:01
Re: CPU and RAM Harry Jackson 08:38

Jan. 2, 2006

Thread Author Time
Stats collector performance improvement 📎 Bruce Momjian 18:40
Re: Stats collector performance improvement Tom Lane 18:45
Re: Stats collector performance improvement Bruce Momjian 19:13
Re: Stats collector performance improvement Tom Lane 20:20
Re: Stats collector performance improvement Qingqing Zhou 21:03
Re: Stats collector performance improvement Hannu Krosing 21:48
Re: Stats collector performance improvement Tom Lane 21:48

Jan. 3, 2006

Thread Author Time
Re: Stats collector performance improvement Jan Wieck 04:06
Re: Stats collector performance improvement Simon Riggs 09:40
Re: Stats collector performance improvement Simon Riggs 09:54
Materialize Subplan and push into inner index conditions Jens-Wolfhard Schicke 15:08
Re: Materialize Subplan and push into inner index conditions Tom Lane 15:43
Re: Stats collector performance improvement Jim C. Nasby 16:35
Re: Stats collector performance improvement 📎 Bruce Momjian 16:43
Re: Stats collector performance improvement Hannu Krosing 21:42
Re: Stats collector performance improvement Greg Stark 23:28
improving write performance for logging application Steve Eckmann 23:44

Jan. 4, 2006

Thread Author Time
Re: improving write performance for logging application Tom Lane 00:00
Re: improving write performance for logging application Steinar H. Gunderson 00:06
Re: improving write performance for logging application dlang 03:23
Avoiding cartesian product Virag Saksena 04:12
Re: improving write performance for logging application Ian Westmacott 13:54
Re: improving write performance for logging application Steve Eckmann 14:00
Re: improving write performance for logging application Steve Eckmann 14:08
Re: improving write performance for logging application Steve Eckmann 14:13
Re: improving write performance for logging application Steve Eckmann 14:16
Re: improving write performance for logging Ron 14:29
Re: improving write performance for logging application Tom Lane 15:39
Re: improving write performance for logging application Kelly Burkhart 15:40
Re: improving write performance for logging Ian Westmacott 16:00
Help in avoiding a query 'Warm-Up' period/shared buffer cache Mark Liberman 22:49

Jan. 5, 2006

Thread Author Time
Re: improving write performance for logging application Steve Eckmann 00:16
Re: improving write performance for logging application Steve Eckmann 00:19
Re: Stats collector performance improvement 📎 Bruce Momjian 00:39
Re: Invulnerable VACUUM process thrashing everything Markus Schaber 11:29
Improving Inner Join Performance Andy 15:16
Re: What's the best hardver for PostgreSQL 8.1? Markus Schaber 16:44
Re: Improving Inner Join Performance Frank Wiles 19:20
Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache Qingqing Zhou 23:12

Jan. 6, 2006

Thread Author Time
Slow query. Any way to speed up? Patrick Hatcher 00:38
Re: improving write performance for logging Jim C. Nasby 01:08
Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache Mark Liberman 02:15
Re: Help in avoiding a query 'Warm-Up' period/shared buffer David Lang 02:50
Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache Qingqing Zhou 03:08
Re: Help in avoiding a query 'Warm-Up' period/shared buffer Jim C. Nasby 03:14
Re: Slow query. Any way to speed up? Tom Lane 05:07
Re: Improving Inner Join Performance Andy 09:21
Re: Improving Inner Join Performance Michael Glaesemann 09:45
Re: Improving Inner Join Performance Andy 09:54
Re: Improving Inner Join Performance Pandurangan R S 09:56
Re: Improving Inner Join Performance Andy 10:21
Re: improving write performance for logging Ian Westmacott 14:00
Re: effizient query with jdbc Sebastian Hennebrueder 14:03
Re: Improving Inner Join Performance Jaime Casanova 15:26
Re: improving write performance for logging Michael Stone 16:03
Re: improving write performance for logging Jim C. Nasby 16:37
Re: Slow query. Any way to speed up? Patrick Hatcher 18:55
Re: improving write performance for logging Ian Westmacott 19:02
Re: Slow query. Any way to speed up? Tom Lane 20:24
Re: improving write performance for logging Tom Lane 20:27
help tuning queries on large database peter royal 22:59
Re: help tuning queries on large database Tom Lane 23:47

Jan. 7, 2006

Thread Author Time
Re: help tuning queries on large database Harry Jackson 01:08
Re: help tuning queries on large database David Lang 01:18

Jan. 8, 2006

Thread Author Time
Re: Stats collector performance improvement Greg Stark 16:49
Hanging Query vimal.gupta 17:34
Re: help tuning queries on large database Luke Lonergan 18:42
Re: help tuning queries on large database Ron 21:35

Jan. 9, 2006

Thread Author Time
Re: Improving Inner Join Performance Andy 07:56
[PERFORMANCE] Beetwen text and varchar field TNO 10:58
Re: [PERFORMANCE] Beetwen text and varchar field Steinar H. Gunderson 11:49
500x speed-down: Wrong query plan? Alessandro Baretta 13:51
Re: help tuning queries on large database Kelly Burkhart 14:37
Re: 500x speed-down: Wrong query plan? Matteo Beccati 15:02
Re: 500x speed-down: Wrong query plan? Jaime Casanova 15:30
Re: help tuning queries on large database Harry Jackson 15:40
Re: Stats collector performance improvement Hannu Krosing 15:48
Re: Avoiding cartesian product Szűcs Gábor 15:59
Re: 500x speed-down: Wrong query plan? Alessandro Baretta 16:23
>= forces row compare and not index elements compare when possible Bernard Dhooghe 17:10
Re: help tuning queries on large database peter royal 17:23
Re: 500x speed-down: Wrong query plan? Tom Lane 18:41
Re: 500x speed-down: Wrong query plan? Alessandro Baretta 18:50
Memory Usage Question Chris Hoover 18:54
Re: 500x speed-down: Wrong query plan? Tom Lane 18:56
Re: help tuning queries on large database Luke Lonergan 19:01
Re: Memory Usage Question Jim C. Nasby 20:35
Re: help tuning queries on large database peter royal 20:59
Re: help tuning queries on large database Luke Lonergan 21:29
Re: [PERFORMANCE] Beetwen text and varchar field Bruce Momjian 23:50

Jan. 10, 2006

Thread Author Time
NOT LIKE much faster than LIKE? Andrea Arcangeli 01:44
Re: NOT LIKE much faster than LIKE? Tom Lane 02:04
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 02:23
Re: NOT LIKE much faster than LIKE? Christopher Kings-Lynne 02:29
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 02:45
Re: NOT LIKE much faster than LIKE? Tom Lane 02:54
Re: NOT LIKE much faster than LIKE? Stephan Szabo 02:54
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 03:47
Index isn't used during a join. Robert Creager 04:23
Re: Index isn't used during a join. Michael Fuhr 05:58
Re: 500x speed-down: Wrong statistics! Alessandro Baretta 07:46
Re: NOT LIKE much faster than LIKE? Matteo Beccati 09:08
Re: help tuning queries on large database Ron 14:33
How to handle a large DB and simultaneous accesses? Charles A. Landemaine 14:41
Re: NOT LIKE much faster than LIKE? Greg Stark 15:11
Re: Index isn't used during a join. Robert Creager 15:17
Re: 500x speed-down: Wrong statistics! Tom Lane 15:22
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 15:27
Re: NOT LIKE much faster than LIKE? Tom Lane 15:46
Re: NOT LIKE much faster than LIKE? Tom Lane 17:49
Re: NOT LIKE much faster than LIKE? Simon Riggs 22:06
Re: NOT LIKE much faster than LIKE? Tom Lane 22:21
Re: NOT LIKE much faster than LIKE? Simon Riggs 23:36

Jan. 11, 2006

Thread Author Time
Re: help tuning queries on large database Mark Lewis 00:28
Left Join Performance vs Inner Join Performance Dave Dutcher 02:06
Re: NOT LIKE much faster than LIKE? Tom Lane 03:40
Re: How to handle a large DB and simultaneous accesses? David Lang 03:50
Re: Left Join Performance vs Inner Join Performance Tom Lane 04:38
Re: Index isn't used during a join. Robert Creager 05:10
Re: help tuning queries on large database Ron 06:03
Re: Index isn't used during a join. Michael Fuhr 07:56
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 07:59
Re: Index isn't used during a join. Michael Fuhr 09:00
Re: NOT LIKE much faster than LIKE? Simon Riggs 09:07
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 09:18
Re: 500x speed-down: Wrong statistics! Alessandro Baretta 09:42
Slow query with joins Bendik Rognlien Johansen 10:59
Re: Index isn't used during a join. Robert Creager 14:26
Re: Index isn't used during a join. Robert Creager 15:02
Postgres8.0 Planner chooses WRONG plan. Pallav Kalva 15:03
Postgres8.0 planner chooses WRONG plan Pallav Kalva 15:27
Re: Index isn't used during a join. Tom Lane 15:33
Re: Slow query with joins Tom Lane 15:45
Re: Postgres8.0 planner chooses WRONG plan Tom Lane 16:07
Re: Postgres8.0 planner chooses WRONG plan Pallav Kalva 16:44
Re: Index isn't used during a join. Michael Fuhr 17:06
Re: Improving Inner Join Performance Jim C. Nasby 18:25
Re: NOT LIKE much faster than LIKE? Jim C. Nasby 18:40
Re: Postgres8.0 planner chooses WRONG plan Jim C. Nasby 19:02
Extremely irregular query performance Jean-Philippe Côté 19:29

Browse Archives

Prev | Next