Mailing lists [pgsql-performance]
- Re: Load and Stress on PostgreSQL 9.0 Selva manickaraja
- Re: inheritance: planning time vs children number vs column number Tom Lane
- Re: inheritance: planning time vs children number vs column number Marc Cousin
- Two different execution plans for similar requests Joby Joba
- Re: Two different execution plans for similar requests tv@fuzzy.cz
- Re: Two different execution plans for similar requests Joby Joba
- Re: Two different execution plans for similar requests tv@fuzzy.cz
- Re: Two different execution plans for similar requests Joby Joba
- Re: Two different execution plans for similar requests Joby Joba
- Re: inheritance: planning time vs children number vs column number Tom Lane
- Re: Talking about optimizer, my long dream Merlin Moncure
- Re: inheritance: planning time vs children number vs column number Marc Cousin
- Re: Two different execution plans for similar requests Maciek Sakrejda
- Re: inheritance: planning time vs children number vs column number Tom Lane
- Performance trouble finding records through related records sverhagen
- Re: Performance trouble finding records through related records Andy Colson
- Re: Pushing IN (subquery) down through UNION ALL? Robert Haas
- Re: Pushing IN (subquery) down through UNION ALL? Thom Brown
- Re: Pushing IN (subquery) down through UNION ALL? Robert Haas
- Re: Pushing IN (subquery) down through UNION ALL? Thom Brown
- Re: Anyone tried Flashcache with PostgreSQL? Robert Haas
- Re: Query on view radically slower than query on underlying table Robert Haas
- Re: Vacuum problem due to temp tables Robert Haas
- Re: Performance Test for PostgreSQL9 Robert Haas
- Re: Performance Test for PostgreSQL9 Joshua D. Drake
- Re: Performance trouble finding records through related records sverhagen
- Re: Anyone tried Flashcache with PostgreSQL? Samuel Gendler
- Re: Performance Test for PostgreSQL9 Selva manickaraja
- Re: Performance trouble finding records through related records Andy Colson
- Re: Performance Test for PostgreSQL9 Greg Smith
- Is it require further tuning Adarsh Sharma
- Re: Performance Test for PostgreSQL9 Selva manickaraja
- Re: Performance Test for PostgreSQL9 Joshua D. Drake
- Re: Anyone tried Flashcache with PostgreSQL? Arjen van der Meijden
- Re: Is Query need to be optimized Grzegorz Jaśkiewicz
- Re: Performance trouble finding records through related records sverhagen
- Slowing UPDATEs inside a transaction Matt Burke
- Re: Slowing UPDATEs inside a transaction Robert Haas
- Re: Performance trouble finding records through related records Andy Colson
- Re: Slowing UPDATEs inside a transaction Merlin Moncure
- Re: Slowing UPDATEs inside a transaction Matt Burke
- Re: Vacuum problem due to temp tables Vidhya Bondre
- Slow join on partitioned table Mark Thornton
- Re: Vacuum problem due to temp tables Robert Haas
- Re: Slowing UPDATEs inside a transaction Robert Haas
- Re: Slowing UPDATEs inside a transaction Merlin Moncure
- Re: Is it require further tuning Robert Haas
- Calculating 95th percentiles Landreville
- Re: Slow join on partitioned table Robert Haas
- Re: Slow join on partitioned table Mark Thornton
- Re: Slow join on partitioned table Mark Thornton
- Linux I/O schedulers - CFQ & random seeks Glyn Astill
- Re: Linux I/O schedulers - CFQ & random seeks Wayne Conrad
- Re: Slow join on partitioned table Robert Haas
- Re: Linux I/O schedulers - CFQ & random seeks Dan Harris
- Re: Linux I/O schedulers - CFQ & random seeks Scott Marlowe
- Re: Linux I/O schedulers - CFQ & random seeks Kevin Grittner
- Re: Linux I/O schedulers - CFQ & random seeks Rosser Schwarz
- Re: Calculating 95th percentiles Pierre C
- Table partitioning Tobias Brox
- Re: Table partitioning Mark Thornton
- Re: Table partitioning Tobias Brox
- Re: Calculating 95th percentiles marcin mank
- Re: Linux I/O schedulers - CFQ & random seeks Omar Kilani
- Re: Table partitioning Mark Thornton
- Performance issues Andreas Forø Tollefsen
- Re: Performance issues Kenneth Marshall
- Re: Performance issues Andreas Forø Tollefsen
- Re: Performance issues Kenneth Marshall
- Re: Performance issues Andreas Forø Tollefsen
- Re: Performance issues Oleg Bartunov
- Re: Anyone tried Flashcache with PostgreSQL? Cédric Villemain
- plan variations: join vs. exists vs. row comparison Jon Nelson
- Re: Performance trouble finding records through related records Robert Haas
- Re: plan variations: join vs. exists vs. row comparison Tom Lane
- Re: plan variations: join vs. exists vs. row comparison Merlin Moncure
- Re: plan variations: join vs. exists vs. row comparison Jon Nelson
- Re: plan variations: join vs. exists vs. row comparison Kevin Grittner
- Re: Performance trouble finding records through related records Merlin Moncure
- Re: Query performance with disabled hashjoin and mergejoin Merlin Moncure
- Re: Performance issues Andreas Forø Tollefsen
- Re: Performance issues David Kerr
- Re: Performance issues Tom Lane
- How to tune this query Adarsh Sharma
- Re: [GENERAL] How to tune this query Jaiswal Dhaval Sudhirkumar
- Re: Performance issues Andreas Forø Tollefsen
- Re: Performance trouble finding records through related records sverhagen
- Re: Performance trouble finding records through related records sverhagen
- Re: Performance issues Andy Colson
- Table partitioning problem Samba GUEYE
- Re: Performance issues Andreas Forø Tollefsen
- Re: Performance issues Andreas Forø Tollefsen
- Re: Linux I/O schedulers - CFQ & random seeks Mindaugas Riauba
- Re: Performance issues Andy Colson
- Re: Query performance with disabled hashjoin and mergejoin Robert Haas
- Re: Query performance with disabled hashjoin and mergejoin Tom Lane
- Re: Query performance with disabled hashjoin and mergejoin Merlin Moncure
- Re: Query performance with disabled hashjoin and mergejoin Robert Haas
- Re: Table partitioning problem Jim Nasby
- Re: Slow join on partitioned table Conor Walsh
- Re: NULLS LAST performance Jim Nasby
- Re: Table partitioning problem Samba GUEYE
- Re: Performance trouble finding records through related records sverhagen
- Re: NULLS LAST performance Robert Haas
- Tuning massive UPDATES and GROUP BY's? fork
- Re: NULLS LAST performance Merlin Moncure
- Re: Tuning massive UPDATES and GROUP BY's? Merlin Moncure
- Basic performance tuning on dedicated server runner
- unexpected stable function behavior Julius Tuskenis
- Re: Basic performance tuning on dedicated server Merlin Moncure
- Re: Tuning massive UPDATES and GROUP BY's? fork
- Re: unexpected stable function behavior Merlin Moncure
- big joins not converging Dan Ancona
- Re: big joins not converging Steve Atkins
- Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp
- Re: big joins not converging fork
- Re: big joins not converging Dan Ancona
- Re: NULLS LAST performance Robert Haas
- ANTI-JOIN needs table, index scan not possible? hans wulf
- Re: big joins not converging fork
- Re: ANTI-JOIN needs table, index scan not possible? Maciek Sakrejda
- Re: Table partitioning problem Robert Haas
- Re: Tuning massive UPDATES and GROUP BY's? fork
- Re: ANTI-JOIN needs table, index scan not possible? hans wulf
- Re: ANTI-JOIN needs table, index scan not possible? Kenneth Marshall
- Re: ANTI-JOIN needs table, index scan not possible? Kevin Grittner
- Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp
- Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 John Surcombe
- Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Jeremy
- Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane
- Re: Tuning massive UPDATES and GROUP BY's? runner
- Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane
- Re: Tuning massive UPDATES and GROUP BY's? Marti Raudsepp
- Re: Tuning massive UPDATES and GROUP BY's? Greg Spiegelberg
- Re: unexpected stable function behavior Merlin Moncure
- Re: unexpected stable function behavior Andres Freund
- Re: Performance regression from 8.3.7 to 9.0.3 Claudio Freire
- Re: Tuning massive UPDATES and GROUP BY's? runner
- Re: Table partitioning problem Samba GUEYE
- Re: unexpected stable function behavior Julius Tuskenis
- Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 John Surcombe
- Re: unexpected stable function behavior Tom Lane
- Bug in the planner? Claudio Freire
- Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Tom Lane
- Re: Performance regression from 8.3.7 to 9.0.3 Merlin Moncure
- Re: Performance regression from 8.3.7 to 9.0.3 Merlin Moncure
- Re: Performance regression from 8.3.7 to 9.0.3 Tom Lane
- Re: Table partitioning problem Robert Haas
- Re: Table partitioning problem Conor Walsh
- Re: Bug in the planner? Tom Lane
- Re: unexpected stable function behavior Julius Tuskenis
- Re: unexpected stable function behavior Julius Tuskenis
- Re: Table partitioning problem Samba GUEYE
- Re: Index use difference betweer LIKE, LIKE ANY? Chetan Suttraway
- Re: Table partitioning problem Shaun Thomas
- Re: Table partitioning problem Samba GUEYE
- big distinct clause vs. group by Uwe Bartels
- Custom operator class costs Ben Beecher
- pg_xlog size Tech Madhu
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett
- Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett
- Help with Query Tuning Adarsh Sharma
- Re: Help with Query Tuning Kenneth Marshall
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner
- Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Tom Lane
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Shaun Thomas
- Re: Help with Query Tuning Reid Thompson
- Re: pg_xlog size Euler Taveira de Oliveira
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Tom Lane
- Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner
- Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Shaun Thomas
- Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Claudio Freire
- Updating histogram_bounds after a delete Derrick Rice
- Re: Updating histogram_bounds after a delete Derrick Rice
- Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner
- Re: Updating histogram_bounds after a delete Kevin Grittner
- Re: pg_xlog size Fujii Masao
- Re: Help with Query Tuning Adarsh Sharma
- Re: Help with Query Tuning Adarsh Sharma
- Re: Help with Query Tuning tv@fuzzy.cz
- Re: pg_xlog size Tech Madhu
- Re: Updating histogram_bounds after a delete Derrick Rice
- Re: Updating histogram_bounds after a delete Kevin Grittner
- Re: Updating histogram_bounds after a delete Kenneth Marshall
- Re: Updating histogram_bounds after a delete Tom Lane
- Re: Updating histogram_bounds after a delete Kevin Grittner
- Xeon twice the performance of opteron Jeff
- Re: Xeon twice the performance of opteron J Sisson
- Re: Xeon twice the performance of opteron Claudio Freire
- Re: Xeon twice the performance of opteron Craig James
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Kevin Grittner
- Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 Timothy Garnett
- Fastest pq_restore? Michael Andreasen
- Request for feedback on hardware for a new database server Oliver Charles
- Re: Fastest pq_restore? Andy Colson
- Re: Xeon twice the performance of opteron mark
- Re: Xeon twice the performance of opteron Scott Marlowe
- Re: Request for feedback on hardware for a new database server Steve Atkins
- Re: Request for feedback on hardware for a new database server Scott Marlowe
- Re: Help with Query Tuning Adarsh Sharma
- Re: Request for feedback on hardware for a new database server Jesper Krogh
- Disabling nested loops - worst case performance Anssi Kääriäinen
- Re: Disabling nested loops - worst case performance Pavel Stehule
- Re: Request for feedback on hardware for a new database server Arjen van der Meijden
- Re: Request for feedback on hardware for a new database server Scott Marlowe
- Re: Disabling nested loops - worst case performance Anssi Kääriäinen
- Re: Disabling nested loops - worst case performance Vitalii Tymchyshyn
- Re: Disabling nested loops - worst case performance Thomas Kellerer
- Re: Disabling nested loops - worst case performance Anssi Kääriäinen
- Re: Disabling nested loops - worst case performance Anssi Kääriäinen
- Re: Xeon twice the performance of opteron Jeff
- Re: Request for feedback on hardware for a new database server Arjen van der Meijden
- Re: Help with Query Tuning Reid Thompson
- Help: massive parallel update to the same table Red Maple
- Re: Help: massive parallel update to the same table Kevin Grittner
- Re: Help: massive parallel update to the same table Nicholson, Brad (Toronto, ON, CA)
- Re: Fastest pq_restore? Kevin Grittner
- Re: Disabling nested loops - worst case performance Claudio Freire
- Re: Help with Query Tuning tv@fuzzy.cz
- Re: Request for feedback on hardware for a new database server Claudio Freire
- Re: Help: massive parallel update to the same table Kevin Grittner
- Re: Request for feedback on hardware for a new database server Scott Marlowe
- Re: Help: massive parallel update to the same table Red Maple
- Re: Fastest pq_restore? Andy Colson
- Re: Help: massive parallel update to the same table Kevin Grittner
- Re: Request for feedback on hardware for a new database server Scott Marlowe
- REINDEX takes half a day (and still not complete!) Phoenix Kiula
- Re: REINDEX takes half a day (and still not complete!) Scott Marlowe
- Re: REINDEX takes half a day (and still not complete!) Scott Marlowe
- Performance on AIX phb07
- Re: Performance on AIX Andy Colson
- Re: Fastest pq_restore? bricklen
- Select in subselect vs select = any array Adam Tistler
- Re: Select in subselect vs select = any array Pavel Stehule
- Re: REINDEX takes half a day (and still not complete!) Phoenix Kiula
- Re: Select in subselect vs select = any array Adam Tistler
- Re: Select in subselect vs select = any array Pavel Stehule
- Re: Select in subselect vs select = any array Adam Tistler
- Re: Select in subselect vs select = any array Pavel Stehule
- Re: REINDEX takes half a day (and still not complete!) Merlin Moncure
- Re: REINDEX takes half a day (and still not complete!) Scott Marlowe
- Re: Select in subselect vs select = any array mark
- Re: Request for feedback on hardware for a new database server Merlin Moncure
- Re: Help: massive parallel update to the same table Red Maple
- Analyze on temp table taking very long Mahadevan, Mridula
- Re: Performance on AIX Josh Berkus
- Re: Analyze on temp table taking very long Tom Lane
- good old VACUUM FULL felix
- Re: good old VACUUM FULL Chris
- Re: ANTI-JOIN needs table, index scan not possible? Robert Haas
- Re: good old VACUUM FULL Scott Marlowe
- Reason of Slowness of query Adarsh Sharma
- Re: Reason of Slowness of query Chetan Suttraway
- Re: Reason of Slowness of query Samuel Gendler
- Re: Reason of Slowness of query Vitalii Tymchyshyn
- Re: Reason of Slowness of query Adarsh Sharma
- Re: Reason of Slowness of query Chetan Suttraway
- Re: Reason of Slowness of query Vitalii Tymchyshyn
- Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn
- Re: Re-Reason of Slowness of Query tv@fuzzy.cz
- Re: Re-Reason of Slowness of Query Chetan Suttraway
- Re: Re-Reason of Slowness of Query Chetan Suttraway
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn
- Re: Re-Reason of Slowness of Query Chetan Suttraway
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Re-Reason of Slowness of Query tv@fuzzy.cz
- buffercache/bgwriter Uwe Bartels
- Re: good old VACUUM FULL Shaun Thomas
- Re: buffercache/bgwriter Jochen Erwied
- Re: Re-Reason of Slowness of Query Shaun Thomas
- Re: buffercache/bgwriter Uwe Bartels
- Re: Re-Reason of Slowness of Query tv@fuzzy.cz
- Re: Re-Reason of Slowness of Query Shaun Thomas
- Re: buffercache/bgwriter tv@fuzzy.cz
- Re: buffercache/bgwriter Uwe Bartels
- Re: buffercache/bgwriter Nicholson, Brad (Toronto, ON, CA)
- Re: buffercache/bgwriter Uwe Bartels
- Re: buffercache/bgwriter Jeff Janes
- Re: buffercache/bgwriter Uwe Bartels
- Re: buffercache/bgwriter Jeff Janes
- Shouldn't we have a way to avoid "risky" plans? Josh Berkus
- Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire
- Re: buffercache/bgwriter Cédric Villemain
- Re: Shouldn't we have a way to avoid "risky" plans? Josh Berkus
- Slow query on CLUTER -ed tables Laszlo Nagy
- Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire
- Re: Shouldn't we have a way to avoid "risky" plans? Justin Pitts
- Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane
- Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire
- Re: Slow query on CLUTER -ed tables Marti Raudsepp
- Re: Shouldn't we have a way to avoid "risky" plans? Josh Berkus
- pg9.0.3 explain analyze running very slow compared to a different box with much less configuration DM
- Re: Re-Reason of Slowness of Query Adarsh Sharma
- Re: Shouldn't we have a way to avoid "risky" plans? Віталій Тимчишин
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Achilleas Mantzios
- Re: buffercache/bgwriter Uwe Bartels
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Marti Raudsepp
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Achilleas Mantzios
- maintenance_work_mem + create index Uwe Bartels
- Re: maintenance_work_mem + create index Stephen Frost
- Re: maintenance_work_mem + create index Uwe Bartels
- Re: maintenance_work_mem + create index Shaun Thomas
- Re: maintenance_work_mem + create index Uwe Bartels
- Re: maintenance_work_mem + create index Shaun Thomas
- Re: maintenance_work_mem + create index Euler Taveira de Oliveira
- Re: Shouldn't we have a way to avoid "risky" plans? Merlin Moncure
- Re: Shouldn't we have a way to avoid "risky" plans? Nathan Boley
- Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration DM
- Why Index is not used Adarsh Sharma
- Re: Why Index is not used Andreas Kretschmer
- Re: Why Index is not used Adarsh Sharma
- Re: Why Index is not used Chetan Suttraway
- Re: Why Index is not used Adarsh Sharma
- Re: Why Index is not used Thomas Kellerer
- Re: Why Index is not used Chetan Suttraway
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Marti Raudsepp
- Re: Why Index is not used Adarsh Sharma
- Re: Why Index is not used Chetan Suttraway
- Re: Why Index is not used tv@fuzzy.cz
- Re: Shouldn't we have a way to avoid "risky" plans? Vitalii Tymchyshyn
- Re: Why Index is not used Adarsh Sharma
- Re: Slow query on CLUTER -ed tables Laszlo Nagy
- Re: Why Index is not used Shaun Thomas
- Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane
- Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane
- Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Strange, John W
- Re: Shouldn't we have a way to avoid "risky" plans? Vitalii Tymchyshyn
- Re: Why Index is not used Maciek Sakrejda
- Re: Shouldn't we have a way to avoid "risky" plans? Scott Carey
- Re: Shouldn't we have a way to avoid "risky" plans? Nathan Boley
- Re: Shouldn't we have a way to avoid "risky" plans? Joshua Berkus
- Re: buffercache/bgwriter Greg Smith
- Re: Xeon twice the performance of opteron Greg Smith
- Intel SSDs that may not suck Greg Smith
- Re: buffercache/bgwriter Uwe Bartels
- Re: Intel SSDs that may not suck Andy
- Re: Intel SSDs that may not suck Merlin Moncure
- Re: Intel SSDs that may not suck Jesper Krogh
- Re: Intel SSDs that may not suck Scott Marlowe
- Re: Analyze on temp table taking very long Mahadevan, Mridula
- Re: Intel SSDs that may not suck Justin Pitts
- Re: Intel SSDs that may not suck Yeb Havinga
- Re: Intel SSDs that may not suck Jeff
- Re: Intel SSDs that may not suck Cédric Villemain
- Re: Intel SSDs that may not suck Jeff
- very long updates very small tables Lars Feistner
- Re: Intel SSDs that may not suck Strange, John W
- Re: Intel SSDs that may not suck Jesper Krogh
- Re: Intel SSDs that may not suck Jeff
- Re: Intel SSDs that may not suck
- Re: Intel SSDs that may not suck Greg Smith
- Re: very long updates very small tables Kevin Grittner
- Re: Intel SSDs that may not suck Jesper Krogh
- multiple table scan performance Samuel Gendler
- Re: multiple table scan performance Claudio Freire
- Re: multiple table scan performance Marti Raudsepp
- Re: multiple table scan performance Samuel Gendler
- Re: multiple table scan performance Craig James
- Re: very long updates very small tables Lars Feistner
- Re: Why Index is not used Greg Smith
- Re: very long updates very small tables pasman pasmański
- Re: very long updates very small tables Kevin Grittner
- COPY with high # of clients, partitioned table locking issues? Strange, John W
- Re: COPY with high # of clients, partitioned table locking issues? Bob Lunney
- Re: COPY with high # of clients, partitioned table locking issues? Samuel Gendler
- Slow deleting tables with foreign keys Jeremy Palmer
- Re: COPY with high # of clients, partitioned table locking issues? Emanuel Calvo
- Re: Slow deleting tables with foreign keys Bob Lunney
- Re: COPY with high # of clients, partitioned table locking issues? Maciek Sakrejda
- Why it is using/not using index scan? Laszlo Nagy
- Re: Calculating 95th percentiles Landreville
- Re: Slow deleting tables with foreign keys Jeremy Palmer