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 - April 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

2006-04-01

Re: Query using SeqScan instead of IndexScan Brendan Duddridge (01:09)
Re: Query using SeqScan instead of IndexScan chris smith (01:23)
Re: Query using SeqScan instead of IndexScan Brendan Duddridge (01:31)
Re: [Solved] Slow performance on Windows .NET and OleDb Antoine (09:54)
Re: Query using SeqScan instead of IndexScan Jim C. Nasby (15:32)
Re: Query using SeqScan instead of IndexScan Brendan Duddridge (17:51)
Re: [Solved] Slow performance on Windows .NET and OleDb Merlin Moncure (19:23)

2006-04-02

Re: Query using SeqScan instead of IndexScan chris smith (00:50)
Re: Query using SeqScan instead of IndexScan chris smith (01:32)
Re: Query using SeqScan instead of IndexScan Alvaro Herrera (04:26)
Re: Query using SeqScan instead of IndexScan Mark Kirkwood (04:31)
Re: Query using SeqScan instead of IndexScan Tom Lane (04:46)
Trigger vs Rule Ключников А.С. (08:31)
Re: statistics buffer is full Qingqing Zhou (14:33)
Re: Large Binary Objects Middleware Qingqing Zhou (14:36)
Re: Logging SQL queries to optimize them ? Qingqing Zhou (14:45)
Re: index not used again Jan Kesten (16:20)
Re: index not used again Stephan Szabo (19:46)
Re: Trigger vs Rule Niklas Johansson (21:08)
Re: Query using SeqScan instead of IndexScan Josh Berkus (22:30)

2006-04-03

Re: Query using SeqScan instead of IndexScan Brendan Duddridge (04:20)
Re: Trigger vs Rule Niklas Johansson (09:04)
Re: Trigger vs Rule Ключников А.С. (09:17)
Measuring the execution time of functions within functions... Mario Splivalo (09:42)
Re: Measuring the execution time of functions within functions... Alvaro Herrera (12:50)
Re: Measuring the execution time of functions within functions... Jerry Sievers (16:32)
optimizing db for small table with tons of updates Kenji Morishige (18:24)
Re: optimizing db for small table with tons of updates Josh Berkus (18:29)
Re: optimizing db for small table with tons of updates Rajesh Kumar Mallah (18:36)
Re: optimizing db for small table with tons of updates Tom Lane (18:39)
Re: optimizing db for small table with tons of updates Kenji Morishige (19:02)
Re: optimizing db for small table with tons of updates Alvaro Herrera (19:03)
Re: optimizing db for small table with tons of updates Kenji Morishige (19:08)
Re: optimizing db for small table with tons of updates Tom Lane (19:23)
Re: optimizing db for small table with tons of updates Kenji Morishige (19:28)
The order of fields around the "=" in the WHERE conditions Mike Quinn (21:24)
Re: The order of fields around the "=" in the WHERE conditions Tom Lane (21:35)
Re: The order of fields around the "=" in the WHERE conditions Tom Lane (21:58)

2006-04-04

bad performance on Solaris 10 Chris Mair (00:39)
Re: bad performance on Solaris 10 Josh Berkus (00:49)
freebsd/softupdates for data dir Miguel (00:58)
Re: freebsd/softupdates for data dir Mark Kirkwood (02:10)
Re: bad performance on Solaris 10 Luke Lonergan (03:46)
Re: bad performance on Solaris 10 Mark Kirkwood (05:12)
Re: bad performance on Solaris 10 Josh Berkus (06:09)
pgmemcache C Storm (07:24)
Re: freebsd/softupdates for data dir Vivek Khera (14:41)
vacuum full seems to hang on very small table Dan Harris (14:59)
Re: vacuum full seems to hang on very small table Brad Nicholson (15:07)
Re: vacuum full seems to hang on very small table Simon Riggs (15:35)
Re: The order of fields around the "=" in the WHERE Mike Quinn (17:18)
Query runs too long for indexed tables Andrus (19:37)
Re: Query runs too long for indexed tables Scott Marlowe (19:48)
Re: Query runs too long for indexed tables Marc Morin (20:00)
Re: Query runs too long for indexed tables Marc Morin (20:03)
Re: Query using SeqScan instead of IndexScan Jim Nasby (20:26)
Re: Query using SeqScan instead of IndexScan Jim Nasby (20:28)
Re: The order of fields around the "=" in the WHERE Mike Quinn (22:07)

