pgsql-performance

Messages by Date

2016/11/25 Re: [PERFORM] Millions of tables Robert Klemme
2016/11/24 Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Tom Lane
2016/11/24 Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
2016/11/24 Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Imre Samu
2016/11/24 Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
2016/11/23 Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Andreas Kretschmer
2016/11/23 [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
2016/11/18 Re: [PERFORM] DO I miss something ? vinny
2016/11/18 [PERFORM] DO I miss something ? Metatrader EA
2016/11/17 Re: [PERFORM] Query hangs sometimes Michael Paquier
2016/11/17 Re: [PERFORM] materialized view order by and clustering David G. Johnston
2016/11/17 [PERFORM] materialized view order by and clustering Rick Otten
2016/11/17 Re: [PERFORM] Query planner chooses index scan backward instead of better index option Seckin Pulatkan
2016/11/17 Re: [PERFORM] Query hangs sometimes Metatrader EA
2016/11/17 Re: [PERFORM] Query hangs sometimes Guillaume Cottenceau
2016/11/17 [PERFORM] Query hangs sometimes Metatrader EA
2016/11/16 [PERFORM] Run one query and execution time is very different Metatrader EA
2016/11/15 Re: [PERFORM] Performance decrease after upgrade to 9.6.1 Gabriela Serventi
2016/11/15 Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment Jeff Janes
2016/11/15 Re: [PERFORM] Performance decrease after upgrade to 9.6.1 Tom Lane
2016/11/15 [PERFORM] Performance decrease after upgrade to 9.6.1 Gabriela Serventi
2016/11/15 Re: [PERFORM] Sql Query :: Any advice ? Henrik
2016/11/15 Re: [PERFORM] Sql Query :: Any advice ? vinny
2016/11/15 Re: [PERFORM] Sql Query :: Any advice ? Henrik Ekenberg
2016/11/15 Re: [PERFORM] Sql Query :: Any advice ? vinny
2016/11/15 [PERFORM] Sql Query :: Any advice ? Henrik Ekenberg
2016/11/15 Re: [PERFORM] Query planner chooses index scan backward instead of better index option Seckin Pulatkan
2016/11/14 Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment Merlin Moncure
2016/11/14 Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment Pietro Pugni
2016/11/14 Re: [PERFORM] Why is the optimiser choosing a sub-optimal plan? Tom Lane
2016/11/14 [PERFORM] Why is the optimiser choosing a sub-optimal plan? Stephen Cresswell
2016/11/14 Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment domenico febbo
2016/11/14 Re: [PERFORM] Query planner chooses index scan backward instead of better index option Jeff Janes
2016/11/14 [PERFORM] Query planner chooses index scan backward instead of better index option Seckin Pulatkan
2016/11/14 [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment Pietro Pugni
2016/11/12 Re: [PERFORM] Inlining of functions (doing LIKE on an array) l...@laurent-hasson.com
2016/11/12 Re: [PERFORM] Inlining of functions (doing LIKE on an array) Tom Lane
2016/11/12 Re: [PERFORM] Any advice tuning this query ? Jeff Janes
2016/11/11 Re: [PERFORM] Inlining of functions (doing LIKE on an array) l...@laurent-hasson.com
2016/11/11 Re: [PERFORM] Inlining of functions (doing LIKE on an array) Jeff Janes
2016/11/11 Re: [PERFORM] Inlining of functions (doing LIKE on an array) Tom Lane
2016/11/11 Re: [PERFORM] Any advice tuning this query ? Andreas Karlsson
2016/11/11 Re: [PERFORM] Inlining of functions (doing LIKE on an array) l...@laurent-hasson.com
2016/11/11 Re: [PERFORM] Any advice tuning this query ? Devrim Gündüz
2016/11/11 [PERFORM] Any advice tuning this query ? Henrik Ekenberg
2016/11/11 Re: [PERFORM] Inlining of functions (doing LIKE on an array) Marc Mamin
2016/11/10 [PERFORM] Inlining of functions (doing LIKE on an array) l...@laurent-hasson.com
2016/11/10 Re: [PERFORM] Perf decreased although server is better Benjamin Toueg
2016/11/09 Re: [PERFORM] Tuning one Recurcive CTE Andreas Joseph Krogh
2016/11/09 Re: [PERFORM] Tuning one Recurcive CTE Henrik Ekenberg
2016/11/09 Re: [PERFORM] Tuning one Recurcive CTE Andreas Joseph Krogh
2016/11/09 [PERFORM] Tuning one Recurcive CTE Henrik Ekenberg
2016/11/08 Re: [PERFORM] archive_command too slow. Stephen Frost
2016/11/07 Re: [PERFORM] Query much slower after upgrade to 9.6.1 Adam Brusselback
2016/11/07 Re: [PERFORM] Query much slower after upgrade to 9.6.1 Tom Lane
2016/11/07 Re: [PERFORM] Query much slower after upgrade to 9.6.1 Adam Brusselback
2016/11/07 Re: [PERFORM] Query much slower after upgrade to 9.6.1 Tom Lane
2016/11/07 Re: [PERFORM] Query much slower after upgrade to 9.6.1 Adam Brusselback
2016/11/07 [PERFORM] Query much slower after upgrade to 9.6.1 Adam Brusselback
2016/11/05 Re: [PERFORM] no MCV list of tiny table with unique columns Justin Pryzby
2016/11/04 Re: [PERFORM] archive_command too slow. Claudio Freire
2016/11/04 Re: [PERFORM] archive_command too slow. Jeff Janes
2016/11/04 Re: [PERFORM] Perf decreased although server is better Kevin Grittner
2016/11/04 Re: [PERFORM] Perf decreased although server is better Rick Otten
2016/11/04 Re: [PERFORM] Perf decreased although server is better Will Platnick
2016/11/04 Re: [PERFORM] Perf decreased although server is better Benjamin Toueg
2016/11/03 Re: [PERFORM] Big Memory Boxes and pgtune Scott Marlowe
2016/11/03 Re: [PERFORM] Perf decreased although server is better Kevin Grittner
2016/11/03 [PERFORM] Hot migration of tables YueLi
2016/11/03 Re: [PERFORM] Perf decreased although server is better Benjamin Toueg
2016/11/02 Re: [PERFORM] no MCV list of tiny table with unique columns Tom Lane
2016/11/02 Re: [PERFORM] Big Memory Boxes and pgtune Jim Nasby
2016/11/02 Re: [PERFORM] query slowdown after 9.0 -> 9.4 migration Jim Nasby
2016/11/02 Re: [PERFORM] limit 1 on view never finishes Jim Nasby
2016/11/02 Re: [PERFORM] no MCV list of tiny table with unique columns Justin Pryzby
2016/11/02 Re: [PERFORM] no MCV list of tiny table with unique columns Tom Lane
2016/11/02 [PERFORM] archive_command too slow. Joao Junior
2016/11/02 [PERFORM] no MCV list of tiny table with unique columns Justin Pryzby
2016/11/02 Re: [PERFORM] Perf decreased although server is better Rick Otten
2016/11/02 Re: [PERFORM] Perf decreased although server is better Kevin Grittner
2016/11/02 Re: [PERFORM] Perf decreased although server is better Tomas Vondra
2016/11/02 [PERFORM] Perf decreased although server is better Benjamin Toueg
2016/11/01 Re: [PERFORM] Refresh materialized view vs recreate Kevin Grittner
2016/10/31 [PERFORM] Refresh materialized view vs recreate Антон Мазунин
2016/10/31 Re: [PERFORM] Tuning Checkpoints Tomas Vondra
2016/10/28 Re: [PERFORM] Big Memory Boxes and pgtune Joshua D. Drake
2016/10/28 Re: [PERFORM] Big Memory Boxes and pgtune Kevin Grittner
2016/10/28 [PERFORM] Big Memory Boxes and pgtune Warner, Gary, Jr
2016/10/27 Re: [PERFORM] query slowdown after 9.0 -> 9.4 migration Filip Rembiałkowski
2016/10/27 [PERFORM] limit 1 on view never finishes Craig James
2016/10/26 Re: [PERFORM] query slowdown after 9.0 -> 9.4 migration Andreas Kretschmer
2016/10/26 Re: [PERFORM] query slowdown after 9.0 -> 9.4 migration Tomas Vondra
2016/10/26 [PERFORM] query slowdown after 9.0 -> 9.4 migration Filip Rembiałkowski
2016/10/25 Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Lars Aksel Opsahl
2016/10/24 Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Lars Aksel Opsahl
2016/10/24 Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Scott Marlowe
2016/10/24 Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Lars Aksel Opsahl
2016/10/24 Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Tom Lane
2016/10/24 [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Lars Aksel Opsahl
2016/10/19 Re: [PERFORM] Performance of a nested loop, whose inner loop uses an index scan. negora
2016/10/19 Re: [PERFORM] Performance of a nested loop, whose inner loop uses an index scan. Matheus de Oliveira
2016/10/19 [PERFORM] Performance of a nested loop, whose inner loop uses an index scan. negora
2016/10/18 Re: [PERFORM] Should I generate strings in Postgres of Python? Sam Gendler
2016/10/18 [PERFORM] Should I generate strings in Postgres of Python? Bobby Mozumder
2016/10/14 Re: [PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one Tom Lane
2016/10/14 Re: [PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one Kyle Moser
2016/10/14 Re: [PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one Tom Lane
2016/10/14 [PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one Kyle Moser
2016/10/14 Re: [PERFORM] pg_basebackup running slow Michael Paquier
2016/10/14 Re: [PERFORM] pg_basebackup running slow Stephen Frost
2016/10/14 Re: [PERFORM] pg_basebackup running slow Samir Magar
2016/10/14 [PERFORM] pg_basebackup running slow Swapnil Vaze
2016/10/12 Fwd: [PERFORM] Delay in converting logs from ready state to done state Samir Magar
2016/10/11 Re: [PERFORM] Delay in converting logs from ready state to done state Julien Rouhaud
2016/10/11 [PERFORM] Delay in converting logs from ready state to done state Samir Magar
2016/10/11 Re: [PERFORM] Why query plan is different? Pavel Stehule
2016/10/11 Re: [PERFORM] Why query plan is different? Andrzej Zawadzki
2016/10/10 Re: [PERFORM] Why query plan is different? Pavel Stehule
2016/10/10 Re: [PERFORM] Why query plan is different? Andrzej Zawadzki
2016/10/10 Re: [PERFORM] Why query plan is different? Andrzej Zawadzki
2016/10/10 Re: [PERFORM] Why query plan is different? Pavel Stehule
2016/10/10 [PERFORM] Why query plan is different? Andrzej Zawadzki
2016/10/08 Re: [PERFORM] Millions of tables Jim Nasby
2016/10/05 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/10/03 Re: [PERFORM] MYSQL Stats Gavin Flower
2016/10/03 Re: [PERFORM] Understanding BRIN index performance Ivan Voras
2016/10/03 Re: [PERFORM] Understanding BRIN index performance Simon Riggs
2016/10/03 Re: [PERFORM] Understanding BRIN index performance Ivan Voras
2016/10/03 Re: [PERFORM] Understanding BRIN index performance Simon Riggs
2016/10/03 Re: [PERFORM] Understanding BRIN index performance Madusudanan.B.N
2016/10/03 [PERFORM] Understanding BRIN index performance Ivan Voras
2016/10/01 Re: [PERFORM] Millions of tables Jeff Janes
2016/09/30 Re: [PERFORM] Millions of tables Jim Nasby
2016/09/30 Re: [PERFORM] Unexpected expensive index scan Jim Nasby
2016/09/30 Re: [PERFORM] MYSQL Stats Joe Proietti
2016/09/30 [PERFORM] MYSQL Stats Joe Proietti
2016/09/30 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
2016/09/30 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Pavel Stehule
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Pavel Stehule
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
2016/09/29 Re: [PERFORM] Failing Multi-Job Restores, Missing Indexes on Restore Tom Lane
2016/09/29 Re: [PERFORM] Failing Multi-Job Restores, Missing Indexes on Restore Cea Stapleton
2016/09/29 Re: [PERFORM] Failing Multi-Job Restores, Missing Indexes on Restore Tom Lane
2016/09/29 [PERFORM] Failing Multi-Job Restores, Missing Indexes on Restore Cea Stapleton
2016/09/29 Re: [PERFORM] Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
2016/09/29 Re: [PERFORM] Millions of tables Alex Ignatov (postgrespro)
2016/09/29 Re: [PERFORM] Millions of tables Simon Riggs
2016/09/28 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Karl Denninger
2016/09/28 Re: [PERFORM] PostgreSQL on ZFS: performance tuning trafdev
2016/09/28 Re: [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/28 Re: [PERFORM] Millions of tables Stephen Frost
2016/09/28 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/28 Re: [PERFORM] Millions of tables Stephen Frost
2016/09/28 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/28 Re: [PERFORM] Millions of tables Richard Albright
2016/09/28 Re: [PERFORM] Millions of tables Vitalii Tymchyshyn
2016/09/28 Re: [PERFORM] Unexpected expensive index scan Tom Lane
2016/09/28 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Karl Denninger
2016/09/27 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Jov
2016/09/27 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Jov
2016/09/27 Re: [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/27 Re: [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/27 Re: [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/27 Re: [PERFORM] Unexpected expensive index scan Mike Sofen
2016/09/27 Re: [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/27 [PERFORM] Unexpected expensive index scan Jake Nielsen
2016/09/27 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Karl Denninger
2016/09/27 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Tomas Vondra
2016/09/27 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/27 Re: [PERFORM] Millions of tables Terry Schmitt
2016/09/27 Re: [PERFORM] PostgreSQL on ZFS: performance tuning Torsten Zuehlsdorff
2016/09/27 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/27 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/27 Re: [PERFORM] Millions of tables Mike Sofen
2016/09/27 Re: [PERFORM] Millions of tables Mike Sofen
2016/09/27 Re: [PERFORM] Millions of tables Craig James
2016/09/26 Re: [PERFORM] Storing large documents - one table or partition by doc? Jim Nasby
2016/09/26 Re: [PERFORM] Millions of tables Tom Lane
2016/09/26 Re: [PERFORM] Millions of tables Jeff Janes
2016/09/26 Re: [PERFORM] [HACKERS] temporary table vs array performance Pavel Stehule
2016/09/26 Re: [PERFORM] Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Knels, Udo
2016/09/26 Re: [PERFORM] [HACKERS] temporary table vs array performance David G. Johnston
2016/09/26 [PERFORM] temporary table vs array performance dby...@163.com
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Stuart Bishop
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Mike Sofen
2016/09/26 Re: [PERFORM] Millions of tables Yves Dorfsman
2016/09/26 Re: [PERFORM] Millions of tables Greg Spiegelberg
2016/09/26 Re: [PERFORM] Millions of tables Rick Otten
2016/09/26 Re: [PERFORM] Millions of tables Stuart Bishop
2016/09/26 Re: [PERFORM] Millions of tables Álvaro Hernández Tortosa