Home > mailing lists

Mailing lists [pgsql-performance]

3 January 2006

14:08 Materialize Subplan and push into inner index conditions Jens-Wolfhard Schicke
14:43 Re: Materialize Subplan and push into inner index conditions Tom Lane
22:49 improving write performance for logging application Steve Eckmann
23:00 Re: improving write performance for logging application Tom Lane
23:06 Re: improving write performance for logging application Steinar H. Gunderson
23:13 Re: improving write performance for logging application dlang

4 January 2006

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

5 January 2006

10:30 Re: Invulnerable VACUUM process thrashing everything Markus Schaber
14:16 Improving Inner Join Performance Andy
15:44 Re: What's the best hardver for PostgreSQL 8.1? Markus Schaber
18:19 Re: Improving Inner Join Performance Frank Wiles
22:11 Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache Qingqing Zhou
23:53 Slow query. Any way to speed up? Patrick Hatcher

6 January 2006

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

7 January 2006

00:09 Re: help tuning queries on large database Harry Jackson
00:21 Re: help tuning queries on large database David Lang
17:28 Re: improving write performance for logging Michael Stone

8 January 2006

17:42 Re: help tuning queries on large database Luke Lonergan
20:35 Re: help tuning queries on large database Ron

9 January 2006

06:56 Re: Improving Inner Join Performance Andy
09:58 [PERFORMANCE] Beetwen text and varchar field TNO
10:49 Re: [PERFORMANCE] Beetwen text and varchar field Steinar H. Gunderson
12:51 500x speed-down: Wrong query plan? Alessandro Baretta
13:37 Re: help tuning queries on large database Kelly Burkhart
14:08 Re: 500x speed-down: Wrong query plan? Matteo Beccati
14:30 Re: 500x speed-down: Wrong query plan? Jaime Casanova
14:40 Re: help tuning queries on large database Harry Jackson
14:59 Re: Avoiding cartesian product Szűcs Gábor
15:23 Re: 500x speed-down: Wrong query plan? Alessandro Baretta
16:23 Re: help tuning queries on large database peter royal
17:41 Re: 500x speed-down: Wrong query plan? Tom Lane
17:50 Re: 500x speed-down: Wrong query plan? Alessandro Baretta
17:54 Memory Usage Question Chris Hoover
17:56 Re: 500x speed-down: Wrong query plan? Tom Lane
18:02 Re: help tuning queries on large database Luke Lonergan
19:36 Re: [ADMIN] Memory Usage Question Jim C. Nasby
19:59 Re: help tuning queries on large database peter royal
21:01 Re: help tuning queries on large database Luke Lonergan
22:50 Re: [PERFORMANCE] Beetwen text and varchar field Bruce Momjian

10 January 2006

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

11 January 2006

