db.postgresql.performance (thread)

Index works with foo.val=bar.val but not foo.val<=bar.val, 8lhhxba02
Extremely slow query..., pathat
my boss want to migrate to ORACLE, Stephane Tessier
- Re: my boss want to migrate to ORACLE, Russell Smith
- Re: my boss want to migrate to ORACLE, markir
- Re: my boss want to migrate to ORACLE, markir
  - Re: my boss want to migrate to ORACLE, Stephane Tessier
    - Re: my boss want to migrate to ORACLE, Scott Marlowe
    - Re: my boss want to migrate to ORACLE, Matthew T. O'Connor
    - Re: my boss want to migrate to ORACLE, Dan Langille
    - Re: my boss want to migrate to ORACLE, Brian Hirt
    - Re: my boss want to migrate to ORACLE, Christopher Browne
    - Re: my boss want to migrate to ORACLE, Scott Marlowe
- Re: my boss want to migrate to ORACLE, Jeff
- Re: my boss want to migrate to ORACLE, Merlin Moncure
Optimizer refuses to hash join, Stan Bielski
- Re: Optimizer refuses to hash join, Stephan Szabo
- Re: Optimizer refuses to hash join, Tom Lane
- Re: Optimizer refuses to hash join, Tom Lane
Automagic tuning, Markus Schaber
- Re: Automagic tuning, Christopher Kings-Lynne
best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, Tom Lane
- Re: best way to fetch next/prev record based on index, Greg Stark
- Re: best way to fetch next/prev record based on index, Rod Taylor
- Re: best way to fetch next/prev record based on index, Markus Schaber
  - Correction of best way to fetch next/prev record based on index, Markus Schaber
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Stephan Szabo
    - Re: best way to fetch next/prev record based on index, Greg Stark
    - Re: best way to fetch next/prev record based on index, Greg Stark
    - Re: best way to fetch next/prev record based on index, Tom Lane
    - Re: best way to fetch next/prev record based on index, Greg Stark
    - Re: best way to fetch next/prev record based on index, Tom Lane
    - Re: best way to fetch next/prev record based on index, Greg Stark
    - Re: best way to fetch next/prev record based on index, Tom Lane
- best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, andrew
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Greg Stark
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Markus Schaber
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Tom Lane
    - Re: best way to fetch next/prev record based on index, Tom Lane
    - Re: best way to fetch next/prev record based on index, Tom Lane
- Re: best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, Merlin Moncure
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Greg Stark
- Re: best way to fetch next/prev record based on index, Merlin Moncure
  - Re: best way to fetch next/prev record based on index, Tom Lane
  - Re: best way to fetch next/prev record based on index, Greg Stark
- Re: best way to fetch next/prev record based on index, Merlin Moncure
Little understanding for tuning ..., Hervé Piedvache
Timestamp-based indexing, Harmon S. Nine
- Re: Timestamp-based indexing, Kevin Barnard
  - Re: Timestamp-based indexing, Harmon S. Nine
- Re: Timestamp-based indexing, Matthew T. O'Connor
  - Re: Timestamp-based indexing, Harmon S. Nine
  - Re: Timestamp-based indexing, Tom Lane
    - Re: Timestamp-based indexing, Litao Wu
    - Re: Timestamp-based indexing, Tom Lane
    - Re: Timestamp-based indexing, Christopher Kings-Lynne
- Re: Timestamp-based indexing, Stephan Szabo
  - Re: Timestamp-based indexing, Harmon S. Nine
arrays and indexes, Ross J. Reedstrom
- Re: arrays and indexes, Greg Stark
  - Re: arrays and indexes, Ross J. Reedstrom
    - Re: arrays and indexes, Pierre-Frédéric Caillaud
    - Re: arrays and indexes, Greg Stark
    - Re: arrays and indexes, Tom Lane
    - Re: arrays and indexes, Greg Stark
- Re: arrays and indexes, Merlin Moncure
Index type, Ilia Kantor
variable length - user defined types/storage place, martin . bokler
Re: [HACKERS] Wrong index choosen?, Gaetano Mendola
- Re: [HACKERS] Wrong index choosen?, Matthew T. O'Connor
  - Re: [HACKERS] Wrong index choosen?, Jaime Casanova
    - Re: [HACKERS] Wrong index choosen?, Scott Marlowe
  - Re: [HACKERS] Wrong index choosen?, Gaetano Mendola
    - Re: [HACKERS] Wrong index choosen?, Matthew T. O'Connor
Performance over a LAN, William Carney
- Re: Performance over a LAN, Christopher Kings-Lynne
  - Re: Performance over a LAN, Mark Aufflick
    - Re: Performance over a LAN, William Carney
    - Re: Performance over a LAN, Jeff
    - Re: Performance over a LAN, Gary Cowell
