• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2007-04 Chronological Index (1/3)

• Thread Index
• [Prev Page]
• [Next Page]

• 30 April 2007
  • Re: Query performance problems with partitioned tables Gregory Stark (19:19)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Kevin Hunter (17:30)
  • Re: Query performance problems with partitioned tables Steinar H. Gunderson (17:23)
  • Re: Query performance problems with partitioned tables Andreas Haumer (17:21)
  • Re: Query performance problems with partitioned tables Andreas Haumer (16:58)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Craig A. James (16:19)
  • Re: Query performance problems with partitioned tables Gregory Stark (15:36)
  • Re: Query performance problems with partitioned tables Tom Lane (15:06)
  • sytem log audit/reporting and psql Fei Liu (14:13)
  • Re: Query performance problems with partitioned tables Neil Peter Braggio (14:06)
  • Re: Query performance problems with partitioned tables Guillaume Cottenceau (13:54)
  • Re: Query performance problems with partitioned tables Richard Huxton (13:45)
  • Re: Query performance problems with partitioned tables Andreas Haumer (13:29)
  • Re: Query performance problems with partitioned tables Guillaume Cottenceau (13:05)
  • Query performance problems with partitioned tables Andreas Haumer (12:16)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith (11:48)
• 28 April 2007
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (22:51)
  • Re: Very specific server situation Mauro N. Infantino (20:43)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno (20:34)
  • Re: Usage up to 50% CPU Andres Retzlaff (19:28)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Harald Armin Massa (18:15)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Jonah H. Harris (16:54)
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (09:56)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Harald Armin Massa (08:31)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning david (01:39)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus (00:46)
• 27 April 2007
  • Re: Very specific server situation Tom Lane (22:51)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Dan Harris (20:28)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus (19:10)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Ray Stell (18:52)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Kevin Hunter (18:40)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Bill Moran (18:11)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus (17:59)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Dan Harris (17:47)
  • Very specific server situation Mauro N. Infantino (17:45)
  • Re: How can fixed and variable width columns perform similarly? Tom Lane (17:12)
  • Re: How can fixed and variable width columns perform similarly? Siddharth Anand (16:43)
  • Re: How can fixed and variable width columns perform similarly? Dave Dutcher (16:39)
  • Re: [Fwd: ] How Richard Huxton (16:35)
  • Re: How can fixed and variable width columns perform similarly? Tom Lane (16:26)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Jim Nasby (16:12)
  • How can fixed and variable width columns perform similarly? Siddharth Anand (15:56)
  • [Fwd: ] How Siddharth Anand (15:56)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone (15:32)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning H.J. Sanders (15:23)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Mark Lewis (14:37)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Tom Lane (14:36)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone (14:30)
  • Re: What`s wrong with JFS configuration? Jim Nasby (14:09)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno (13:27)
  • Re: Usage up to 50% CPU Michael Stone (12:52)
  • Re: Usage up to 50% CPU Shane Ambler (09:53)
  • Re: Usage up to 50% CPU Magnus Hagander (08:13)
  • Re: Usage up to 50% CPU Andres Retzlaff (08:10)
  • Re: Usage up to 50% CPU Magnus Hagander (08:06)
  • Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Florian Weimer (07:39)
  • Re: index structure for 114-dimension vector Arjen van der Meijden (06:07)
  • Re: Fragmentation of WAL files Greg Smith (04:51)
  • Re: Simple query, 10 million records...MySQL ten times faster Oleg Bartunov (04:49)
  • Re: index structure for 114-dimension vector Oleg Bartunov (04:43)
  • Usage up to 50% CPU Andres Retzlaff (04:43)
  • Re: Feature Request --- was: PostgreSQL Performance Tuning Tom Lane (02:49)
  • Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno (01:58)
  • Re: Simple query, 10 million records...MySQL ten times faster joe (01:48)
  • Re: postgres: 100% CPU utilization Mark Kirkwood (01:27)
• 26 April 2007
  • Re: Simple query, 10 million records...MySQL ten times faster Alexander Staubo (23:14)
  • Re: Simple query, 10 million records...MySQL ten times faster Alexander Staubo (23:12)
  • Re: postgres: 100% CPU utilization Scott Marlowe (22:50)
  • Re: Simple query, 10 million records...MySQL ten times faster Jeff Hoffmann (22:45)
  • Re: Simple query, 10 million records...MySQL ten times faster Scott Marlowe (22:42)
  • Re: index structure for 114-dimension vector Alexander Staubo (22:34)
  • Re: Simple query, 10 million records...MySQL ten times faster Luke Lonergan (21:40)
  • Re: Simple query, 10 million records...MySQL ten times faster Benjamin Minshall (21:36)
  • Re: Simple query, 10 million records...MySQL ten times faster Bill Moran (21:11)
  • Re: Simple query, 10 million records...MySQL ten times faster Merlin Moncure (21:09)
  • Re: [GENERAL] PostgreSQL Performance Tuning Steve Crawford (19:49)
  • Re: not using indexes on large table Scott Marlowe (19:22)
  • Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Tom Lane (17:49)
  • Re: [GENERAL] Fw: PostgreSQL Performance Tuning Gerhard Wiesinger (17:03)
  • Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Gregory Stark (16:47)
  • Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Craig A. James (16:26)
  • Re: Fragmentation of WAL files Tom Lane (15:37)
  • Filesystem fragmentation (Re: Fragmentation of WAL files) Bill Moran (13:14)
  • Re: Fragmentation of WAL files Heikki Linnakangas (12:10)
  • Re: Fragmentation of WAL files Bill Moran (12:00)
  • Re: [GENERAL] Fw: PostgreSQL Performance Tuning Richard Huxton (11:54)
  • Re: Fw: PostgreSQL Performance Tuning Richard Huxton (11:53)
  • Fw: PostgreSQL Performance Tuning Shohab Abdullah (11:44)
  • Re: What`s wrong with JFS configuration? Cosimo Streppone (09:04)
  • Re: seeking advise on char vs text or varchar in search table Gregory Stark (08:35)
  • Re: What`s wrong with JFS configuration? Luke Lonergan (08:17)
  • Re: What`s wrong with JFS configuration? Jim Nasby (07:51)
  • Re: seeking advise on char vs text or varchar in search table Jim Nasby (07:51)
  • Fragmentation of WAL files Jim Nasby (07:51)
  • Re: What`s wrong with JFS configuration? Greg Smith (04:04)
• 25 April 2007
  • Re: What`s wrong with JFS configuration? Chris Browne (15:04)
  • Re: What`s wrong with JFS configuration? Paweł Gruszczyński (13:39)
  • Re: What`s wrong with JFS configuration? Dave Cramer (11:21)
  • Re: What`s wrong with JFS configuration? Heikki Linnakangas (08:54)
  • What`s wrong with JFS configuration? Paweł Gruszczyński (07:16)