02:06 Left Join Performance vs Inner Join Performance Dave Dutcher
02:40 Re: NOT LIKE much faster than LIKE? Tom Lane
02:53 Re: How to handle a large DB and simultaneous accesses? David Lang
03:38 Re: Left Join Performance vs Inner Join Performance Tom Lane
04:11 Re: Index isn't used during a join. Robert Creager
05:03 Re: help tuning queries on large database Ron
06:57 Re: Index isn't used during a join. Michael Fuhr
07:00 Re: NOT LIKE much faster than LIKE? Andrea Arcangeli
08:00 Re: Index isn't used during a join. Michael Fuhr
08:07 Re: NOT LIKE much faster than LIKE? Simon Riggs
08:18 Re: NOT LIKE much faster than LIKE? Andrea Arcangeli
08:42 Re: 500x speed-down: Wrong statistics! Alessandro Baretta
09:59 Slow query with joins Bendik Rognlien Johansen
12:33 Re: [ADMIN] Assimilation of these "versus" and hardware threads Josh Berkus
13:27 Re: Index isn't used during a join. Robert Creager
14:02 Re: Index isn't used during a join. Robert Creager
14:27 Postgres8.0 planner chooses WRONG plan Pallav Kalva
14:33 Re: Index isn't used during a join. Tom Lane
14:45 Re: Slow query with joins Tom Lane
15:07 Re: Postgres8.0 planner chooses WRONG plan Tom Lane
15:45 Re: Postgres8.0 planner chooses WRONG plan Pallav Kalva
16:06 Re: Index isn't used during a join. Michael Fuhr
17:25 Re: Improving Inner Join Performance Jim C. Nasby
17:40 Re: NOT LIKE much faster than LIKE? Jim C. Nasby
18:02 Re: Postgres8.0 planner chooses WRONG plan Jim C. Nasby
18:55 Re: Slow query with joins Bendik Rognlien Johansen
19:24 Re: Slow query with joins Jim C. Nasby
19:39 Re: NOT LIKE much faster than LIKE? Andrea Arcangeli
19:46 Re: NOT LIKE much faster than LIKE? Andrea Arcangeli
20:02 Re: NOT LIKE much faster than LIKE? Jim C. Nasby
20:13 Re: NOT LIKE much faster than LIKE? Tom Lane
20:31 Re: Slow query with joins Bendik Rognlien Johansen
21:05 Showing Column Statistics Number Dave Dutcher
21:21 Re: Showing Column Statistics Number Michael Fuhr
21:29 Extremely irregular query performance Jean-Philippe Côté
21:38 indexes on primary and foreign keys Burak Seydioglu
22:03 Re: Extremely irregular query performance Tom Lane
22:06 Re: indexes on primary and foreign keys Tom Lane
22:22 Re: indexes on primary and foreign keys Michael Fuhr
22:29 Re: Extremely irregular query performance Scott Marlowe
22:41 Re: Extremely irregular query performance Jean-Philippe Côté
22:51 Re: Extremely irregular query performance Mark Lewis
22:52 Re: indexes on primary and foreign keys Burak Seydioglu
23:32 Please Help: PostgreSQL performance Optimization Jamal Ghaffour
23:41 Stable function being evaluated more than once in a single query Mark Liberman
23:48 Re: NOT LIKE much faster than LIKE? Simon Riggs

12 January 2006

00:00 Re: indexes on primary and foreign keys K C Lau
00:27 Re: indexes on primary and foreign keys Michael Glaesemann
00:41 Re: indexes on primary and foreign keys Michael Fuhr
02:23 Re: Extremely irregular query performance Tom Lane
02:49 Re: indexes on primary and foreign keys K C Lau
03:21 Re: Index isn't used during a join. Robert Creager
03:33 Re: Stable function being evaluated more than once in a single query Tom Lane
03:48 Re: indexes on primary and foreign keys Tom Lane
08:49 Re: Extremely irregular query performance Simon Riggs
11:19 Throwing unnecessary joins away Ottó Havasvölgyi
11:34 Re: Throwing unnecessary joins away Alessandro Baretta
12:41 Re: Throwing unnecessary joins away Ottó Havasvölgyi
13:48 query slower on 8.1 than 7.3 Robert Treat
13:50 Re: Please Help: PostgreSQL performance Optimization Jamal Ghaffour
14:53 Re: Throwing unnecessary joins away Tom Lane
15:25 Re: Throwing unnecessary joins away Szűcs Gábor
16:00 Re: Throwing unnecessary joins away Ottó Havasvölgyi
16:03 Re: Throwing unnecessary joins away Scott Marlowe
17:34 Re: Please Help: PostgreSQL performance Optimization Andrew Lazarus
17:51 Re: Throwing unnecessary joins away Ottó Havasvölgyi
19:14 Re: Extremely irregular query performance Jean-Philippe Cote
19:16 Re: Please Help: PostgreSQL performance Optimization Jaime Casanova

13 January 2006

08:10 Re: Please Help: PostgreSQL performance Optimization Jamal Ghaffour
16:41 Re: Please Help: PostgreSQL performance Optimization Frank Wiles
19:10 insert without oids Michael Stone
19:20 Re: insert without oids Michael Fuhr
20:28 Re: insert without oids Neil Conway
21:48 Re: insert without oids Michael Stone
22:34 Re: Slow query with joins Jim C. Nasby
23:06 Re: Stable function being evaluated more than once in a single query Jim C. Nasby
23:18 Re: Throwing unnecessary joins away Jim C. Nasby
23:22 Re: Throwing unnecessary joins away Jim C. Nasby
23:27 Re: Stable function being evaluated more than once in a single query Tom Lane
23:43 Re: Stable function being evaluated more than once in a single query Jim C. Nasby

14 January 2006

