pgsql-performance since 2005-12-29 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. 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
Re: Slow query with joins Bendik Rognlien Johansen 19:55
Re: Slow query with joins Jim C. Nasby 20:23
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 20:39
Re: NOT LIKE much faster than LIKE? Andrea Arcangeli 20:46
Re: NOT LIKE much faster than LIKE? Jim C. Nasby 21:02
Re: NOT LIKE much faster than LIKE? Tom Lane 21:13
Re: Slow query with joins Bendik Rognlien Johansen 21:30
Showing Column Statistics Number Dave Dutcher 22:05
Re: Showing Column Statistics Number Michael Fuhr 22:21
Extremely irregular query performance Jean-Philippe Côté 22:37
indexes on primary and foreign keys Burak Seydioglu 22:38
Re: Extremely irregular query performance Tom Lane 23:03
Re: indexes on primary and foreign keys Tom Lane 23:06
Re: indexes on primary and foreign keys Michael Fuhr 23:21
Re: Extremely irregular query performance Scott Marlowe 23:29
Re: Extremely irregular query performance Jean-Philippe Côté 23:50
Re: Extremely irregular query performance Mark Lewis 23:50
Re: indexes on primary and foreign keys Burak Seydioglu 23:52

Jan. 12, 2006

Thread Author Time
Please Help: PostgreSQL performance Optimization 📎 Jamal Ghaffour 00:32
Re: indexes on primary and foreign keys K C Lau 00:36
Stable function being evaluated more than once in a single query Mark Liberman 00:41
Re: NOT LIKE much faster than LIKE? Simon Riggs 00:48
Re: indexes on primary and foreign keys Michael Glaesemann 01:26
Re: indexes on primary and foreign keys Michael Fuhr 01:40
Re: Extremely irregular query performance Tom Lane 03:23
Re: indexes on primary and foreign keys K C Lau 03:49
Re: Index isn't used during a join. Robert Creager 04:20
Re: Stable function being evaluated more than once in a single query Tom Lane 04:33
Re: indexes on primary and foreign keys Tom Lane 04:45
Re: Extremely irregular query performance Simon Riggs 09:48
Throwing unnecessary joins away Ottó Havasvölgyi 12:18
Re: Throwing unnecessary joins away Alessandro Baretta 12:35
Re: Throwing unnecessary joins away Ottó Havasvölgyi 13:41
query slower on 8.1 than 7.3 Robert Treat 14:48
Re: Please Help: PostgreSQL performance Optimization 📎 Jamal Ghaffour 14:53
Re: Throwing unnecessary joins away Tom Lane 15:53
Re: Throwing unnecessary joins away Szűcs Gábor 16:25
Re: Throwing unnecessary joins away Ottó Havasvölgyi 17:00
Re: Throwing unnecessary joins away Scott Marlowe 17:03
Re: Please Help: PostgreSQL performance Optimization 📎 Andrew Lazarus 18:42
Re: Throwing unnecessary joins away Ottó Havasvölgyi 18:51
Re: Extremely irregular query performance Kenneth Marshall 19:16
Re: Please Help: PostgreSQL performance Optimization Jaime Casanova 20:16
Re: Extremely irregular query performance Jean-Philippe Cote 20:23
Re: Extremely irregular query performance Kenneth Marshall 21:05

Browse Archives

Prev | Next