Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - January 2006

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

2006-01-02

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)

2006-01-03

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)

2006-01-04

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)

2006-01-05

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)

2006-01-06

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)

2006-01-07

Re: help tuning queries on large database Harry Jackson (01:08)
Re: help tuning queries on large database David Lang (01:18)

2006-01-08

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)

2006-01-09

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)

2006-01-10

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)

2006-01-11

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)

2006-01-12

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)

2006-01-13

Re: Please Help: PostgreSQL performance Optimization Jamal Ghaffour (09:13)
Re: Please Help: PostgreSQL performance Optimization Frank Wiles (17:41)
insert without oids Michael Stone (20:10)
Re: insert without oids Michael Fuhr (20:19)
Re: insert without oids Neil Conway (21:29)
Re: insert without oids Michael Stone (22:48)
Re: Slow query with joins Jim C. Nasby (23:34)

2006-01-14

Re: Stable function being evaluated more than once in a single query Jim C. Nasby (00:06)
Re: Throwing unnecessary joins away Jim C. Nasby (00:17)
Re: Throwing unnecessary joins away Jim C. Nasby (00:22)
Re: Stable function being evaluated more than once in a single query Tom Lane (00:27)
Re: [PERFORM] Stable function being evaluated more than once in a single query Jim C. Nasby (00:43)
Re: Extremely irregular query performance Bruce Momjian (04:23)
big databases & hospitals Tomka Gergely (12:13)
Re: big databases & hospitals Javier Carlos (14:51)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group