• 24 April 2007
  • Simple query, 10 million records...MySQL ten times faster zardozrocks (21:27)
  • Re: View is not using a table index Carlos Moreno (21:13)
  • Re: View is not using a table index Tom Lane (18:09)
  • Re: View is not using a table index Andreas Kostyrka (18:03)
  • Re: View is not using a table index Dan Shea (17:31)
  • Re: View is not using a table index Richard Huxton (15:42)
  • Re: postgres: 100% CPU utilization Sergey Tsukinovsky (15:31)
  • View is not using a table index Dan Shea (15:17)
  • Re: Warm - standby system. Alexander Staubo (09:33)
  • Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Heikki Linnakangas (08:53)
  • Warm - standby system. Nimesh Satam (07:12)
  • Re: postgres: 100% CPU utilization Greg Smith (03:41)
  • Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Greg Smith (03:39)
• 23 April 2007
  • Re: postgres: 100% CPU utilization Mark Kirkwood (23:59)
  • Re: postgres: 100% CPU utilization Scott Marlowe (20:21)
  • Re: postgres: 100% CPU utilization Vivek Khera (20:00)
  • Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Kevin Grittner (18:26)
  • Re: index usage Steinar H. Gunderson (18:19)
  • Re: index structure for 114-dimension vector C Storm (17:49)
  • index usage Arkadiusz Raj (17:46)
  • Re: postgres: 100% CPU utilization Scott Marlowe (16:09)
  • Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Nelson Kotowski (15:52)
  • Re: postgres: 100% CPU utilization Ron (15:06)
  • Re: not using indexes on large table Dave Dutcher (14:56)
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (11:35)
  • Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Heikki Linnakangas (09:47)
  • Re: postgres: 100% CPU utilization Mario Weilguni (08:53)
  • Re: Help with TOAST Compression Michael Fuhr (08:46)
  • Re: postgres: 100% CPU utilization Andreas Tille (06:06)
  • Re: seeking advise on char vs text or varchar in search table Merlin Moncure (05:16)
  • Re: postgres: 100% CPU utilization Tom Lane (04:36)
  • Re: Redundant sub query triggers slow nested loop left join Tom Lane (02:14)
