Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2006-04 Chronological Index (3/4)
Last updated: Wed Jan 18 04:18:51 2012
708 messages
13 April 2006
Re: pgmemcache PFC (20:22)
Re: multi column query Sriram Dandapani (19:52)
Re: bad performance on Solaris 10 Merlin Moncure (19:38)
Re: Inserts optimization? Francisco Reyes (18:59)
Re: Blocks read for index scans Jim Nasby (18:49)
Re: Inserts optimization? Francisco Reyes (18:46)
Re: pgmemcache Jim Nasby (18:29)
Blocks read for index scans Jim Nasby (18:00)
Re: bad performance on Solaris 10 Robert Lor (17:40)
Re: pgmemcache Tom Lane (17:38)
Re: pgmemcache Christian Storm (17:29)
Re: multi column query Jim Nasby (16:43)
Re: index is not used if I include a function that returns current time in my query Tom Lane (15:50)
Re: Better index stategy for many fields with few values Oscar Picasso (15:40)
Re: Slow query - possible bug? Tom Lane (15:27)
index is not used if I include a function that returns current time in my query Cristian Veronesi (15:21)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (14:48)
Re: pgmemcache Markus Schaber (14:03)
Re: Better index stategy for many fields with few values Markus Schaber (14:00)
Re: Slow query - possible bug? Richard Huxton (13:59)
Re: Slow query - possible bug? Gavin Hamill (13:08)
Re: Slow query - possible bug? chris smith (12:46)
Slow query - possible bug? Gavin Hamill (12:34)
index is not used if I include a function that returns current time in my query Cris Carampa (10:25)
Re: Better index stategy for many fields with few values Markus Schaber (09:51)
Re: Better index stategy for many fields with few values Markus Schaber (09:33)
Re: bad performance on Solaris 10 Bruce Momjian (08:39)
Re: bad performance on Solaris 10 Tom Lane (04:52)
Re: pg 7.4.x - pg_restore impossibly slow Tom Lane (04:46)
Re: Inserts optimization? Tom Lane (04:42)
Re: Sun Fire T2000 and PostgreSQL 8.1.3 Bruce Momjian (02:55)
Re: bad performance on Solaris 10 Jignesh K. Shah (01:53)
Re: FOREIGN KEYS vs PERFORMANCE Craig A. James (01:37)
pg 7.4.x - pg_restore impossibly slow patrick keshishian (01:26)
Re: Inserts optimization? Chris (01:19)
Inserts optimization? Francisco Reyes (01:11)
Re: multi column query Jim C. Nasby (00:43)
Re: pgmemcache Tom Lane (00:35)
multi column query Sriram Dandapani (00:32)
Re: pgmemcache Jim C. Nasby (00:10)
12 April 2006
Re: Better index stategy for many fields with few values Jim Nasby (23:04)
Re: bad performance on Solaris 10 Josh Berkus (22:50)
Re: Better index stategy for many fields with few Luke Lonergan (22:38)
Re: bad performance on Solaris 10 Luke Lonergan (22:35)
Re: FOREIGN KEYS vs PERFORMANCE Jim C. Nasby (21:41)
Re: Better index stategy for many fields with few values Jim C. Nasby (20:44)
Re: bad performance on Solaris 10 Bruce Momjian (19:56)
Re: FOREIGN KEYS vs PERFORMANCE Craig A. James (17:45)
Re: FOREIGN KEYS vs PERFORMANCE Jim C. Nasby (15:40)
Re: FOREIGN KEYS vs PERFORMANCE Jim C. Nasby (15:36)
Re: FOREIGN KEYS vs PERFORMANCE Scott Marlowe (15:13)
Re: FOREIGN KEYS vs PERFORMANCE PFC (15:08)
Re: FOREIGN KEYS vs PERFORMANCE Michael Glaesemann (15:07)
Re: FOREIGN KEYS vs PERFORMANCE Merlin Moncure (15:03)
Re: FOREIGN KEYS vs PERFORMANCE Rodrigo Sakai (14:50)
Re: FOREIGN KEYS vs PERFORMANCE Craig A. James (14:50)
Re: FOREIGN KEYS vs PERFORMANCE Markus Schaber (13:18)
Re: Sequencial scan instead of using index Harry Hehl (13:04)
Re: Better index stategy for many fields with few values Markus Schaber (12:59)
Re: FOREIGN KEYS vs PERFORMANCE PFC (07:22)
Re: pgmemcache PFC (07:18)
Re: FOREIGN KEYS vs PERFORMANCE Tom Lane (02:56)
Re: Restore performance? Christopher Kings-Lynne (02:05)
11 April 2006
Re: FOREIGN KEYS vs PERFORMANCE Michael Glaesemann (23:06)
Re: freebsd/softupdates for data dir Jim C. Nasby (22:59)
Re: pgmemcache Jim C. Nasby (22:55)
Re: Sequencial scan instead of using index Tom Lane (22:50)
Re: Sequencial scan instead of using index Harry Hehl (22:32)
Re: Sequencial scan instead of using index markir (22:30)
Re: Sequencial scan instead of using index markir (22:29)
Re: Encouraging multi-table join order Tom Lane (22:13)
Re: Encouraging multi-table join order Dan Harris (21:30)
Re: Encouraging multi-table join order Tom Lane (21:20)
Re: Stored Procedure Performance Merlin Moncure (21:14)
Re: Encouraging multi-table join order Dan Harris (21:13)
Re: FOREIGN KEYS vs PERFORMANCE Scott Marlowe (20:26)
FOREIGN KEYS vs PERFORMANCE Rodrigo Sakai (19:35)
Re: Indexes with descending date columns Markus Schaber (17:59)
Re: Stored Procedure Performance Alvaro Herrera (14:09)
Re: Stored Procedure Performance H.J. Sanders (14:02)
Re: Stored Procedure Performance Christopher Browne (13:57)
Re: Takes too long to fetch the data from database Tom Lane (13:50)
Re: Stored Procedure Performance Merlin Moncure (13:50)
Re: Takes too long to fetch the data from database Merlin Moncure (13:13)
Re: Restore performance? Jesper Krogh (12:05)
Re: Takes too long to fetch the data from database Richard Huxton (10:17)
Re: Stored Procedure Performance Richard Huxton (10:04)
Re: Stored Procedure Performance Rajesh Kumar Mallah (08:22)
Re: Stored Procedure Performance hubert depesz lubaczewski (07:58)
Stored Procedure Performance Simon Dale (07:19)
Re: Takes too long to fetch the data from database soni de (07:05)
Re: slow "IN" clause Vinko Vrsalovic (05:02)
Re: Encouraging multi-table join order Tom Lane (02:05)
Re: Encouraging multi-table join order Dan Harris (00:49)
10 April 2006
Re: bad performance on Solaris 10 Chris Mair (21:12)
Re: OT: Data structure design question: How do they count so fast? Brendan Duddridge (21:04)
Re: pg 8.1.3, AIX, huge box, painfully slow. Brad Nicholson (20:40)
Encouraging multi-table join order Dan Harris (20:21)
Re: Restore performance? Vivek Khera (20:10)
Re: Takes too long to fetch the data from database Joshua D. Drake (19:40)
Re: Better index stategy for many fields with few values PFC (17:25)
Re: Restore performance? PFC (17:19)
Better index stategy for many fields with few values Oscar Picasso (16:59)
Re: Restore performance? Alvaro Herrera (16:24)
Re: Restore performance? Rajesh Kumar Mallah (16:09)
Re: Takes too long to fetch the data from database Rajesh Kumar Mallah (15:58)
Re: Restore performance? Jesper Krogh (15:55)
Re: Restore performance? Rajesh Kumar Mallah (15:43)
Re: Restore performance? Rajesh Kumar Mallah (15:40)
Re: pg 8.1.3, AIX, huge box, painfully slow. Tom Lane (15:36)
Re: Restore performance? Tom Lane (15:24)
Re: Ragnar (11:56)
Re: pg 8.1.3, AIX, huge box, painfully slow. Gavin Hamill (09:44)
Re: pg 8.1.3, AIX, huge box, painfully slow. Simon Riggs (09:27)
Re: OT: Data structure design question: How do they count Richard Huxton (09:24)
Re: pg 8.1.3, AIX, huge box, painfully slow. Richard Huxton (09:06)
Re: Restore performance? Marcin Mańk (09:01)
Re: Restore performance? Jesper Krogh (08:46)
Re: Restore performance? Andreas Pflug (08:43)
Dump restore performance 7.3 -> 8.1 Jesper Krogh (08:22)
Re: Restore performance? Luke Lonergan (08:07)
Restore performance? Jesper Krogh (07:56)
Re: Doron Baranes (07:30)
Takes too long to fetch the data from database soni de (07:21)
Re: serious problems with vacuuming databases Ahmad Fajar (06:59)
Re: OT: Data structure design question: How do they count so fast? Brendan Duddridge (05:50)
Re: slow "IN" clause Qingqing Zhou (04:48)
slow "IN" clause FavoYang (03:43)
09 April 2006
Re: serious problems with vacuuming databases Tomas Vondra (21:49)
Re: serious problems with vacuuming databases Alvaro Herrera (20:46)
Re: serious problems with vacuuming databases Tomas Vondra (20:45)
Re: serious problems with vacuuming databases Tomas Vondra (20:37)
Re: serious problems with vacuuming databases Tomas Vondra (20:34)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Bruce Momjian (20:24)
Re: serious problems with vacuuming databases Tom Lane (18:54)
Re: serious problems with vacuuming databases Alvaro Herrera (18:38)
serious problems with vacuuming databases Tomas Vondra (18:23)
Re: pls reply ASAP Rajesh Kumar Mallah (15:34)
Re: Ragnar (11:07)
Re: Luckys (10:42)
[no subject] Doron Baranes (09:47)
pls reply ASAP Chethana, Rao (IE10) (09:23)
OT: Data structure design question: How do they count so fast? Brendan Duddridge (05:49)
Re: Indexes with descending date columns Bruce Momjian (03:27)
08 April 2006
07 April 2006