Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2005-12 Chronological Index (3/4)
Last updated: Wed Jan 18 04:19:26 2012
659 messages
11 December 2005
Re: Should Oracle outperform PostgreSQL on a complex multidimensional query? Tom Lane (20:38)
Re: Join the same row Tom Lane (20:36)
Re: How much expensive are row level statistics? Michael Fuhr (19:44)
How much expensive are row level statistics? Carlos Benkendorf (11:53)
Re: Bitmasks Greg Stark (06:12)
10 December 2005
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Manfred Koizar (17:14)
Re: Clustered tables and seqscan disabled Tom Lane (16:53)
Re: Executing a shell command from a PG function Yves Vindevogel (16:50)
Re: Executing a shell command from a PG function Michael Fuhr (16:22)
Re: Executing a shell command from a PG function Jaime Casanova (16:14)
Executing a shell command from a PG function Yves Vindevogel (15:53)
Clustered tables and seqscan disabled Henrique Engelmann (15:36)
Is RAID10 the best choice? Carlos Benkendorf (11:34)
09 December 2005
Re: Query not using index Kaloyan Iliev (16:39)
Re: opinion on disk speed Frank Wiles (15:57)
Re: opinion on disk speed Andreas Pflug (15:50)
Re: opinion on disk speed Frank Wiles (15:49)
Re: opinion on disk speed Frank Wiles (15:46)
Re: Joining 2 tables with 300 million rows Jeff Trout (15:38)
Re: Query not using index Jaime Casanova (15:06)
Re: opinion on disk speed Jeremy Haile (14:15)
Query not using index Kaloyan Iliev (10:01)
Re: opinion on disk speed David Lang (02:30)
08 December 2005
Re: Joining 2 tables with 300 million rows Amit V Shah (22:01)
Re: Joining 2 tables with 300 million rows Dmitri Bichko (21:54)
Re: opinion on disk speed Jeffrey W. Baker (19:22)
Re: Disk tests for a new database server Steve Poe (18:17)
Re: opinion on disk speed Scott Marlowe (17:50)
Joining 2 tables with 300 million rows Amit V Shah (17:24)
slow COMMITs Evgeny Gridasov (17:09)
Re: opinion on disk speed Dave Page (17:03)
opinion on disk speed Vivek Khera (16:52)
Should Oracle outperform PostgreSQL on a complex multidimensional query? Pål Stenslet (14:40)
Re: Performance degradation after successive UPDATE's Assaf Yaari (14:29)
Re: INSERTs becoming slower and slower Matteo Beccati (14:07)
Re: view of view Rich Doughty (13:46)
Re: view of view Merlin Moncure (13:13)
Disk tests for a new database server Rory Campbell-Lange (12:14)
Re: LVM and Postgres Rory Campbell-Lange (11:30)
Re: INSERTs becoming slower and slower Christopher Kings-Lynne (08:40)
INSERTs becoming slower and slower Nörder-Tuitje, Marcus (08:36)
view of view Keith Worthington (03:21)
07 December 2005
Re: Join the same row Richard Huxton (19:02)
Re: Join the same row Edison Azzi (18:45)
Re: First query is slow, subsequent queries fast Stephan Vollmer (18:33)
Re: High context switches occurring Scott Marlowe (16:24)
Re: High context switches occurring Anjan Dave (15:54)
Re: postgresql performance tuning Vivek Khera (15:50)
Re: Performance degradation after successive UPDATE's Assaf Yaari (12:14)
Re: First query is slow, subsequent queries fast Oleg Bartunov (10:55)
First query is slow, subsequent queries fast Stephan Vollmer (10:46)
table partitioning: effects of many sub-tables (was COPY too slow...) Rick Schumeyer (09:31)
Re: Join the same row Richard Huxton (09:27)
Re: TSearch2 vs. Apache Lucene Michael Riess (08:28)
Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne (08:17)
Re: TSearch2 vs. Apache Lucene Michael Riess (07:56)
Re: High context switches occurring Tatsuo Ishii (07:26)
Re: Query Fails with error calloc - Cannot alocate memory Neil Conway (06:23)
Re: High context switches occurring Tom Lane (04:49)
Re: Effects of cascading references in foreign keys Bruce Momjian (04:41)
Re: High context switches occurring Bruce Momjian (04:34)
Re: Query Fails with error calloc - Cannot alocate memory Christopher Kings-Lynne (04:15)
Re: LVM and Postgres Kevin Brown (04:14)
Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne (01:38)
Re: LVM and Postgres Michael Stone (01:31)
Re: LVM and Postgres Alex Turner (00:52)
Re: LVM and Postgres Michael Stone (00:25)
Re: postgresql performance tuning Michael Stone (00:23)
06 December 2005
Re: postgresql performance tuning Ameet Kini (22:03)
Re: two disks - best way to use them? David Lang (22:00)
Re: Context switching and Xeon processors Steinar H. Gunderson (21:52)
Re: Context switching and Xeon processors Brandon Metcalf (21:45)
Re: postgresql performance tuning Alan Stange (21:40)
Re: Context switching and Xeon processors Tom Lane (21:36)
Re: LVM and Postgres Rory Campbell-Lange (21:36)
Re: Missed index opportunity for outer join? Ron Mayer (21:35)
Re: Missed index opportunity for outer join? Tom Lane (21:25)
Re: postgresql performance tuning Tom Lane (21:20)
Context switching and Xeon processors Brandon Metcalf (21:19)
Re: Missed index opportunity for outer join? Ron Mayer (21:08)
Re: postgresql performance tuning Michael Riess (21:02)
Re: postgresql performance tuning Alan Stange (20:49)
Re: Can this query go faster??? Bruno Wolff III (20:46)
Re: Performance degradation after successive UPDATE's Bruno Wolff III (20:40)
Re: TSearch2 vs. Apache Lucene Russell Garrett (20:35)
Re: Missed index opportunity for outer join? Tom Lane (20:33)
Join the same row Edison Azzi (20:23)
Re: LVM and Postgres August Zajonc (20:12)
Re: Missed index opportunity for outer join? Ron Mayer (20:11)
Re: postgresql performance tuning Vivek Khera (20:07)
Re: High context switches occurring Vivek Khera (19:25)
postgresql performance tuning Ameet Kini (19:20)
Re: High context switches occurring Anjan Dave (19:04)
Re: postgresql performance tuning Vivek Khera (18:33)
Re: TSearch2 vs. Apache Lucene Bruce Momjian (18:32)
Re: TSearch2 vs. Apache Lucene Michael Riess (18:28)
Re: postgresql performance tuning Tom Lane (18:03)
Re: TSearch2 vs. Apache Lucene Tom Lane (18:02)
Re: Memory Leakage Problem Scott Marlowe (17:48)
postgresql performance tuning Ameet Kini (17:44)
Re: TSearch2 vs. Apache Lucene Bruce Momjian (17:27)
Re: TSearch2 vs. Apache Lucene Oleg Bartunov (17:14)
Re: TSearch2 vs. Apache Lucene Michael Riess (16:59)
Re: Missed index opportunity for outer join? Tom Lane (16:57)
TSearch2 vs. Apache Lucene Joshua Kramer (16:48)
Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard (16:19)
Re: two disks - best way to use them? Thomas Harold (16:00)
Re: Memory Leakage Problem Tom Lane (14:45)
Re: Can this query go faster??? Merlin Moncure (13:58)
Re: Can this query go faster??? Ron (13:41)
Re: Can this query go faster??? Csaba Nagy (12:42)
Re: Performance degradation after successive UPDATE's Jan Wieck (12:35)
Re: Can this query go faster??? Tino Wildenhain (12:30)
Re: Can this query go faster??? Joost Kraaijeveld (12:20)
Re: BLCKSZ David Lang (11:42)
Re: Can this query go faster??? Tino Wildenhain (11:36)
Re: Can this query go faster??? Joost Kraaijeveld (11:21)
Re: BLCKSZ Steinar H. Gunderson (10:59)
Re: BLCKSZ Olleg (10:40)
Re: Can this query go faster??? Tino Wildenhain (10:32)
Re: Can this query go faster??? Joost Kraaijeveld (10:21)
Re: Can this query go faster??? Markus Wollny (09:55)
Re: Can this query go faster??? Csaba Nagy (09:54)
Re: Performance degradation after successive UPDATE's Pandurangan R S (09:52)
Re: Can this query go faster??? Michael Riess (09:51)
Can this query go faster??? Joost Kraaijeveld (09:43)
need help (not anymore) Jenny (09:41)
LVM and Postgres Rory Campbell-Lange (09:39)
Memory Leakage Problem Kathy Lo (09:22)
Re: Performance degradation after successive UPDATE's Assaf Yaari (09:07)
Re: [GENERAL] need help Tino Wildenhain (08:54)
need help Jenny (08:45)
Re: two disks - best way to use them? Ron (08:12)
Re: two disks - best way to use them? Thomas Harold (05:52)
Re: BLCKSZ Tom Lane (05:51)
Re: two disks - best way to use them? David Lang (03:57)
Re: 15,000 tables - next step Jan Wieck (03:07)
Re: BLCKSZ Ron (01:21)
Re: BLCKSZ Alvaro Herrera (00:07)
05 December 2005
Re: Missed index opportunity for outer join? Tom Lane (22:38)
Re: BLCKSZ Olleg (22:32)
Missed index opportunity for outer join? rm_pg (22:11)
Re: Performance degradation after successive UPDATE's Bruno Wolff III (20:31)
Performance degradation after successive UPDATE's Assaf Yaari (20:17)
Re: Best hardware Mirjam (sent by Nabble.com) (19:27)
Re: two disks - best way to use them? Thomas Harold (16:44)
Re: two disks - best way to use them? David Lang (16:18)
Re: two disks - best way to use them? Thomas Harold (15:47)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny (15:45)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny (15:40)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane (15:11)
Re: BLCKSZ Tom Lane (15:02)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny (14:44)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane (14:32)
Re: two disks - best way to use them? Olleg Samoylov (13:56)
BLCKSZ Olleg Samoylov (13:47)
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny (10:29)
Query Fails with error calloc - Cannot alocate memory Howard Oblowitz (07:56)