2006-04-05

Re: Query runs too long for indexed tables Andrus (09:39)
Re: Query runs too long for indexed tables PFC (10:22)
Re: Query runs too long for indexed tables Andrus (10:40)
Re: Query runs too long for indexed tables PFC (11:25)
Re: Query runs too long for indexed tables Tom Lane (14:09)
Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (18:12)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Tom Lane (19:04)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (20:43)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (20:54)
Re: bad performance on Solaris 10 Chris Mair (21:31)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (21:37)
Re: bad performance on Solaris 10 Luke Lonergan (21:40)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (21:45)
Re: bad performance on Solaris 10 Alvaro Herrera (21:48)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (21:54)
Re: bad performance on Solaris 10 Luke Lonergan (21:56)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 August Zajonc (21:58)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Josh Berkus (22:01)
Re: freebsd/softupdates for data dir Jim Nasby (22:07)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Scott Marlowe (22:08)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Chris Browne (22:11)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Chris Browne (22:12)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Tom Lane (22:24)
Re: bad performance on Solaris 10 Chris Mair (23:13)
Re: bad performance on Solaris 10 Mark Kirkwood (23:25)
Re: bad performance on Solaris 10 Chris Mair (23:29)
Re: bad performance on Solaris 10 Chris Mair (23:33)

2006-04-06

Re: Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (00:33)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (00:49)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Marcelo Tada (01:11)
Re: bad performance on Solaris 10 Mark Kirkwood (01:23)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (02:14)
Query planner is using wrong index. Brian Herlihy (02:35)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Anthony Ransley (03:35)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Robert Lor (03:41)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Robert Lor (04:15)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Leigh Dyer (04:23)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (04:27)
Re: bad performance on Solaris 10 Josh Berkus (04:32)
Re: bad performance on Solaris 10 Josh Berkus (04:35)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Leigh Dyer (04:47)
Re: bad performance on Solaris 10 Chris Mair (06:01)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Mark Kirkwood (06:44)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Josh Berkus (06:56)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Miguel (07:32)
Re: bad performance on Solaris 10 Robert Lor (07:36)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Leigh Dyer (07:42)
Re: Query planner is using wrong index. Ragnar (08:52)
Maintenance_work_mem influence on queries luchot (08:57)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Markus Schaber (09:08)
Re: Query planner is using wrong index. Brian Herlihy (09:27)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Juan Casero (FL FLC) (11:32)
Re: Query planner is using wrong index. Ragnar (11:49)
Re: Intel C/C++ Compiler Tests (fwd) Bruce Momjian (13:30)
Re: freebsd/softupdates for data dir Vivek Khera (13:45)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Matthew Nuzum (14:01)
Re: Query planner is using wrong index. Brian Herlihy (14:01)
CURSOR OR OFFSET/LIMIT Kaloyan Iliev (14:48)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Vivek Khera (15:20)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Vivek Khera (15:36)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Vivek Khera (15:39)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Luke Lonergan (16:17)
Re: Query planner is using wrong index. Ragnar (16:20)
Re: CURSOR OR OFFSET/LIMIT John DeSoi (17:11)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Jignesh K. Shah (21:55)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Jignesh K. Shah (22:13)
Re: Query planner is using wrong index. Brian Herlihy (23:56)

2006-04-07

