pgsql-performance  

Messages by Thread

• • Re: [PERFORM] Random slow queries Tom Lane
• [PERFORM] testing - ignore George Neuner
• [PERFORM] [PERFORM] Cache performance decreases Suren Arustamyan
• [PERFORM] can't explain commit performance win7 vs linux : 8000/s vs 419/s t.dalpo...@gmail.com
  • Re: [PERFORM] can't explain commit performance win7 vs linux : 8000/s vs 419/s Tom Lane
  • Re: [PERFORM] can't explain commit performance win7 vs linux : 8000/s vs 419/s Jeff Janes
  • Re: [PERFORM] can't explain commit performance win7 vs linux : 8000/s vs 419/s Imre Samu
• [PERFORM] Can't get two index scans Craig James
  • Re: [PERFORM] Can't get two index scans Jeff Janes
  • Re: [PERFORM] Can't get two index scans Craig James
  • Re: [PERFORM] Can't get two index scans Jeff Janes
  • Re: [PERFORM] Can't get two index scans Craig James
• [PERFORM] Looking for more Beta Users! jonescam
• [PERFORM] Savepoint and Releasepoint in Logs e.ratnakar.shetty
  • Re: [PERFORM] Savepoint and Releasepoint in Logs Jeff Janes
• [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Tom Lane
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Tom Lane
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Tom Lane
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Adam Brusselback
  • Re: [PERFORM] 9.6 query slower than 9.5.3 Tom Lane
• [PERFORM] Index not used meike . talbach
  • Re: [PERFORM] Index not used John Gorman
  • Re: [PERFORM] Index not used Tom Lane
  • Re: [PERFORM] Index not used David G. Johnston
  • Re: [PERFORM] Index not used meike . talbach
• [PERFORM] pg_restore seems very slow Adrian Myers
  • Re: [PERFORM] pg_restore seems very slow David G. Johnston
  • Re: [PERFORM] pg_restore seems very slow Adrian Myers
  • Re: [PERFORM] pg_restore seems very slow Adam Scott
• [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes Torsten Zuehlsdorff
  • Re: [PERFORM] Indexes for hashes k...@rice.edu
  • Re: [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes k...@rice.edu
  • Re: [PERFORM] Indexes for hashes Jeff Janes
  • Re: [PERFORM] Indexes for hashes hubert depesz lubaczewski
  • Re: [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes julyanto SUTANDANG
  • Re: [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes Joshua D. Drake
  • Re: [PERFORM] Indexes for hashes k...@rice.edu
  • Re: [PERFORM] Indexes for hashes Claudio Freire
  • Re: [PERFORM] Indexes for hashes julyanto SUTANDANG
  • Re: [PERFORM] Indexes for hashes Claudio Freire
  • Re: [PERFORM] Indexes for hashes Ivan Voras
  • Re: [PERFORM] Indexes for hashes julyanto SUTANDANG
• [PERFORM] Many-to-many performance problem Rowan Seymour
  • Re: [PERFORM] Many-to-many performance problem Tom Lane
  • Re: [PERFORM] Many-to-many performance problem Yves Dorfsman
  • Re: [PERFORM] Many-to-many performance problem Tom Lane
  • Re: [PERFORM] Many-to-many performance problem Alex Ignatov
  • Re: [PERFORM] Many-to-many performance problem Rowan Seymour
• [PERFORM] Performance of LIKE/NOT LIKE when used in single query Ed Felstein
  • Re: [PERFORM] Performance of LIKE/NOT LIKE when used in single query David G. Johnston
  • Re: [PERFORM] Performance of LIKE/NOT LIKE when used in single query Jeff Janes
• [PERFORM] Combination of partial and full indexes Rafał Gutkowski
  • Re: [PERFORM] Combination of partial and full indexes Gerardo Herzig
  • Re: [PERFORM] Combination of partial and full indexes Rafał Gutkowski
  • Re: [PERFORM] Combination of partial and full indexes Rafał Gutkowski
• [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Josh Berkus
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Michael Paquier
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Tom Lane
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Merlin Moncure
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
  • Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json Merlin Moncure
• [PERFORM] Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
  • Re: [PERFORM] Locking concurrency: select for update vs update Szymon Lipiński
  • Re: [PERFORM] Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
  • Re: [PERFORM] Locking concurrency: select for update vs update Tom Lane
  • Re: [PERFORM] Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
• [PERFORM] pg_database_size sangeetha
  • Re: [PERFORM] pg_database_size Venkata Balaji N
  • Re: [PERFORM] pg_database_size Jim Nasby
• [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 avi Singh
  • Re: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 Glyn Astill
  • Re: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 Jan Wieck
• [PERFORM] similarity and operator '%' Volker Boehm
  • Re: [PERFORM] similarity and operator '%' David G. Johnston
  • Re: [PERFORM] similarity and operator '%' Jeff Janes
• [PERFORM] Planner chooses slow index heap scan despite accurate row estimates Jake Magner
  • Re: [PERFORM] Planner chooses slow index heap scan despite accurate row estimates Tom Lane
  • [PERFORM] Re: Planner chooses slow index heap scan despite accurate row estimates Jake Magner
  • Re: [PERFORM] Re: Planner chooses slow index heap scan despite accurate row estimates Tom Lane
  • [PERFORM] Re: Planner chooses slow index heap scan despite accurate row estimates Jake Magner
  • Re: [PERFORM] Re: Planner chooses slow index heap scan despite accurate row estimates Jeff Janes
• [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Tom Lane
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Steve Crawford
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Claudio Freire
  • Re: [PERFORM] Performance problems with 9.2.15 David G. Johnston
  • Re: [PERFORM] Performance problems with 9.2.15 Claudio Freire
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
  • Re: [PERFORM] Performance problems with 9.2.15 Mark Kirkwood
  • Re: [PERFORM] Performance problems with 9.2.15 Johan Fredriksson
• [PERFORM] Testing in AWS, EBS Tory M Blue
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Yves Dorfsman
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Yves Dorfsman
  • Re: [PERFORM] Testing in AWS, EBS Artem Tomyuk
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Artem Tomyuk
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Artem Tomyuk
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Artem Tomyuk
  • Re: [PERFORM] Testing in AWS, EBS Yves Dorfsman
  • Re: [PERFORM] Testing in AWS, EBS Rayson Ho
  • Re: [PERFORM] Testing in AWS, EBS Artem Tomyuk
• [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Vladimir Borodin
  • Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Антон Бушмелев
  • Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund
  • Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund
  • Re: [HACKERS] [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Vladimir Borodin
  • Re: [HACKERS] [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund
  • Re: [HACKERS] [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund
• [PERFORM] index fragmentation on insert-only table with non-unique column Justin Pryzby
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Peter Geoghegan
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Stephen Frost
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Tom Lane
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Peter Geoghegan
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Justin Pryzby
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Jeff Janes
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Justin Pryzby
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Claudio Freire
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Justin Pryzby
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Claudio Freire
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Tom Lane
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Jeff Janes
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Kevin Grittner
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Justin Pryzby
  • Re: [PERFORM] index fragmentation on insert-only table with non-unique column Claudio Freire
  • estimate correlation of index separately from table (Re: [PERFORM] index fragmentation on insert-only table with non-unique column) Justin Pryzby
  • Re: estimate correlation of index separately from table (Re: [PERFORM] index fragmentation on insert-only table with non-unique column) Peter Geoghegan
• [PERFORM] Locks when launching function across schemata Christian Castelli
• [PERFORM] Database transaction with intermittent slow responses John Gorman
  • Re: [PERFORM] Database transaction with intermittent slow responses Gerardo Herzig
  • Re: [PERFORM] Database transaction with intermittent slow responses John Gorman
  • Re: [PERFORM] Database transaction with intermittent slow responses Gerardo Herzig
  • Re: [PERFORM] Database transaction with intermittent slow responses Robert Klemme
  • Re: [PERFORM] Database transaction with intermittent slow responses John Gorman
• [PERFORM] LIKE pattern Владимир
  • Re: [PERFORM] LIKE pattern SoDupuDupu
  • Re: [PERFORM] LIKE pattern Robert Klemme
  • Re: [PERFORM] LIKE pattern Jeff Janes
  • Re: [PERFORM] LIKE pattern Tom Lane
• [PERFORM] testing - please ignore George Neuner
• [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Artem Tomyuk
  • Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Imre Samu
  • Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Michael Nolan
  • Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Artem Tomyuk
  • Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Merlin Moncure
  • Re: [PERFORM] Poor disk (virtio) Performance Inside KVM virt-machine vs host machine Alan Hodgson
• [PERFORM] Performance problems with postgres and null Values? Sven Kerkling
  • Re: [PERFORM] Performance problems with postgres and null Values? Merlin Moncure
  • Re: [PERFORM] Performance problems with postgres and null Values? Sven Kerkling
  • Re: [PERFORM] Performance problems with postgres and null Values? Albe Laurenz
  • Re: [PERFORM] Performance problems with postgres and null Values? Sven Kerkling
• [PERFORM] Performant queries on table with many boolean columns Rob Imig
  • Re: [PERFORM] Performant queries on table with many boolean columns Teodor Sigaev
  • Re: [PERFORM] Performant queries on table with many boolean columns Rick Otten
  • Re: [PERFORM] Performant queries on table with many boolean columns Jeff Janes
  • Re: [PERFORM] Performant queries on table with many boolean columns Rob Imig
  • Re: [PERFORM] Performant queries on table with many boolean columns Rob Imig
  • Re: [PERFORM] Performant queries on table with many boolean columns bricklen
  • Re: [PERFORM] Performant queries on table with many boolean columns bricklen
  • Re: [PERFORM] Performant queries on table with many boolean columns Merlin Moncure
  • Re: [PERFORM] Performant queries on table with many boolean columns Adam Brusselback
  • Re: [PERFORM] Performant queries on table with many boolean columns Jeff Janes
• [PERFORM] Hash join seq scan slow Aldo Sarmiento
  • Re: [PERFORM] Hash join seq scan slow Jeff Janes
• [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
  • Re: [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
  • Re: [PERFORM] Slow update on column that is part of exclusion constraint Evgeniy Shishkin
  • Re: [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
  • Re: [PERFORM] Slow update on column that is part of exclusion constraint Evgeniy Shishkin
• [PERFORM] Fast HashJoin only after a cluster/recreate table Alexandre de Arruda Paes
  • Re: [PERFORM] Fast HashJoin only after a cluster/recreate table David Rowley
  • Re: [PERFORM] Fast HashJoin only after a cluster/recreate table Alexandre de Arruda Paes
• [PERFORM] Big number of connections Jarek
  • Re: [PERFORM] Big number of connections Igor Neyman
  • Re: [PERFORM] Big number of connections Andrew Dunstan

• Earlier messages
• Later messages