• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-cygwin
    • pgsql-general
    • pgsql-interfaces
    • pgsql-jdbc
    • pgsql-jobs
    • pgsql-novice
    • pgsql-odbc
    • pgsql -performance
    • pgsql-php
    • pgsql-ports
    • pgsql-sql
  • Developer lists
  • Regional lists
  • Project lists
  • User groups
  • Inactive lists
• IRC
• In The Real World
• International Sites
• Propaganda
• Resources
• Weekly News

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

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