pgsql-performance

Messages by Date

2016/04/20 Re: [PERFORM] Performant queries on table with many boolean columns Teodor Sigaev
2016/04/20 [PERFORM] Performant queries on table with many boolean columns Rob Imig
2016/04/19 Re: [PERFORM] Clarification on using pg_upgrade Tory M Blue
2016/04/19 Re: [PERFORM] Hash join seq scan slow Jeff Janes
2016/04/19 [PERFORM] Hash join seq scan slow Aldo Sarmiento
2016/04/15 Re: [PERFORM] Slow update on column that is part of exclusion constraint Evgeniy Shishkin
2016/04/13 Re: [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
2016/04/13 Re: [PERFORM] Slow update on column that is part of exclusion constraint Evgeniy Shishkin
2016/04/13 Re: [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
2016/04/13 [PERFORM] Slow update on column that is part of exclusion constraint Adam Brusselback
2016/04/09 Re: [PERFORM] Adding a ROLLUP switches to GroupAggregate unexpectedly Peter Geoghegan
2016/04/04 Re: [PERFORM] Big number of connections Pavel Stehule
2016/04/04 Re: [PERFORM] Big number of connections Moreno Andreo
2016/04/04 Re: [PERFORM] Big number of connections Artem Tomyuk
2016/04/04 Re: [PERFORM] Big number of connections Artem Tomyuk
2016/04/04 Re: [PERFORM] Big number of connections Moreno Andreo
2016/04/04 Re: [PERFORM] Big number of connections Pavel Stehule
2016/04/04 Re: [PERFORM] Big number of connections Mike Sofen
2016/04/03 Re: [PERFORM] Big number of connections Jim Nasby
2016/04/03 Re: [PERFORM] Clarification on using pg_upgrade Jim Nasby
2016/04/02 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Jeff Janes
2016/04/01 Re: [PERFORM] Fast HashJoin only after a cluster/recreate table Alexandre de Arruda Paes
2016/04/01 Re: [PERFORM] Fast HashJoin only after a cluster/recreate table David Rowley
2016/04/01 Re: [PERFORM] Big number of connections jarek
2016/03/31 [PERFORM] Fast HashJoin only after a cluster/recreate table Alexandre de Arruda Paes
2016/03/31 Re: [PERFORM] Big number of connections Karl Denninger
2016/03/31 Re: [PERFORM] Big number of connections Chris Cogdon
2016/03/31 Re: [PERFORM] Big number of connections Alvaro Herrera
2016/03/31 Re: [PERFORM] Big number of connections Andrew Dunstan
2016/03/31 Re: [PERFORM] Big number of connections Igor Neyman
2016/03/31 [PERFORM] Big number of connections Jarek
2016/03/31 Re: [PERFORM] Adding a ROLLUP switches to GroupAggregate unexpectedly k...@rice.edu
2016/03/31 Re: [PERFORM] Adding a ROLLUP switches to GroupAggregate unexpectedly Tom Lane
2016/03/31 [PERFORM] Adding a ROLLUP switches to GroupAggregate unexpectedly Chris Cogdon
2016/03/27 Re: [PERFORM] Query not using Index Jeff Janes
2016/03/27 Re: [PERFORM] Query not using Index Wei Shan
2016/03/26 Re: [PERFORM] Query not using Index Andreas Kretschmer
2016/03/26 [PERFORM] Query not using Index Wei Shan
2016/03/24 Re: [PERFORM] Clarification on using pg_upgrade Tory M Blue
2016/03/24 Re: [SPAM] Re: [PERFORM] Architectural question Moreno Andreo
2016/03/23 Re: [SPAM] Re: [PERFORM] Architectural question Jim Nasby
2016/03/23 Re: [PERFORM] Architectural question Moreno Andreo
2016/03/23 Re: [PERFORM] Architectural question Rick Otten
2016/03/23 Re: [PERFORM] Architectural question Mike Sofen
2016/03/23 Re: [PERFORM] Architectural question Moreno Andreo
2016/03/23 Re: [PERFORM] Architectural question Thomas Kellerer
2016/03/23 Re: [SPAM] Re: [PERFORM] Architectural question Moreno Andreo
2016/03/22 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Oleg Bartunov
2016/03/22 Re: [PERFORM] Disk Benchmarking Question Dave Stibrany
2016/03/21 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/21 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Oleg Bartunov
2016/03/21 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/20 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Tom Lane
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Tom Lane
2016/03/19 [PERFORM] Disk Benchmarking Question Dave Stibrany
2016/03/19 Re: [PERFORM] Performance decline maybe caused by multi-column index? Jeff Janes
2016/03/19 [PERFORM] Performance decline maybe caused by multi-column index? Jan Bauer Nielsen
2016/03/19 [PERFORM] Nested Loop vs Hash Join based on predicate? Doiron, Daniel
2016/03/19 Re: [PERFORM] Disk Benchmarking Question Mike Sofen
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Evgeniy Shishkin
2016/03/19 Re: [PERFORM] Nested Loop vs Hash Join based on predicate? Pavel Stehule
2016/03/19 Re: [PERFORM] using shared_buffers during seq_scan Rick Otten
2016/03/19 [PERFORM] using shared_buffers during seq_scan Artem Tomyuk
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Evgeniy Shishkin
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/19 Re: [PERFORM] using shared_buffers during seq_scan Albe Laurenz
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/19 [PERFORM] grant select on pg_stat_activity avi Singh
2016/03/19 Re: [PERFORM] Disk Benchmarking Question Scott Marlowe
2016/03/19 Re: [PERFORM] Disk Benchmarking Question Scott Marlowe
2016/03/19 Re: [PERFORM] Disk Benchmarking Question Dave Stibrany
2016/03/19 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Tom Lane
2016/03/19 Re: [PERFORM] [GENERAL] grant select on pg_stat_activity Adrian Klaver
2016/03/18 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/18 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/18 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Evgeniy Shishkin
2016/03/18 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/18 Re: [PERFORM] Disk Benchmarking Question Mike Sofen
2016/03/18 Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Jeff Janes
2016/03/16 [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column Andreas Joseph Krogh
2016/03/13 Re: [PERFORM] Merge joins on index scans Tom Lane
2016/03/13 Re: [PERFORM] DIsk I/O from pg_stat_activity Vladimir Borodin
2016/03/13 [PERFORM] DIsk I/O from pg_stat_activity Artem Tomyuk
2016/03/11 Re: [PERFORM] Clarification on using pg_upgrade Jim Nasby
2016/03/11 Re: [SPAM] Re: [PERFORM] Architectural question Jim Nasby
2016/03/09 Re: [PERFORM] using stale statistics instead of current ones because stats collector is not responding Tomas Vondra
2016/03/08 [PERFORM] using stale statistics instead of current ones because stats collector is not responding Tory M Blue
2016/03/04 Re: [PERFORM] Odd behavior with indices Tom Lane
2016/03/04 Re: [PERFORM] Clarification on using pg_upgrade Justin Pryzby
2016/03/04 [PERFORM] Clarification on using pg_upgrade Tory M Blue
2016/03/04 Re: [PERFORM] Odd behavior with indices Merlin Moncure
2016/03/04 Re: [PERFORM] [ADMIN] autovacuum disk IO Jehan-Guillaume de Rorthais
2016/03/02 Re: [SPAM] Re: [PERFORM] autovacuum disk IO Moreno Andreo
2016/03/02 Re: [SPAM] Re: [PERFORM] autovacuum disk IO Alvaro Herrera
2016/03/02 Re: [SPAM] Re: [PERFORM] autovacuum disk IO Scott Marlowe
2016/03/02 Re: [SPAM] Re: [PERFORM] autovacuum disk IO Moreno Andreo
2016/03/02 Re: [PERFORM] autovacuum disk IO Scott Marlowe
2016/03/02 Re: [PERFORM] autovacuum disk IO Scott Marlowe
2016/03/02 Re: [PERFORM] autovacuum disk IO Pavel Stehule
2016/03/02 [PERFORM] autovacuum disk IO Artem Tomyuk
2016/03/01 Re: [PERFORM] Merge joins on index scans James Parks
2016/02/29 Re: [PERFORM] Merge joins on index scans Tom Lane
2016/02/29 Re: [PERFORM] Odd behavior with indices Tom Lane
2016/02/28 Re: [PERFORM] Odd behavior with indices Matheus de Oliveira
2016/02/28 Re: [PERFORM] Merge joins on index scans David Rowley
2016/02/26 [PERFORM] Merge joins on index scans James Parks
2016/02/26 Re: [PERFORM] Odd behavior with indices David G. Johnston
2016/02/26 Re: [PERFORM] Odd behavior with indices joe meiring
2016/02/26 Re: [PERFORM] Odd behavior with indices David G. Johnston
2016/02/26 [PERFORM] Odd behavior with indices joe meiring
2016/02/24 Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup Wes Vaske (wvaske)
2016/02/24 Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup Rick Otten
2016/02/24 Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup Dave Stibrany
2016/02/24 Fwd: [PERFORM] Filesystem and Disk Partitioning for New Server Setup Rick Otten
2016/02/24 Fwd: [PERFORM] Cloud versus buying my own iron Rick Otten
2016/02/24 Re: [PERFORM] Cloud versus buying my own iron Gunnar "Nick" Bluth
2016/02/23 [PERFORM] Cloud versus buying my own iron Craig James
2016/02/23 [PERFORM] Filesystem and Disk Partitioning for New Server Setup dstibrany
2016/02/22 Re: [SPAM] Re: [PERFORM] Architectural question Moreno Andreo
2016/02/21 Re: [PERFORM] Why Postgres use a little memory on Windows. tuanhoanganh
2016/02/20 Re: [PERFORM] Why Postgres use a little memory on Windows. Jeff Janes
2016/02/20 Re: [PERFORM] [GENERAL] Why Postgres use a little memory on Windows. Adrian Klaver
2016/02/20 Re: [PERFORM] [GENERAL] Why Postgres use a little memory on Windows. Francisco Olarte
2016/02/20 Re: [PERFORM] [GENERAL] Why Postgres use a little memory on Windows. Francisco Olarte
2016/02/20 Re: [PERFORM] [GENERAL] Why Postgres use a little memory on Windows. Tom Lane
2016/02/20 Re: [PERFORM] [GENERAL] Why Postgres use a little memory on Windows. Adrian Klaver
2016/02/20 [PERFORM] Why Postgres use a little memory on Windows. tuanhoanganh
2016/02/18 Re: [PERFORM] Architectural question Jim Nasby
2016/02/16 Re: [PERFORM] Primary key index suddenly became very slow Venkata Balaji N
2016/02/16 Re: [PERFORM] Primary key index suddenly became very slow jaime soler
2016/02/13 Re: [PERFORM] Running lots of inserts from selects on 9.4.5 Dan Langille
2016/02/13 Re: [PERFORM] Running lots of inserts from selects on 9.4.5 Dan Langille
2016/02/11 Re: [PERFORM] Running lots of inserts from selects on 9.4.5 Dan Langille
2016/02/11 [PERFORM] Architectural question Moreno Andreo
2016/02/10 Re: [PERFORM] Running lots of inserts from selects on 9.4.5 Dan Langille
2016/02/09 Re: [PERFORM] Running lots of inserts from selects on 9.4.5 Jeff Janes
2016/02/09 [PERFORM] Running lots of inserts from selects on 9.4.5 Dan Langille
2016/02/08 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Merlin Moncure
2016/02/08 Re: [PERFORM] gin performance issue. Jeff Janes
2016/02/08 Re: [PERFORM] Bitmap and-ing between btree and gin? Jeff Janes
2016/02/08 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Merlin Moncure
2016/02/08 Re: [PERFORM] gin performance issue. Marc Mamin
2016/02/08 Re: [PERFORM] Primary key index suddenly became very slow Gustav Karlsson
2016/02/08 [PERFORM] Primary key index suddenly became very slow Gustav Karlsson
2016/02/08 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins Hedayat Vatankhah
2016/02/06 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Filip Rembiałkowski
2016/02/05 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Merlin Moncure
2016/02/05 Re: [PERFORM] View containing a recursive function Mathieu De Zutter
2016/02/05 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Filip Rembiałkowski
2016/02/05 Re: [PERFORM] gin performance issue. Tom Lane
2016/02/05 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Filip Rembiałkowski
2016/02/05 [PERFORM] gin performance issue. Marc Mamin
2016/02/05 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Harald Fuchs
2016/02/04 Re: [PERFORM] bad COPY performance with NOTIFY in a trigger Tom Lane
2016/02/04 [PERFORM] bad COPY performance with NOTIFY in a trigger Filip Rembiałkowski
2016/02/04 Re: [PERFORM] Bitmap and-ing between btree and gin? Jordi
2016/02/04 Re: [PERFORM] Bitmap and-ing between btree and gin? Tom Lane
2016/02/04 [PERFORM] Bitmap and-ing between btree and gin? Jordi
2016/02/04 [PERFORM] Understanding ANALYZE memory usage with "big" tsvector columns Jérôme Augé
2016/02/01 Re: [PERFORM] Hash join gets slower as work_mem increases? Albe Laurenz
2016/02/01 Re: [PERFORM] Hash join gets slower as work_mem increases? Tomas Vondra
2016/02/01 Re: [PERFORM] View containing a recursive function Tom Lane
2016/02/01 Re: [PERFORM] Hash join gets slower as work_mem increases? Albe Laurenz
2016/01/31 [PERFORM] View containing a recursive function Mathieu De Zutter
2016/01/30 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins Hedayat Vatankhah
2016/01/30 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins Vitalii Tymchyshyn
2016/01/30 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins David Rowley
2016/01/30 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins Vitalii Tymchyshyn
2016/01/30 Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins David Rowley
2016/01/30 Re: [PERFORM] Hash join gets slower as work_mem increases? Tomas Vondra
2016/01/30 [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins Hedayat Vatankhah
2016/01/29 Re: [PERFORM] jsonb_agg performance Andrew Dunstan
2016/01/29 [PERFORM] jsonb_agg performance jfleming
2016/01/29 Re: [PERFORM] Hash join gets slower as work_mem increases? Pavel Stehule
2016/01/29 [PERFORM] Hash join gets slower as work_mem increases? Albe Laurenz
2016/01/28 Re: [PERFORM] Postgres partitions-query scanning all child tables rverghese
2016/01/27 Re: [PERFORM] Postgres partitions-query scanning all child tables Corey Huinker
2016/01/27 Re: [PERFORM] Postgres partitions-query scanning all child tables rverghese
2016/01/27 Re: [PERFORM] Postgres partitions-query scanning all child tables Corey Huinker
2016/01/27 [PERFORM] performance issue with inherited foreign table Dzmitry Nikitsin
2016/01/27 [PERFORM] Postgres partitions-query scanning all child tables rverghese
2016/01/26 Re: [PERFORM] Primary key index partially used Igor Neyman
2016/01/26 Re: [PERFORM] Primary key index partially used Igor Neyman
2016/01/26 [PERFORM] Primary key index partially used Florian Gossin
2016/01/24 Re: [PERFORM] insert performance Jim Nasby
2016/01/22 Re: [PERFORM] High Planning Time Tom Lane
2016/01/22 Re: [PERFORM] High Planning Time Vitalii Tymchyshyn
2016/01/22 Re: [PERFORM] High Planning Time Albe Laurenz
2016/01/21 Re: [PERFORM] insert performance Jinhua Luo
2016/01/21 [PERFORM] High Planning Time Phil S
2016/01/18 Re: [PERFORM] insert performance Jinhua Luo
2016/01/17 Re: [PERFORM] Query order of magnitude slower with slightly different where clause David Rowley
2016/01/17 [PERFORM] Query order of magnitude slower with slightly different where clause Adam Brusselback
2016/01/13 Re: [PERFORM] insert performance Jinhua Luo
2016/01/13 Re: [PERFORM] insert performance Jinhua Luo
2016/01/11 Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly Skarsol
2016/01/11 Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly Jim Nasby
2016/01/11 Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly Skarsol
2016/01/11 Re: [PERFORM] insert performance Jeff Janes
2016/01/10 Re: [PERFORM] insert performance Jim Nasby