- Re: Performance over a LAN, Scott Marlowe
- Re: Performance over a LAN, Rod Taylor
- Re: Performance over a LAN, Michael Adler
- Re: Performance over a LAN, Greg Stark
Beowulf Cluster & Postgresql?, joe
- Re: Beowulf Cluster & Postgresql?, Scott Marlowe
- Re: Beowulf Cluster & Postgresql?, Mark Kirkwood
Unbearably slow cascading deletes, andrew
- Re: Unbearably slow cascading deletes, Stephan Szabo
  - Re: Unbearably slow cascading deletes, Stephan Szabo
- Re: Unbearably slow cascading deletes, Christopher Kings-Lynne
- Re: Unbearably slow cascading deletes, andrew
- Re: Unbearably slow cascading deletes, andrew
Réf. : Re: Réf. : Re: NAS, SAN or any alternate solution ?, bsimon
Réf. : Re: NAS, SAN or any alternate solution ?, bsimon
- Re: Réf. : Re: [PERFORM] NAS,, Mark Kirkwood
- Re: Réf. : Re: NAS, SAN or any, Scott Marlowe
NAS, SAN or any alternate solution ?, bsimon
- Re: NAS, SAN or any alternate solution ?, Scott Marlowe
- Re: NAS, SAN or any alternate solution ?, Grega Bremec
  - Re: NAS, SAN or any alternate solution ?, Grega Bremec
- Re: NAS, SAN or any alternate solution ?, Joe Conway
- Re: NAS, SAN or any alternate solution ?, Rod Taylor
Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver., Gaetano Mendola
Scaling with lazy index updates, Fred Moyer
- Re: Scaling with lazy index updates, Josh Berkus
same plan, different time, Litao Wu
- Re: same plan, different time, Tom Lane
Wierd issues, Andrew Matthews
extrem bad performance, Stefan
- Re: extrem bad performance, Rod Taylor
  - Re: extrem bad performance, Stefan
hardware raid suggestions, Brian Hirt
- Re: hardware raid suggestions, Josh Berkus
- Re: hardware raid suggestions, Mark Aufflick
- Re: hardware raid suggestions, Fred Moyer
- Re: hardware raid suggestions, Gaetano Mendola
vacuum full 100 mins plus?, Patrick Hatcher
- Re: vacuum full 100 mins plus?, Patrick Hatcher
  - Re: vacuum full 100 mins plus?, Josh Berkus
  - Re: vacuum full 100 mins plus?, Christopher Browne
    - Re: vacuum full 100 mins plus?, Tom Lane
    - Re: vacuum full 100 mins plus?, Mike Rylander
Swapping in 7.4.3, Jim Ewert
- Re: Swapping in 7.4.3, Matthew T. O'Connor
- Re: Swapping in 7.4.3, Jim Ewert
  - Re: Swapping in 7.4.3, Scott Marlowe
    - Re: Swapping in 7.4.3, Matt Clark
Insert are going slower ..., Hervé Piedvache
- Re: Insert are going slower ..., Josh Berkus
  - Re: Insert are going slower ..., Hervé Piedvache
    - Re: Insert are going slower ..., gnari
    - Re: Insert are going slower ..., Shridhar Daithankar
    - Re: Insert are going slower ..., Hervé Piedvache
    - Re: Insert are going slower ..., Shridhar Daithankar
    - Re: Insert are going slower ..., Josh Berkus
    - Re: Insert are going slower ..., Hervé Piedvache
    - Re: Insert are going slower ..., Hervé Piedvache
    - Re: Insert are going slower ..., Shridhar Daithankar
    - Re: Insert are going slower ..., Josh Berkus
    - Re: Insert are going slower ..., Hervé Piedvache
    - Re: Insert are going slower ..., Josh Berkus
    - Re: Insert are going slower ..., Gaetano Mendola
    - Re: Insert are going slower ..., Gaetano Mendola
    - Re: Insert are going slower ..., Scott Marlowe
How to create an index for type timestamp column using rtree?, Chris Cheston
- Re: How to create an index for type timestamp column using rtree?, Tom Lane
- Re: How to create an index for type timestamp column using, Christopher Kings-Lynne
  - Re: How to create an index for type timestamp column using rtree?, Chris Cheston
Re: Fw: invitation au "Village du Logiciel Libre" de la, Laurent Martelli
Re: achat borne wifi, Laurent Martelli
Re: Working on huge RAM based datasets, Merlin Moncure
- Re: Working on huge RAM based datasets, Andy Ballingall
- Re: Working on huge RAM based datasets, Jan Wieck
  - Re: Working on huge RAM based datasets, Christopher Browne
    - Re: Working on huge RAM based datasets, Rod Taylor
    - Re: Working on huge RAM based datasets, Josh Berkus
    - Re: Working on huge RAM based datasets, Jan Wieck
- Re: Working on huge RAM based datasets, Merlin Moncure
- Re: Working on huge RAM based datasets, Merlin Moncure
  - Re: Working on huge RAM based datasets, abhousehunt
  - Re: Working on huge RAM based datasets, Andy Ballingall
