pgsql-performance - April 2006

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

April 1, 2006

Thread Author Time
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

April 2, 2006

Thread Author Time
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

April 3, 2006

Thread Author Time
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

April 4, 2006

Thread Author Time
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

April 5, 2006

Thread Author Time
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

April 6, 2006

Thread Author Time
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

April 7, 2006

Thread Author Time
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

April 8, 2006

Thread Author Time
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill 01:26

April 9, 2006

Thread Author Time
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

April 10, 2006

Thread Author Time
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

Browse Archives

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