Re: Query planner is using wrong index. Dave Dutcher (00:09)
Re: Query planner is using wrong index. Brian Herlihy (00:15)
Re: Query planner is using wrong index. Tom Lane (03:17)
Re: Query planner is using wrong index. Brian Herlihy (06:41)
Same SQL, 104296ms of difference between 7.4.12 and 8.0.7 Rafael Martinez Guerrero (12:45)
Re: Same SQL, 104296ms of difference between 7.4.12 and Richard Huxton (13:31)
Re: Same SQL, 104296ms of difference between 7.4.12 and Rafael Martinez Guerrero (14:00)
Re: Query planner is using wrong index. Tom Lane (14:34)
Loading the entire DB into RAM Charles A. Landemaine (14:37)
Re: Same SQL, 104296ms of difference between 7.4.12 and Richard Huxton (14:40)
Re: Same SQL, 104296ms of difference between 7.4.12 and Rafael Martinez (14:53)
Re: Loading the entire DB into RAM Matt Davies | Postgresql List (14:54)
Re: Loading the entire DB into RAM Charles A. Landemaine (15:00)
Spotting planner errors (was Re: Query planner is using wrong index.) Richard Huxton (15:08)
Re: Spotting planner errors (was Re: Query planner is using wrong index.) Tom Lane (15:12)
Re: Spotting planner errors (was Re: Query planner is using Richard Huxton (15:24)
Re: Loading the entire DB into RAM Tom Lane (15:25)
Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7 Tom Lane (15:29)
Re: Loading the entire DB into RAM Merlin Moncure (15:29)
Re: Loading the entire DB into RAM Scott Marlowe (15:49)
Re: Loading the entire DB into RAM PFC (17:12)
Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7 Tom Lane (17:36)
pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (17:58)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (18:41)
Re: pg 8.1.3, AIX, huge box, painfully slow. Scott Marlowe (18:54)
Re: Same SQL, 104296ms of difference between 7.4.12 and Rafael Martinez (19:04)
Re: bad performance on Solaris 10 Chris Mair (19:29)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (19:45)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (19:59)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (20:06)
Re: pg 8.1.3, AIX, huge box, painfully slow. D'Arcy J.M. Cain (20:16)
Re: pg 8.1.3, AIX, huge box, painfully slow. Scott Marlowe (20:24)
Re: pg 8.1.3, AIX, huge box, painfully slow. Greg Stark (20:30)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gábriel Ákos (20:39)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (21:19)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (21:24)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (21:36)
Re: pg 8.1.3, AIX, huge box, painfully slow. Luke Lonergan (21:50)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (21:56)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (22:02)
Re: pg 8.1.3, AIX, huge box, painfully slow. Luke Lonergan (22:06)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (22:12)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (22:27)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (22:52)
Re: pg 8.1.3, AIX, huge box, painfully slow. Luke Lonergan (22:56)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (23:05)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (23:39)

2006-04-08

Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (01:26)

2006-04-09

Re: Indexes with descending date columns Bruce Momjian (03:26)
OT: Data structure design question: How do they count so fast? Brendan Duddridge (05:49)
pls reply ASAP Chethana, Rao (IE10) (09:27)
Re: Luckys (10:42)
[No subject] Doron Baranes (10:47)
Re: Ragnar (11:10)
Re: pls reply ASAP Rajesh Kumar Mallah (15:34)
serious problems with vacuuming databases Tomas Vondra (18:22)
Re: serious problems with vacuuming databases Alvaro Herrera (18:37)
Re: serious problems with vacuuming databases Tom Lane (18:53)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Bruce Momjian (20:24)
Re: serious problems with vacuuming databases Tomas Vondra (20:33)
Re: serious problems with vacuuming databases Tomas Vondra (20:37)
Re: serious problems with vacuuming databases Tomas Vondra (20:44)
Re: serious problems with vacuuming databases Alvaro Herrera (20:45)
Re: serious problems with vacuuming databases Tomas Vondra (21:49)
Re: serious problems with vacuuming databases Alvaro Herrera (22:01)

2006-04-10

slow "IN" clause FavoYang (03:43)
Re: slow "IN" clause Qingqing Zhou (04:44)
Re: OT: Data structure design question: How do they count so fast? Brendan Duddridge (05:50)
Re: serious problems with vacuuming databases Ahmad Fajar (06:54)
Takes too long to fetch the data from database soni de (07:21)
Restore performance? Jesper Krogh (07:55)
Re: Restore performance? Luke Lonergan (08:04)
Dump restore performance 7.3 -> 8.1 Jesper Krogh (08:22)
Re: Doron Baranes (08:30)
Re: Restore performance? Andreas Pflug (08:43)

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

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