query plan wierdness?, Joel McGraw
- Re: query plan wierdness?, Stephan Szabo
- Re: query plan wierdness?, Guido Barosio
- Re: query plan wierdness?, Rod Taylor
  - vacuum_mem, Litao Wu
    - Re: vacuum_mem, Rod Taylor
- Re: query plan wierdness?, Joel McGraw
- Re: query plan wierdness?, Joel McGraw
  - Re: query plan wierdness?, Rod Taylor
- Re: query plan wierdness?, Joel McGraw
  - Re: query plan wierdness?, Rod Taylor
Odd sorting behaviour, Steinar H. Gunderson
- Odd sorting behaviour, Steinar H. Gunderson
  - Working on huge RAM based datasets, Andy Ballingall
    - Re: Working on huge RAM based datasets, Christopher Kings-Lynne
    - Re: Working on huge RAM based datasets, Andy Ballingall
    - Re: Working on huge RAM based datasets, Christopher Browne
    - Re: Working on huge RAM based datasets, Andy Ballingall
    - Re: Inverted-list databases (was: Working on huge RAM based datasets), Mischa Sandberg
  - Re: Odd sorting behaviour, Steinar H. Gunderson
  - Re: Odd sorting behaviour, Josh Berkus
    - Re: Odd sorting behaviour, Tom Lane
    - Re: Odd sorting behaviour, Steinar H. Gunderson
    - Re: Odd sorting behaviour, Josh Berkus
    - Re: Odd sorting behaviour, Steinar H. Gunderson
    - Re: Odd sorting behaviour, Steinar H. Gunderson
    - Re: Odd sorting behaviour, Josh Berkus
    - Re: Odd sorting behaviour, Josh Berkus
    - Re: Odd sorting behaviour, Steinar H. Gunderson
    - Re: Odd sorting behaviour, Rod Taylor
    - Re: Odd sorting behaviour, Steinar H. Gunderson
    - Re: Odd sorting behaviour, Rod Taylor
Forcing HashAggregation prior to index scan?, Eugene
- Re: Forcing HashAggregation prior to index scan?, Tom Lane
inserting into brand new database faster than old database, Missner, T. R.
- Re: inserting into brand new database faster than old database, Matthew T. O'Connor
- Re: inserting into brand new database faster than old database, Shridhar Daithankar
- Re: inserting into brand new database faster than old database, Tom Lane
- Re: inserting into brand new database faster than old database, Missner, T. R.
Terrible performance after deleting/recreating indexes, Bill Chandler
- Re: Terrible performance after deleting/recreating indexes, Shridhar Daithankar
  - Re: Terrible performance after deleting/recreating indexes, Bill Chandler
    - Re: Terrible performance after deleting/recreating indexes, Mark Kirkwood
    - Re: Terrible performance after deleting/recreating indexes, Bill Chandler
  - Cursors performance (was: Re: [PERFORM] Terrible performance after deleting/recreating indexes), Bill Chandler
    - Re: Cursors performance (was: Re: [PERFORM] Terrible, Dave Cramer
    - Re: [JDBC] Cursors performance (was: Re: Terrible performance, Kris Jurka
    - Re: Cursors performance, Oliver Jowett
    - Re: Cursors performance, Mark Kirkwood
Implementatiion of Inheritance in Postgres, Ioannis Theoharis
Keyword searching question, borajetta
- Re: Keyword searching question, borajetta
to fsync or not to fsync, Rodrigo Filgueira
- Re: to fsync or not to fsync, Frank Hsueh
  - Re: to fsync or not to fsync (ext3?), Rodrigo Filgueira
Seq scan vs. Index scan with different query conditions, eleven
- Re: Seq scan vs. Index scan with different query conditions, Richard Huxton
- Re: Seq scan vs. Index scan with different query, Andrew McMillan
  - Re: Seq scan vs. Index scan with different query conditions, eleven
    - Re: Seq scan vs. Index scan with different query, Andrew McMillan
Re: BUG #1186: Broken Index?, Bruno Wolff III
- finding a max value, Edoardo Ceccarelli
  - Re: finding a max value, Rosser Schwarz
  - Re: finding a max value, James Antill
Mysterious performance of query because of plsql function in where condition, Peter Alberer
- Re: Mysterious performance of query because of plsql function in where condition, Jeff
- Re: Mysterious performance of query because of plsql function in where condition, Bruno Wolff III
- Re: Mysterious performance of query because of plsql function in, CoL
Query gets slow when where clause increases, James Antill
- Re: Query gets slow when where clause increases, Dennis Bjorklund
network address query, Litao Wu
planner and worst case scenario, Joseph Shraibman
Re: Query performance, Mischa Sandberg
Re: How can one see what queries are running withing a, Roger Ging
- Re: How can one see what queries are running withing a, P.A.M. van Dam