db.postgresql.performance (thread)

Index works with foo.val=bar.val but not foo.val<=bar.val Extremely slow query... my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Re: my boss want to migrate to ORACLE Optimizer refuses to hash join Re: Optimizer refuses to hash join Re: Optimizer refuses to hash join Re: Optimizer refuses to hash join Automagic tuning Re: Automagic tuning best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Correction of best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Re: best way to fetch next/prev record based on index Little understanding for tuning ... Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing Re: Timestamp-based indexing arrays and indexes Re: arrays and indexes Re: arrays and indexes Re: arrays and indexes Re: arrays and indexes Re: arrays and indexes Re: arrays and indexes Re: arrays and indexes Index type variable length - user defined types/storage place Re: [HACKERS] Wrong index choosen? Re: [HACKERS] Wrong index choosen? Re: [HACKERS] Wrong index choosen? Re: [HACKERS] Wrong index choosen? Re: [HACKERS] Wrong index choosen? Re: [HACKERS] Wrong index choosen? Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Re: Performance over a LAN Beowulf Cluster & Postgresql? Re: Beowulf Cluster & Postgresql? Re: Beowulf Cluster & Postgresql? Unbearably slow cascading deletes Re: Unbearably slow cascading deletes Re: Unbearably slow cascading deletes Re: Unbearably slow cascading deletes Re: Unbearably slow cascading deletes Re: Unbearably slow cascading deletes Réf. : Re: Réf. : Re: NAS, SAN or any alternate solution ? Réf. : Re: NAS, SAN or any alternate solution ? Re: Réf. : Re: [PERFORM] NAS, Re: Réf. : Re: NAS, SAN or any NAS, SAN or any alternate solution ? Re: NAS, SAN or any alternate solution ? Re: NAS, SAN or any alternate solution ? Re: NAS, SAN or any alternate solution ? Re: NAS, SAN or any alternate solution ? Re: NAS, SAN or any alternate solution ? Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Scaling with lazy index updates Re: Scaling with lazy index updates same plan, different time Re: same plan, different time Wierd issues extrem bad performance Re: extrem bad performance Re: extrem bad performance hardware raid suggestions Re: hardware raid suggestions Re: hardware raid suggestions Re: hardware raid suggestions Re: hardware raid suggestions vacuum full 100 mins plus? Re: vacuum full 100 mins plus? Re: vacuum full 100 mins plus? Re: vacuum full 100 mins plus? Re: vacuum full 100 mins plus? Re: vacuum full 100 mins plus? Swapping in 7.4.3 Re: Swapping in 7.4.3 Re: Swapping in 7.4.3 Re: Swapping in 7.4.3 Re: Swapping in 7.4.3 Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... Re: Insert are going slower ... How to create an index for type timestamp column using rtree? Re: How to create an index for type timestamp column using rtree? Re: How to create an index for type timestamp column using Re: How to create an index for type timestamp column using rtree? Re: Fw: invitation au "Village du Logiciel Libre" de la Re: achat borne wifi Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets query plan wierdness? Re: query plan wierdness? Re: query plan wierdness? Re: query plan wierdness? vacuum_mem Re: vacuum_mem Re: query plan wierdness? Re: query plan wierdness? Re: query plan wierdness? Re: query plan wierdness? Re: query plan wierdness? Odd sorting behaviour Odd sorting behaviour Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Working on huge RAM based datasets Re: Inverted-list databases (was: Working on huge RAM based datasets) Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Re: Odd sorting behaviour Forcing HashAggregation prior to index scan? Re: Forcing HashAggregation prior to index scan? inserting into brand new database faster than old database Re: inserting into brand new database faster than old database Re: inserting into brand new database faster than old database Re: inserting into brand new database faster than old database Re: inserting into brand new database faster than old database Terrible performance after deleting/recreating indexes Re: Terrible performance after deleting/recreating indexes Re: Terrible performance after deleting/recreating indexes Re: Terrible performance after deleting/recreating indexes Re: Terrible performance after deleting/recreating indexes Cursors performance (was: Re: [PERFORM] Terrible performance after deleting/recreating indexes) Re: Cursors performance (was: Re: [PERFORM] Terrible Re: [JDBC] Cursors performance (was: Re: Terrible performance Re: Cursors performance Re: Cursors performance Implementatiion of Inheritance in Postgres Keyword searching question Re: Keyword searching question to fsync or not to fsync Re: to fsync or not to fsync Re: to fsync or not to fsync (ext3?) Seq scan vs. Index scan with different query conditions Re: Seq scan vs. Index scan with different query conditions Re: Seq scan vs. Index scan with different query Re: Seq scan vs. Index scan with different query conditions Re: Seq scan vs. Index scan with different query Re: BUG #1186: Broken Index? finding a max value Re: finding a max value Re: finding a max value Mysterious performance of query because of plsql function in where condition Re: Mysterious performance of query because of plsql function in where condition Re: Mysterious performance of query because of plsql function in where condition Re: Mysterious performance of query because of plsql function in Query gets slow when where clause increases Re: Query gets slow when where clause increases network address query planner and worst case scenario Re: Query performance Re: How can one see what queries are running withing a Re: How can one see what queries are running withing a