Mailing lists [pgsql-performance]
- Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test Andy
- Re: Suggestions for Intel 710 SSD test Gregory Gerard
- Re: Suggestions for Intel 710 SSD test Arjen van der Meijden
- Eduardo Nazor
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test Gregory Gerard
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test Greg Smith
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test David Boreham
- Re: Suggestions for Intel 710 SSD test Gregory Gerard
- Re: Suggestions for Intel 710 SSD test David Boreham
- Query with order by and limit is very slow - wrong index used Nowak Michał
- Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz
- Re: Query with order by and limit is very slow - wrong index used Nowak Michał
- Re: : Performance Improvement Strategy Venkat Balaji
- Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz
- Fwd: Query with order by and limit is very slow - wrong index used Nowak Michał
- Re: Query with order by and limit is very slow - wrong index used Nowak Michał
- How can i get record by data block not by sql? 姜头
- Re: How can i get record by data block not by sql? Ben Chobot
- Re: Query with order by and limit is very slow - wrong index used Cédric Villemain
- Re: Query with order by and limit is very slow - wrong index used Tom Lane
- Re: : Performance Improvement Strategy Kevin Grittner
- Re: : Performance Improvement Strategy Venkat Balaji
- Re: Query with order by and limit is very slow - wrong index used Marcin Mańk
- Re: Query with order by and limit is very slow - wrong index used Nowak Michał
- Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz
- Re: Query with order by and limit is very slow - wrong index used Nowak Michał
- Window functions and index usage Anssi Kääriäinen
- : Column Performance in a query Venkat Balaji
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Heikki Linnakangas
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji
- pkey is not used on productive database Soporte @ TEKSOL S.A.
- Re: array_except -- Find elements that are not common to both arrays Gavin Flower
- Re: pkey is not used on productive database hubert depesz lubaczewski
- Re: pkey is not used on productive database Scott Marlowe
- Re: Window functions and index usage Robert Klemme
- Re: Window functions and index usage Anssi Kääriäinen
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter pasman pasmański
- Re: Window functions and index usage Tom Lane
- Re: Window functions and index usage Anssi Kääriäinen
- Re: Window functions and index usage Anssi Kääriäinen
- Re: Window functions and index usage Robert Klemme
- Re: array_except -- Find elements that are not common to both arrays Merlin Moncure
- Re: : Column Performance in a query Ondrej Ivanič
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Scott Marlowe
- Re: Query with order by and limit is very slow - wrong index used Kevin Grittner
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith
- Re: : Performance Improvement Strategy Venkat Balaji
- Re: : Performance Improvement Strategy Raghavendra
- Re: : Performance Improvement Strategy Guillaume Cottenceau
- Re: : Performance Improvement Strategy Kevin Grittner
- Re: : Performance Improvement Strategy Scott Marlowe
- Re: : Performance Improvement Strategy Tom Lane
- Intel 710 Endurance Test Results David Boreham
- Re: Allow sorts to use more available memory Bruce Momjian
- pg9 replication over WAN ? Ben Ciceron
- Re: : Performance Improvement Strategy Raghavendra
- Re: : Performance Improvement Strategy Scott Marlowe
- Re: pg9 replication over WAN ? mark
- Performance problem with a table with 38928077 record Giovanni Mancuso
- Re: Performance problem with a table with 38928077 record Guillaume Cottenceau
- Re: Performance problem with a table with 38928077 record Gregg Jaskiewicz
- Re: Performance problem with a table with 38928077 record Cédric Villemain
- Re: Performance problem with a table with 38928077 record Giovanni Mancuso
- Re: PostgreSQL-9.0 Monitoring System to improve performance Fernando Hevia
- Re: PostgreSQL-9.0 Monitoring System to improve performance Ben Ciceron
- Re: Performance problem with a table with 38928077 record Giovanni Mancuso
- Re: : Performance Improvement Strategy Leonardo Francalanci
- Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load Kevin Grittner
- Re: Adding more memory = hugh cpu load Shaun Thomas
- Re: Adding more memory = hugh cpu load Leonardo Francalanci
- Re: Adding more memory = hugh cpu load Shaun Thomas
- Re: Adding more memory = hugh cpu load Greg Smith
- Re: Adding more memory = hugh cpu load Leonardo Francalanci
- Re: Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load Kevin Grittner
- Re: Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load Kevin Grittner
- Re: Adding more memory = hugh cpu load Shaun Thomas
- Re: Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load Kevin Grittner
- Re: Adding more memory = hugh cpu load Samuel Gendler
- Re: Adding more memory = hugh cpu load Claudio Freire
- Re: Adding more memory = hugh cpu load Greg Smith
- Re: Adding more memory = hugh cpu load Greg Smith
- Re: Adding more memory = hugh cpu load Leonardo Francalanci
- Rapidly finding maximal rows James Cranch
- Re: Adding more memory = hugh cpu load Ivan Voras
- Re: Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load Luca Tettamanti
- Re: Adding more memory = hugh cpu load Greg Smith
- Query tuning help CS DBA
- Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital
- Re: Query tuning help Pavel Stehule
- Re: Query tuning help Szymon Guz
- Re: Adding more memory = hugh cpu load [solved] Claudio Freire
- Re: Query tuning help CS DBA
- Re: should i expected performance degradation over time Anibal David Acosta
- Re: Query tuning help CS DBA
- Re: Query tuning help Pavel Stehule
- postgresql query runtime Radhya sahal
- Re: postgresql query runtime Pavel Stehule
- Re: postgresql query runtime Szymon Guz
- Re: postgresql query runtime Szymon Guz
- Re: postgresql query runtime Kevin Grittner
- Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital
- Re: Adding more memory = hugh cpu load [solved] Claudio Freire
- Re: Adding more memory = hugh cpu load [solved] Arjen van der Meijden
- Re: Adding more memory = hugh cpu load [solved] Claudio Freire
- Re: postgresql query runtime Radhya sahal
- Re: postgresql query runtime Kevin Grittner
- Composite keys Carlo Stonebanks
- Re: Rapidly finding maximal rows bricklen
- Re: Composite keys Claudio Freire
- Re: Rapidly finding maximal rows Dave Crooke
- Re: Composite keys Dave Crooke
- Re: Composite keys Carlo Stonebanks
- Re: Composite keys Greg Smith
- Re: Rapidly finding maximal rows James Cranch
- Re: Rapidly finding maximal rows James Cranch
- Rapidly finding maximal rows James Cranch
- Tablespace files deleted automatically. Vishnu S.
- Re: Slow query when using ORDER BY *and* LIMIT davidsarmstrong
- Join over two tables of 50K records takes 2 hours Svetlin Manavski
- Re: Rapidly finding maximal rows Tom Lane
- Re: Join over two tables of 50K records takes 2 hours Tom Lane
- Re: Join over two tables of 50K records takes 2 hours Scott Marlowe
- SSD options, small database, ZFS CSS
- Re: Join over two tables of 50K records takes 2 hours Scott Marlowe
- Re: Join over two tables of 50K records takes 2 hours Svetlin Manavski
- Re: SSD options, small database, ZFS Arjen van der Meijden
- Re: Tablespace files deleted automatically. Josh Berkus
- Re: Slow query when using ORDER BY *and* LIMIT Michael Viscuso
- Bad plan by Planner (Already resolved?) Robins Tharakan
- Optimize the database performance Micka
- Re: Optimize the database performance MirrorX
- Re: Tablespace files deleted automatically. Robert Klemme
- Re: Bad plan by Planner (Already resolved?) Kevin Grittner
- Re: Optimize the database performance Andy Colson
- Re: Optimize the database performance Cédric Villemain
- Re: Bad plan by Planner (Already resolved?) Robins Tharakan
- Re: Bad plan by Planner (Already resolved?) Mark Kirkwood
- Re: Bad plan by Planner (Already resolved?) Kevin Grittner
- Heavy contgnous load kzsolt
- Re: Heavy contgnous load Kevin Grittner
- Re: Heavy contgnous load Craig Ringer
- How many Cluster database on a single server d.davolio@mastertraining.it
- Inner Join - Explicit vs Implicit Join Performance Gnanakumar
- Re: Inner Join - Explicit vs Implicit Join Performance Pavel Stehule
- Re: How many Cluster database on a single server Craig James
- Re: Rapidly finding maximal rows Merlin Moncure
- Re: How many Cluster database on a single server d.davolio@mastertraining.it
- Re: How many Cluster database on a single server Kevin Grittner
- Re: How many Cluster database on a single server Scott Marlowe
- does update of column with no relation imply a relation check of other column? Anibal David Acosta
- Re: does update of column with no relation imply a relation check of other column? Greg Jaskiewicz
- delete/recreate indexes alan
- disused indexes and performance? Elisa
- Re: Heavy contgnous load kzsolt
- Re: Heavy contgnous load kzsolt
- Re: disused indexes and performance? Scott Marlowe
- Re: delete/recreate indexes Jeff Davis
- Re: How many Cluster database on a single server Craig Ringer
- Re: Heavy contgnous load Craig Ringer
- Re: delete/recreate indexes Bort, Paul
- Re: Heavy contgnous load Jeff Janes
- Re: How many Cluster database on a single server d.davolio@mastertraining.it
- 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley
- explain workload Radhya sahal
- Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane
- Re: 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley
- hstore query: Any better idea than adding more memory? Stefan Keller
- Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane
- Re: Heavy contgnous load kzsolt
- Re: explain workload Robins Tharakan
- Re: explain workload Tom Lane
- Re: hstore query: Any better idea than adding more memory? Stephen Frost
- Re: hstore query: Any better idea than adding more memory? Stefan Keller
- Re: hstore query: Any better idea than adding more memory? Stephen Frost
- Usage of pg_stat_database Amitabh Kant
- Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji
- Re: Tsearch2 - bad performance with concatenated ts-vectors Robert Haas
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Merlin Moncure
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Robert Haas
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham
- Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji
- Re: delete/recreate indexes alan
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Thilo Raufeisen
- Query running a lot faster with enable_nestloop=false Mohanaraj Gopala Krishnan
- Re: Query running a lot faster with enable_nestloop=false Robins Tharakan
- Re: Bad plan by Planner (Already resolved?) Robins Tharakan
- sub Cezariusz Marek
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham
- CTE vs Subquery Linos
- Re: CTE vs Subquery Tom Lane
- Re: CTE vs Subquery Linos
- Re: CTE vs Subquery Merlin Moncure
- how to use explain analyze alan
- Re: how to use explain analyze Julius Tuskenis
- Re: CTE vs Subquery Linos
- Anti join miscalculates row number? Jens Reufsteck
- Re: CTE vs Subquery Merlin Moncure
- Slow cursor Cezariusz Marek
- Re: Slow cursor Gregg Jaskiewicz
- Re: CTE vs Subquery Linos
- Re: Slow cursor Cezariusz Marek
- Re: Slow cursor Andres Freund
- Re: Anti join miscalculates row number? Tom Lane
- Re: Bad plan by Planner (Already resolved?) Tom Lane
- Re: Anti join miscalculates row number? Julius Tuskenis
- PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler
- Re: PostgreSQL 9.0.4 blocking in lseek? Gregg Jaskiewicz
- Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler
- Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire
- backups blocking everything Samuel Gendler
- Re: backups blocking everything Merlin Moncure
- Re: Shortcutting too-large offsets? Robert Haas
- Re: Performance problem with a table with 38928077 record Robert Haas
- Re: backups blocking everything Samuel Gendler
- Re: Performance problem with a table with 38928077 record Shaun Thomas
- Re: backups blocking everything Nicholson, Brad (Toronto, ON, CA)
- Re: Performance problem with a table with 38928077 record Tom Lane
- Re: backups blocking everything Samuel Gendler
- Re: PostgreSQL 9.0.4 blocking in lseek? Tom Lane
- Re: PostgreSQL 9.0.4 blocking in lseek? Josh Berkus
- function slower than the same code in an sql file CS DBA
- Re: function slower than the same code in an sql file Tom Lane
- Re: function slower than the same code in an sql file Pavel Stehule
- Re: Usage of pg_stat_database Jeff Davis
- Re: Usage of pg_stat_database Amitabh Kant
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant
- Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Gregg Jaskiewicz
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- SSL encryption makes bytea transfer slow Albe Laurenz
- Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham
- Re: function slower than the same code in an sql file CS DBA
- WAL in RAM Marcus Engene
- Re: WAL in RAM Kevin Grittner
- Re: [GENERAL] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Alban Hertroys
- Re: WAL in RAM Merlin Moncure
- Strange query plan Sorbara, Giorgio (CIOK)
- Re: Strange query plan Tomas Vondra
- Re: WAL in RAM Tomas Vondra
- Re: WAL in RAM Merlin Moncure
- Re: should i expected performance degradation over time Robert Haas
- Re: WAL in RAM Tomas Vondra
- Re: WAL in RAM Tomas Vondra
- Re: WAL in RAM Claudio Freire
- Re: WAL in RAM David Boreham
- Re: backups blocking everything Merlin Moncure
- Re: backups blocking everything Samuel Gendler
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: SSL encryption makes bytea transfer slow Heikki Linnakangas
- Re: Bad plan by Planner (Already resolved?) Robins Tharakan
- Re: application of KNN code to US zipcode searches? Mark Stosberg
- Re: WAL in RAM Marcus Engene
- Re: WAL in RAM Scott Marlowe
- Re: Strange query plan Sorbara, Giorgio (CIOK)
- Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler
- Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler
- Re: PostgreSQL 9.0.4 blocking in lseek? Tom Lane
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler
- Re: Composite keys Robert Haas
- Re: Anti join miscalculates row number? Jens Reufsteck
- Re: Composite keys Claudio Freire
- Re: does update of column with no relation imply a relation check of other column? Robert Haas
- Re: Composite keys Robert Haas
- Re: Composite keys Claudio Freire
- Re: Composite keys Robert Haas
- Re: SSL encryption makes bytea transfer slow Merlin Moncure
- Re: Composite keys Tom Lane
- Re: does update of column with no relation imply a relation check of other column? Tom Lane