• 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-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
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2007-02 Chronological Index (2/2)

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

• 15 February 2007
  • Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
  • Re: Slow query with 'or' clause Richard Huxton
  • Slow query with 'or' clause philippe
  • Re: Problem with joining queries. Konstantinos Krikellas
  • Re: Problem with joining queries. Richard Huxton
  • Re: Benchmarking PGSQL? Merlin Moncure
  • Problem with joining queries. Konstantinos Krikellas
  • Re: An unwanted seqscan Brian Herlihy
• 14 February 2007
  • Re: Benchmarking PGSQL? Josh Berkus
  • Re: Proximity query with GIST and row estimation Paul Ramsey
  • Re: How long should it take to insert 200,000 records? Lou O'Quin
  • Re: JOIN to a VIEW makes a real slow query Chuck D.
  • Re: reindex vs 'analyze' Mark Stosberg
  • Re: quad or dual core Intel CPUs Claus Guttesen
  • Re: Benchmarking PGSQL? Luke Lonergan
  • Re: Proximity query with GIST and row estimation Guillaume Smet
  • Re: reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Tom Lane
  • Re: quad or dual core Intel CPUs Kenji Morishige
  • reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Mark Stosberg
  • Re: Benchmarking PGSQL? Merlin Moncure
  • Re: Benchmarking PGSQL? Luke Lonergan
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: Benchmarking PGSQL? Shoaib Mir
  • Benchmarking PGSQL? Krishna Kumar
  • Re: quad or dual core Intel CPUs Claus Guttesen
  • Re: An unwanted seqscan Tom Lane
  • An unwanted seqscan Brian Herlihy
  • Re: cube operations slower than geo_distance() on production server Tom Lane
• 13 February 2007
  • Re: quad or dual core Intel CPUs Heikki Linnakangas
  • Re: quad or dual core Intel CPUs Guillaume Smet
  • Re: quad or dual core Intel CPUs Dan Harris
  • Re: quad or dual core Intel CPUs Mark Kirkwood
  • Re: quad or dual core Intel CPUs Arjen van der Meijden
  • Re: cube operations slower than geo_distance() on production server Mark Stosberg
  • Re: JOIN to a VIEW makes a real slow query Tom Lane
  • Re: JOIN to a VIEW makes a real slow query Chuck D.
  • quad or dual core Intel CPUs Kenji Morishige
  • Re: JOIN to a VIEW makes a real slow query Merlin Moncure
  • JOIN to a VIEW makes a real slow query Chuck D.
  • Re: CPU Usage Alan Hodgson
  • CPU Usage Campbell, Lance
  • Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane
  • Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
  • Proximity query with GIST and row estimation Guillaume Smet
  • Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane
  • Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: many instances or many databases or many users? Heikki Linnakangas
  • many instances or many databases or many users? ismo . tuononen
  • Re: limit + order by is slow if no rows in result set Tom Lane
  • Re: limit + order by is slow if no rows in result set Brian Cox
• 12 February 2007
  • Re: limit + order by is slow if no rows in result set Heikki Linnakangas
  • limit + order by is slow if no rows in result set Brian Cox
  • Re: cube operations slower than geo_distance() on production server Mark Stosberg
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: cube operations slower than geo_distance() on production server Mark Stosberg
• 10 February 2007
  • Re: cube operations slower than geo_distance() on production server Merlin Moncure
  • Re: Is there an equivalent for Oracle'suser_tables.num_rows Simon Riggs
  • Re: Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena
  • Re: Is there an equivalent for Oracle's user_tables.num_rows Tom Lane
  • Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena
• 09 February 2007
  • Re: Can anyone make this code tighter? Too slow, Please help! Mark Stosberg
  • cube operations slower than geo_distance() on production server Mark Stosberg
  • Re: Recreate big table Daniel Cristian Cruz
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Recreate big table Gábriel Ákos
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Alvaro Herrera
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization minshall
  • Re: stats collector process high CPU utilization Tom Lane
• 08 February 2007
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: stats collector process high CPU utilization Benjamin Minshall
  • Disk saturation Carlos H. Reimer
  • Re: stats collector process high CPU utilization Tom Lane
  • Re: Speed up this query Mark Stosberg
  • stats collector process high CPU utilization Benjamin Minshall
• 07 February 2007
  • tip: faster sorting for proximity queries by using cube_distance() Mark Stosberg
  • Re: Help Needed Richard Huxton
  • Help Needed Muruganantham M
  • Re: How long should it take to insert 200,000 records? Tom Lane
  • Re: How long should it take to insert 200,000 records? Mark Kirkwood