03:23 Re: Extremely irregular query performance Bruce Momjian
04:50 Hanging Query vimal.gupta@gmail.com
04:50 >= forces row compare and not index elements compare when possible Bernard Dhooghe
04:50 Extremely irregular query performance Jean-Philippe Côté
04:50 Postgres8.0 Planner chooses WRONG plan. Pallav Kalva
04:50 Re: Extremely irregular query performance Kenneth Marshall
04:50 Re: Extremely irregular query performance Kenneth Marshall
11:13 big databases & hospitals Tomka Gergely
13:54 Re: big databases & hospitals Javier Carlos
16:55 Re: big databases & hospitals Tomka Gergely
17:05 Re: Hanging Query Tom Lane
17:10 Re: >= forces row compare and not index elements compare when possible Tom Lane
17:13 Ensuring data integrity with fsync=off Benjamin Arai
17:38 Re: big databases & hospitals Chris Mair
17:41 Re: Ensuring data integrity with fsync=off Tom Lane
19:31 Re: big databases & hospitals Jaime Casanova

15 January 2006

01:37 Re: SAN/NAS options Charles Sprickman
02:23 Re: SAN/NAS options Charles Sprickman
02:34 Re: SAN/NAS options Luke Lonergan
03:05 Re: SAN/NAS options Christopher Browne
16:21 Re: SAN/NAS options Luke Lonergan

16 January 2006