• 22 April 2007
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (22:58)
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (22:39)
  • Re: Redundant sub query triggers slow nested loop left join Tom Lane (20:42)
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (20:22)
  • Re: Redundant sub query triggers slow nested loop left join Tom Lane (17:53)
  • Re: Redundant sub query triggers slow nested loop left join henk de wit (16:17)
  • Re: Large objetcs performance Ulrich Cech (09:06)
  • Re: Odd problem with planner choosing seq scan Tom Lane (02:45)
  • Re: Odd problem with planner choosing seq scan Colin McGuigan (01:34)
• 21 April 2007
  • Re: Redundant sub query triggers slow nested loop left join Tom Lane (23:48)
  • Redundant sub query triggers slow nested loop left join henk de wit (23:24)
  • Re: not using indexes on large table Andreas Kostyrka (21:16)
  • Re: not using indexes on large table Vincenzo Romano (20:58)
  • not using indexes on large table Jeroen Kleijer (20:46)
  • Re: Odd problem with planner choosing seq scan Tom Lane (17:06)
  • Re: FK triggers misused? Stephan Szabo (16:18)
  • Odd problem with planner choosing seq scan Colin McGuigan (15:19)
  • TPC-H Scaling Factors X PostgreSQL Cluster Command Nelson Kotowski (14:54)
  • Re: FK triggers misused? cluster (10:42)
  • Re: Large objetcs performance Ulrich Cech (07:32)
  • Odd problem with planner choosing seq scan Colin McGuigan (05:50)
  • Re: index structure for 114-dimension vector Tom Lane (00:44)
  • Re: index structure for 114-dimension vector Mark Kirkwood (00:42)
  • Re: index structure for 114-dimension vector Andrew Lazarus (00:05)
• 20 April 2007
  • Re: index structure for 114-dimension vector Mark Kirkwood (23:42)
  • Re: index structure for 114-dimension vector Jeff Davis (21:41)
  • index structure for 114-dimension vector Andrew Lazarus (19:43)
  • seeking advise on char vs text or varchar in search table chrisj (14:24)
• 19 April 2007
  • postgres: 100% CPU utilization Sergey Tsukinovsky (19:31)
  • Re: how to output column names Michael Dengler (19:26)
  • Re: how to output column names Jon Sime (17:49)
  • how to output column names Michael Dengler (17:06)
  • Re: Foreign Key Deadlocking Csaba Nagy (14:29)
  • Re: Foreign Key Deadlocking Alvaro Herrera (14:16)
  • Re: Foreign Key Deadlocking Erik Jones (14:16)
  • Re: Foreign Key Deadlocking Dave Cramer (14:00)
  • Re: Basic Q on superfluous primary keys Merlin Moncure (00:16)
• 18 April 2007
  • Re: Foreign Key Deadlocking Steven Flatt (20:59)
  • Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Hannes Dorbath (20:03)
  • Re: Basic Q on superfluous primary keys Jeff Davis (19:08)
  • Re: Long running transactions again ... Jim C. Nasby (18:26)
  • Re: Basic Q on superfluous primary keys Dave Dutcher (18:10)
  • Re: a question about Direct I/O and double buffering Jim C. Nasby (18:08)
  • Re: Foreign Key Deadlocking Tom Lane (17:47)
  • Re: Shared buffers, db transactions commited, and write IO on Solaris Jim C. Nasby (17:20)
  • Re: Basic Q on superfluous primary keys Craig A. James (16:03)
  • Re: Foreign Key Deadlocking Csaba Nagy (15:37)
  • Foreign Key Deadlocking Steven Flatt (15:07)

• Thread Index
• [Prev Page]
• [Next Page]