• 06 February 2007
  • Re: How long should it take to insert 200,000 records? Karen Hill
  • Re: index scan through a subquery Bill Howe
  • Re: How long should it take to insert 200,000 records? Mark Lewis
  • Re: How long should it take to insert 200,000 records? Merlin Moncure
  • Re: How long should it take to insert 200,000 records? Bruno Wolff III
  • Re: How long should it take to insert 200,000 records? Mark Lewis
  • Re: How long should it take to insert 200,000 records? Hiltibidal, Robert
  • Re: How long should it take to insert 200,000 records? Merlin Moncure
  • Re: How long should it take to insert 200,000 records? Scott Marlowe
  • Re: How long should it take to insert 200,000 records? Merlin Moncure
  • Re: How long should it take to insert 200,000 records? Scott Marlowe
  • Re: explain analyze output for review (was: optimizing a geo_distance()...) Bruno Wolff III
  • Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert
  • Re: explain analyze output: vacuuming made a big difference. Mark Stosberg
  • Re: explain analyze output for review (was: optimizing a geo_distance()...) Adam Rich
  • Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert
  • Re: explain analyze output for review (was: optimizing a geo_distance()...) Mark Stosberg
  • Re: optimizing a geo_distance() proximity query (example and benchmark) Merlin Moncure
  • Re: Tuning Harald Armin Massa
  • Re: How long should it take to insert 200,000 records? Csaba Nagy
  • Re: index scan through a subquery Tom Lane
  • Re: optimizing a geo_distance() proximity query (example and benchmark) Bruno Wolff III
  • Re: How long should it take to insert 200,000 records? Tom Lane
  • How long should it take to insert 200,000 records? Karen Hill
• 05 February 2007
  • Re: optimizing a geo_distance() proximity query (example and benchmark) Mark Stosberg
  • Re: optimizing a geo_distance() proximity query Bruno Wolff III
  • Re: optimizing a geo_distance() proximity query Merlin Moncure
  • Re: optimizing a geo_distance() proximity query Mark Stosberg
  • Re: trouble with a join on OS X Shane Ambler
  • Re: trouble with a join on OS X Kirk Wythers
• 04 February 2007
  • Re: optimizing a geo_distance() proximity query Bruno Wolff III
• 03 February 2007
  • Re: optimizing a geo_distance() proximity query Oleg Bartunov
  • optimizing a geo_distance() proximity query Mark Stosberg
  • Re: trouble with a join on OS X Shane Ambler
  • Re: trouble with a join on OS X Tom Lane
  • Re: trouble with a join on OS X Joshua D. Drake
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Tom Lane
  • Re: trouble with a join on OS X Joshua D. Drake
  • Re: trouble with a join on OS X Geoffrey
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Joshua D. Drake
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Luke Lonergan
  • Re: trouble with a join on OS X Joshua D. Drake
  • Re: trouble with a join on OS X Luke Lonergan
• 02 February 2007
  • Re: trouble with a join on OS X Tom Lane
  • OT: Mac OS X disk buffer cache Kevin Murphy
  • Re: drive configuration for a new server Ben
  • Re: drive configuration for a new server Jeff Frost
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Tom Lane
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Tom Lane
  • Re: trouble with a join on OS X Steinar H. Gunderson
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Kirk Wythers
  • Re: trouble with a join on OS X Tom Lane
  • Re: trouble with a join on OS X Gábriel Ákos
  • Re: trouble with a join on OS X Richard Huxton
  • Re: trouble with a join on OS X Steinar H. Gunderson
  • trouble with a join on OS X Kirk Wythers
  • Re: Subselect query enhancement Richard Huxton
  • index scan through a subquery Bill Howe
  • drive configuration for a new server Ben
• 01 February 2007
  • Re: Subselect query enhancement Andrew Lazarus
  • Re: int4 vs varchar to store ip addr Michael Artz
  • Re: Subselect query enhancement Michael Artz
  • Re: Subselect query enhancement Richard Huxton
  • Re: Subselect query enhancement Michael Artz
  • Re: Subselect query enhancement Frank Wiles
  • Re: Subselect query enhancement Michael Artz
  • Re: Subselect query enhancement Ted Allen
  • Re: Subselect query enhancement Richard Huxton
  • Subselect query enhancement Michael Artz
  • Using statement_timeout as a performance tool? Mark Stosberg
• 31 January 2007
  • Re: Tuning Mischa Sandberg

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