09:12 Suspending SELECTs Alessandro Baretta
13:36 Materialized Views Michael Riess
14:40 Re: Materialized Views Frank Wiles
15:18 Re: Materialized Views
15:27 Re: Materialized Views Michael Riess
15:54 Use of * affect the performance Marcos
16:51 Re: Suspending SELECTs Tom Lane
16:55 Re: Suspending SELECTs Alvaro Herrera
17:10 Re: Suspending SELECTs Tom Lane
17:45 Re: Suspending SELECTs Mark Lewis
20:23 Re: Suspending SELECTs Craig A. James
20:54 Re: Use of * affect the performance Qingqing Zhou
21:07 new to postgres (and db management) and performance already a problem :-( Antoine
21:42 Re: new to postgres (and db management) and performance already a problem :-( Andrew Sullivan
21:43 Re: new to postgres (and db management) and performance already a problem :-( Tom Lane
21:48 Re: new to postgres (and db management) and performance already a problem :-(

17 January 2006

00:09 Re: new to postgres (and db management) and performance already a problem :-( Tom Lane
00:29 Re: new to postgres (and db management) and performance already a problem :-(
03:02 Re: new to postgres (and db management) and performance already a problem :-( Christopher Browne
03:13 Re: new to postgres (and db management) and performance already a problem :-(
07:14 Re: new to postgres (and db management) and performance already a problem :-( Antoine
09:19 Autovacuum / full vacuum Michael Riess
09:29 Re: Autovacuum / full vacuum Christopher Kings-Lynne
09:33 Re: Autovacuum / full vacuum Michael Riess
10:09 Use of Stored Procedures and Marcos
10:35 Re: Autovacuum / full vacuum Pandurangan R S
11:08 Re: Autovacuum / full vacuum Michael Stone
12:17 Re: Autovacuum / full vacuum Alvaro Herrera
12:29 Re: new to postgres (and db management) and performance already a problem :-( Andrew Sullivan
12:33 Re: new to postgres (and db management) and performance Markus Schaber
12:53 Re: new to postgres (and db management) and performance Markus Schaber
13:02 Re: Autovacuum / full vacuum Christopher Browne
13:05 Re: Autovacuum / full vacuum Michael Riess
13:11 Re: Autovacuum / full vacuum Matthew T. O'Connor
13:30 Re: Autovacuum / full vacuum Markus Schaber
13:33 Re: Autovacuum / full vacuum Michael Riess
13:37 Re: Autovacuum / full vacuum Larry Rosenman
13:37 Re: Autovacuum / full vacuum Christopher Browne
13:50 Re: Autovacuum / full vacuum Michael Riess
13:56 Re: Autovacuum / full vacuum Andrew Sullivan
14:04 Re: Autovacuum / full vacuum Michael Riess
14:07 Re: Autovacuum / full vacuum Michael Stone
14:08 Re: Autovacuum / full vacuum Andrew Sullivan
14:09 Re: Autovacuum / full vacuum Andrew Sullivan
14:10 Re: Autovacuum / full vacuum hubert depesz lubaczewski
14:13 Re: Autovacuum / full vacuum Tom Lane
14:13 Re: Autovacuum / full vacuum Andrew Sullivan
14:19 Re: Autovacuum / full vacuum Andrew Sullivan
14:36 Re: Autovacuum / full vacuum Tom Lane
14:59 Re: Autovacuum / full vacuum Scott Marlowe
16:04 Re: Autovacuum / full vacuum Chris Browne
16:07 sum of left join greater than its parts Robert Treat
16:17 Re: Autovacuum / full vacuum Andrew Sullivan
16:25 Re: Autovacuum / full vacuum Markus Schaber
16:28 Re: Autovacuum / full vacuum Alvaro Herrera
16:31 Re: Autovacuum / full vacuum Scott Marlowe
17:13 Re: Autovacuum / full vacuum Andrew Sullivan
18:04 Re: Autovacuum / full vacuum Chris Browne
18:32 Re: Autovacuum / full vacuum Tom Lane
18:55 Re: Suspending SELECTs Alessandro Baretta
19:04 Re: Suspending SELECTs Michael Stone
19:06 Re: Suspending SELECTs Alessandro Baretta
19:14 wildcard search performance with "like" Yantao Shi
19:19 Re: Suspending SELECTs Tom Lane
19:36 Re: big databases & hospitals Jim C. Nasby
19:40 Re: Ensuring data integrity with fsync=off Jim C. Nasby
19:58 Re: Suspending SELECTs Jim C. Nasby
20:01 Re: wildcard search performance with "like" Tom Lane
20:04 Re: sum of left join greater than its parts Josh Berkus
20:13 Re: Suspending SELECTs mark@mark.mielke.cc
20:40 Re: Suspending SELECTs Mark Lewis
21:03 Multiple Order By Criteria J@Planeti.Biz
21:19 Re: Multiple Order By Criteria Josh Berkus
21:29 Re: Multiple Order By Criteria J@Planeti.Biz
21:40 Re: Multiple Order By Criteria Stephan Szabo
21:49 Re: Autovacuum / full vacuum Jim C. Nasby
21:50 Re: Suspending SELECTs Frank Wiles
21:53 Re: Suspending SELECTs Josh Berkus
21:57 Re: Multiple Order By Criteria Fredrick O Jackson
22:03 Re: Multiple Order By Criteria J@Planeti.Biz
22:12 Re: Suspending SELECTs Josh Berkus
22:39 Re: Multiple Order By Criteria Stephan Szabo
23:23 Re: Multiple Order By Criteria J@Planeti.Biz
23:28 Re: Suspending SELECTs Mark Kirkwood

18 January 2006

02:29 Getting pg to use index on an inherited table (8.1.1) Hari Warrier
02:48 Re: Suspending SELECTs Craig A. James
03:02 Re: Suspending SELECTs Tom Lane
03:07 Re: Getting pg to use index on an inherited table (8.1.1) Tom Lane
04:51 Re: Multiple Order By Criteria Ahmad Fajar
04:52 Re: Suspending SELECTs Mark Kirkwood
07:57 Re: Suspending SELECTs Alessandro Baretta
08:08 Re: Suspending SELECTs Tino Wildenhain
08:14 Re: Suspending SELECTs Alessandro Baretta
10:15 Simple Question of Performance ILIKE or Lower Marcos
13:06 Re: Multiple Order By Criteria J@Planeti.Biz
13:09 Re: Autovacuum / full vacuum Michael Riess
13:31 Re: Suspending SELECTs mark@mark.mielke.cc
14:06 Re: wildcard search performance with "like" Michael Riess
14:10 Re: Multiple Order By Criteria Stephan Szabo
14:11 Re: Suspending SELECTs Alessandro Baretta
14:41 Re: Suspending SELECTs Harry Jackson
14:50 Re: Autovacuum / full vacuum Mindaugas
15:51 Re: Suspending SELECTs mark@mark.mielke.cc
15:53 Re: Autovacuum / full vacuum Alvaro Herrera
16:04 Re: Autovacuum / full vacuum Chris Browne
17:10 3WARE Card performance boost? Benjamin Arai
17:21 Re: 3WARE Card performance boost? Joshua D. Drake
17:26 Re: 3WARE Card performance boost? Benjamin Arai
17:54 Re: SAN/NAS options Michael Adler
18:12 Re: 3WARE Card performance boost? Alex Turner
18:15 Re: Autovacuum / full vacuum (off-topic?) Michael Crozier
18:17 Re: 3WARE Card performance boost? Alex Turner
18:23 Re: 3WARE Card performance boost? Joost Kraaijeveld
18:37 Re: Multiple Order By Criteria J@Planeti.Biz
19:28 Re: Use of Stored Procedures and Michael Fuhr
20:58 Re: 3WARE Card performance boost? William Yu
21:02 Re: 3WARE Card performance boost? Steinar H. Gunderson
21:15 Re: 3WARE Card performance boost? William Yu
21:48 Re: Autovacuum / full vacuum Jim C. Nasby
21:52 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby
22:02 Re: Simple Question of Performance ILIKE or Lower Jim C. Nasby
22:04 Re: Autovacuum / full vacuum (off-topic?) Chris Browne
22:05 Re: 3WARE Card performance boost? Jim C. Nasby
22:36 Re: Autovacuum / full vacuum (off-topic?) Michael Crozier
22:41 Re: Autovacuum / full vacuum (off-topic?) Michael Crozier
22:44 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby

19 January 2006

09:49 Re: Use of Stored Procedures and Marcos
10:15 Re: Use of Stored Procedures and Markus Schaber
10:48 Re: Use of Stored Procedures and Marcos
11:20 Re: Use of Stored Procedures and Markus Schaber
16:38 Stored Procedures Benjamin Arai
19:04 Re: Stored Procedures Andreas Kretschmer
20:38 Re: 3WARE Card performance boost? Vivek Khera
21:20 query plans different for 8.1 on windows and aix Tim Jones
21:27 Re: query plans different for 8.1 on windows and aix Tom Lane
21:52 Re: Stable function being evaluated more than once in a single Bruce Momjian
21:54 Re: 3WARE Card performance boost? Alex Turner
22:10 Re: Autovacuum / full vacuum (off-topic?) Mark Kirkwood
22:14 Re: Autovacuum / full vacuum (off-topic?) Bruce Momjian

20 January 2006

03:39 SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX K C Lau
08:14 Retaining execution plans between connections? James Russell
08:35 Re: Retaining execution plans between connections? Pandurangan R S
14:14 Re: Retaining execution plans between connections? Neil Conway
15:19 Re: Extremely irregular query performance Bruce Momjian
15:35 Re: Extremely irregular query performance Tom Lane
15:42 Re: Extremely irregular query performance Bruce Momjian
16:12 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby
16:20 Re: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX Jim C. Nasby
16:29 Re: Autovacuum / full vacuum (off-topic?) Joshua D. Drake
16:34 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby
16:35 Re: Autovacuum / full vacuum (off-topic?) Joshua D. Drake
16:44 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby
16:47 Re: Autovacuum / full vacuum (off-topic?)
17:32 query stopped working after tables > 50000 records Antoine
17:51 Re: [PERFORMANCE] Stored Procedures Rikard Pavelic
17:51 Re: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX Tom Lane
17:56 Re: Stored procedures Rikard Pavelic
18:02 Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby
18:04 Re: query stopped working after tables > 50000 records Jim C. Nasby
18:10 Re: [PERFORMANCE] Stored Procedures Jim C. Nasby
18:14 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
18:39 Re: [PERFORMANCE] Stored Procedures Rikard Pavelic
19:10 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
19:21 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
19:51 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
20:19 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
20:35 Re: [PERFORMANCE] Stored Procedures Jim C. Nasby
20:38 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
20:44 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
20:50 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
20:57 Sudden slowdown of Pg server Jerry Sievers
21:14 Re: Sudden slowdown of Pg server Jignesh K. Shah
21:16 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
21:29 Re: [GENERAL] Creation of tsearch2 index is very slow Ron
21:33 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
21:46 Re: [GENERAL] Creation of tsearch2 index is very slow Ron
21:49 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
21:50 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
21:57 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
21:59 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
22:18 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
22:28 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
22:52 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
23:05 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson
23:23 Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane
23:36 Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson

21 January 2006

00:34 Re: [GENERAL] Creation of tsearch2 index is very slow Craig A. James
07:00 Re: [PERFORMANCE] Stored Procedures Rikard Pavelic
11:22 Re: [GENERAL] Creation of tsearch2 index is very Ron
12:08 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
12:27 Re: SELECT MIN, MAX took longer time than SELECT K C Lau
12:29 Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov
12:34 Re: [GENERAL] Creation of tsearch2 index is very Oleg Bartunov
12:39 Re: SELECT MIN, MAX took longer time than SELECT K C Lau
15:25 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
15:33 Re: [GENERAL] Creation of tsearch2 index is very Oleg Bartunov
15:39 Re: [GENERAL] Creation of tsearch2 index is very Ron
16:29 Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov
16:29 Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov
17:27 Re: [GENERAL] Creation of tsearch2 index is very Tom Lane
19:36 Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout
19:48 Re: [GENERAL] Creation of tsearch2 index is very David Lang
19:55 Slow queries consisting inner selects and order bys & hack to speed up Ümit Öztosun
19:56 Re: [GENERAL] Creation of tsearch2 index is very Tom Lane
20:06 Re: [PERFORMANCE] Stored Procedures Rikard Pavelic
22:49 libpq vs. unixODBC performance Constantine Filin
23:40 Re: libpq vs. unixODBC performance Tom Lane

22 January 2006

06:53 tsearch2 headline and postgresql.conf pgsql-performance@nullmx.com
07:25 Re: tsearch2 headline and postgresql.conf Oleg Bartunov
15:04 Re: Suspending SELECTs August Zajonc
19:29 Re: tsearch2 headline and postgresql.conf pgsql-performance@nullmx.com

23 January 2006

08:46 ENC: RES: pg_dump slow - Solution Franklin Haut
09:19 Re: [PERFORMANCE] Stored Procedures Marcos
09:31 Re: Suspending SELECTs Alessandro Baretta
11:30 Re: [PERFORMANCE] Stored Procedures Markus Schaber
14:32 Re: [PERFORMANCE] Stored Procedures Marcos
15:23 Re: [PERFORMANCE] Stored Procedures Dave Dutcher
16:24 Re: [PERFORMANCE] Stored Procedures Frank Wiles
18:19 Re: Slow queries consisting inner selects and order bys & hack to speed up Tom Lane
21:06 unsubscribe Adnan HOTMAIL

24 January 2006

15:35 Investigating IO Saturation Brad Nicholson
15:41 Re: Investigating IO Saturation Joshua D. Drake
16:04 Re: Investigating IO Saturation Brad Nicholson
16:07 Re: Investigating IO Saturation Tom Lane
16:08 Re: Investigating IO Saturation Joshua D. Drake
19:04 Re: Investigating IO Saturation Chris Browne
20:00 Re: Investigating IO Saturation Andrew Sullivan
22:19 Inconsistant query plan Daniel Gish
22:30 Re: Inconsistant query plan Scott Marlowe
22:59 Re: Inconsistant query plan Michael Fuhr

25 January 2006

00:02 Re: Inconsistant query plan Daniel Gish
08:05 Re: Inconsistant query plan Alessandro Baretta
11:01 DB responce during DB dump Evgeny Gridasov
11:44 Re: DB responce during DB dump Richard Huxton
15:24 Re: DB responce during DB dump Tom Lane
15:43 Re: DB responce during DB dump Evgeny Gridasov
15:47 Re: DB responce during DB dump Evgeny Gridasov

26 January 2006

00:46 PostgreSQL Solaris packages now in beta Robert Lor
09:06 Physical column size Paul Mackay
09:22 Re: Physical column size Mario Weilguni
13:56 Re: PostgreSQL Solaris packages now in beta Jignesh K. Shah
14:43 Query optimization with X Y JOIN J@Planeti.Biz
14:50 Incorrect Total runtime Reported by Explain Analyze!? Jozsef Szalay
15:17 Re: Query optimization with X Y JOIN Craig A. James
15:25 Re: Query optimization with X Y JOIN J@Planeti.Biz
15:33 Re: Query optimization with X Y JOIN Joshua D. Drake
15:35 Re: Incorrect Total runtime Reported by Explain Analyze!? Scott Marlowe
15:47 Re: Query optimization with X Y JOIN Richard Huxton
15:50 Re: Incorrect Total runtime Reported by Explain Analyze!? Richard Huxton
16:13 Re: Query optimization with X Y JOIN J@Planeti.Biz
16:35 Re: Incorrect Total runtime Reported by Explain Analyze!? Jozsef Szalay
16:57 Re: Incorrect Total runtime Reported by Explain Analyze!? Michael Fuhr
16:59 Re: Incorrect Total runtime Reported by Explain Analyze!? Scott Marlowe
17:03 Re: Incorrect Total runtime Reported by Explain Analyze!? Jozsef Szalay
23:18 Re: [GENERAL] Creation of tsearch2 index is very Ron
23:58 Re: [GENERAL] Creation of tsearch2 index is very Alvaro Herrera

27 January 2006

00:55 Re: [GENERAL] Creation of tsearch2 index is very Ron
01:33 Re: [GENERAL] Creation of tsearch2 index is very Craig A. James
02:33 Re: [GENERAL] Creation of tsearch2 index is very Ron
06:52 Re: [GENERAL] Creation of tsearch2 index is very Ron

28 January 2006

00:27 Huge Data sets, simple queries Mike Biamonte
05:56 Re: Huge Data sets, simple queries Jeffrey W. Baker
14:55 Re: Huge Data sets, simple queries Tom Lane
16:08 Re: Huge Data sets, simple queries Jeffrey W. Baker
16:37 Re: Huge Data sets, simple queries Tom Lane
16:54 Re: Huge Data sets, simple queries Luke Lonergan
17:55 Re: Huge Data sets, simple queries Tom Lane

29 January 2006

10:25 Re: Huge Data sets, simple queries hubert depesz lubaczewski
14:43 Re: Huge Data sets, simple queries Michael Stone
17:46 Re: Huge Data sets, simple queries Luke Lonergan
20:04 Re: Huge Data sets, simple queries Jeffrey W. Baker
23:32 Re: Huge Data sets, simple queries Michael Adler

30 January 2006

02:24 Re: Huge Data sets, simple queries Craig A. James
02:29 Where is my bottleneck? Arnau Rebassa Villalonga
02:29 Desperate: View not using indexes (very slow) Jen Sale
02:50 Re: Desperate: View not using indexes (very slow) Tom Lane
04:35 Re: Huge Data sets, simple queries Charles Sprickman
06:25 Re: Huge Data sets, simple queries Luke Lonergan
10:00 Re: Where is my bottleneck? Michael Stone
15:58 Re: Where is my bottleneck? Luke Lonergan
16:53 Re: Huge Data sets, simple queries hubert depesz lubaczewski
18:49 Re: Huge Data sets, simple queries Luke Lonergan
19:10 Re: Where is my bottleneck? Jim C. Nasby
19:25 Re: Huge Data sets, simple queries Jim C. Nasby
21:57 Query planner issue Emmanuel Lacour
22:26 Re: Query planner issue Mark Lewis
22:37 Re: Query planner issue Jim Buttafuoco
23:27 Re: Query planner issue Emmanuel Lacour
23:36 Re: Where is my bottleneck? Richard Huxton

31 January 2006

00:55 Re: Query planner issue Tom Lane
15:24 Delete me 2386429@studenti.unige.it
16:01 Re: Huge Data sets, simple queries Luke Lonergan
16:39 Re: Huge Data sets, simple queries Kevin
17:33 Re: Delete me Richard Huxton
18:21 Re: Huge Data sets, simple queries Jim C. Nasby
18:23 Re: Delete me Jim C. Nasby
19:04 Re: Huge Data sets, simple queries Jeffrey W. Baker
19:47 Re: Huge Data sets, simple queries Luke Lonergan
21:53 Re: Huge Data sets, simple queries Luke Lonergan
22:10 Re: Huge Data sets, simple queries PFC
22:12 Re: Huge Data sets, simple queries Jim C. Nasby
22:13 Re: Huge Data sets, simple queries Luke Lonergan
22:20 Re: Huge Data sets, simple queries Luke Lonergan
22:51 partitioning and locking problems Marc Morin
23:32 Storing Digital Video Rodrigo Madera
23:57 Re: Storing Digital Video Matt Davies | Postgresql List