pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Testing in AWS, EBS
  2016-05-25 22:34 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-25 23:02 UTC  Rayson Ho <raysonlogin@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-25 23:56 UTC  Yves Dorfsman <yves@zioup.com>
` Re: Testing in AWS, EBS
  2016-05-26 01:08 UTC  Rayson Ho <raysonlogin@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-26 08:41 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Testing in AWS, EBS
  2016-05-26 12:53 UTC  Yves Dorfsman <yves@zioup.com>
` Re: Testing in AWS, EBS
  2016-05-26 13:00 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Testing in AWS, EBS
  2016-05-26 13:50 UTC  Rayson Ho <raysonlogin@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-26 14:00 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Testing in AWS, EBS
  2016-05-26 14:47 UTC  Rayson Ho <raysonlogin@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-26 14:52 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Testing in AWS, EBS
  2016-05-26 14:54 UTC  Rayson Ho <raysonlogin@gmail.com>
` Re: Testing in AWS, EBS
  2016-05-26 15:03 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Testing in AWS, EBS
  2016-05-26 15:41 UTC  Yves Dorfsman <yves@zioup.com>
` Re: Testing in AWS, EBS
  2016-05-26 21:26 UTC  Rayson Ho <raysonlogin@gmail.com>
  [15+ messages in thread]

Locks when launching function across schemata
  2016-05-18 11:10 UTC  Christian Castelli <voodoo81people@gmail.com>

Database transaction with intermittent slow responses
  2016-05-13 19:59 UTC  John Gorman <jgorman@eldocomp.com>
` Re: Database transaction with intermittent slow responses
  2016-05-13 21:05 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Database transaction with intermittent slow responses
  2016-05-13 21:25 UTC  John Gorman <jgorman@eldocomp.com>
` Re: Database transaction with intermittent slow responses
  2016-05-13 23:11 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Database transaction with intermittent slow responses
  2016-05-14 09:47 UTC  Robert Klemme <shortcutter@googlemail.com>
` Re: Database transaction with intermittent slow responses
  2016-05-16 18:24 UTC  John Gorman <jgorman@eldocomp.com>
  [6+ messages in thread]

LIKE pattern
  2016-05-06 09:48 UTC  Владимир <vovka@krevedko.su>
` Re: LIKE pattern
  2016-05-09 21:41 UTC  SoDupuDupu <playtoh87@gmail.com>
` Re: LIKE pattern
  2016-05-12 15:13 UTC  Robert Klemme <shortcutter@googlemail.com>
` Re: LIKE pattern
  2016-05-12 17:02 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: LIKE pattern
  2016-05-12 17:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

testing - please ignore
  2016-04-28 02:41 UTC  George Neuner <gneuner2@comcast.net>

Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 14:03 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 14:32 UTC  Imre Samu <pella.samu@gmail.com>
` Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 15:21 UTC  Michael Nolan <htfoot@gmail.com>
` Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 15:27 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 20:47 UTC  Alan Hodgson <ahodgson@lists.simkin.ca>
` Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine
  2016-04-26 20:52 UTC  Merlin Moncure <mmoncure@gmail.com>
  [6+ messages in thread]

Performance problems with postgres and null Values?
  2016-04-21 09:49 UTC  Sven Kerkling <kerkling@bds-online.com>
` Re: Performance problems with postgres and null Values?
  2016-04-22 22:10 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problems with postgres and null Values?
  2016-04-25 07:22 UTC  Sven Kerkling <kerkling@bds-online.com>
` Re: Performance problems with postgres and null Values?
  2016-04-25 08:08 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Performance problems with postgres and null Values?
  2016-04-26 10:13 UTC  Sven Kerkling <kerkling@bds-online.com>
  [5+ messages in thread]

Performant queries on table with many boolean columns
  2016-04-20 18:41 UTC  Rob Imig <rimig88@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-20 18:54 UTC  Teodor Sigaev <teodor@sigaev.ru>
` Re: Performant queries on table with many boolean columns
  2016-04-20 21:07 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-20 21:49 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-21 10:04 UTC  Teodor Sigaev <teodor@sigaev.ru>
` Re: Performant queries on table with many boolean columns
  2016-04-21 16:12 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-21 16:36 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-21 16:45 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-21 19:34 UTC  Rob Imig <rimig88@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-22 13:57 UTC  Rob Imig <rimig88@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-24 20:10 UTC  bricklen <bricklen@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-24 20:14 UTC  bricklen <bricklen@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-25 16:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performant queries on table with many boolean columns
  2016-04-25 17:23 UTC  Adam Brusselback <adambrusselback@gmail.com>
  [14+ messages in thread]

Hash join seq scan slow
  2016-04-19 08:07 UTC  Aldo Sarmiento <aldo@bigpurpledot.com>
` Re: Hash join seq scan slow
  2016-04-20 00:04 UTC  Jeff Janes <jeff.janes@gmail.com>
  [2+ messages in thread]

Slow update on column that is part of exclusion constraint
  2016-04-13 17:03 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Slow update on column that is part of exclusion constraint
  2016-04-13 17:14 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Slow update on column that is part of exclusion constraint
  2016-04-13 18:54 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Slow update on column that is part of exclusion constraint
  2016-04-14 04:17 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Slow update on column that is part of exclusion constraint
  2016-04-15 09:31 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
  [5+ messages in thread]

Adding a ROLLUP switches to GroupAggregate unexpectedly
  2016-03-31 17:03 UTC  Chris Cogdon <chris@cogdon.org>
` Re: Adding a ROLLUP switches to GroupAggregate unexpectedly
  2016-03-31 18:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding a ROLLUP switches to GroupAggregate unexpectedly
  2016-03-31 19:08 UTC  ktm@rice.edu <ktm@rice.edu>
` Re: Adding a ROLLUP switches to GroupAggregate unexpectedly
  2016-04-10 00:41 UTC  Peter Geoghegan <pg@bowt.ie>
  [4+ messages in thread]

Big number of connections
  2016-03-31 19:08 UTC  Jarek <jarek@poczta.srv.pl>
` Re: Big number of connections
  2016-03-31 19:12 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: Big number of connections
  2016-03-31 19:51 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Big number of connections
  2016-03-31 22:47 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Big number of connections
  2016-03-31 23:12 UTC  Chris Cogdon <chris@cogdon.org>
` Re: Big number of connections
  2016-03-31 23:27 UTC  Karl Denninger <karl@denninger.net>
` Re: Big number of connections
  2016-04-01 07:54 UTC  jarek <jarek@poczta.srv.pl>
` Re: Big number of connections
  2016-04-03 17:18 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Big number of connections
  2016-04-04 13:14 UTC  Mike Sofen <msofen@runbox.com>
` Re: Big number of connections
  2016-04-04 13:33 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Big number of connections
  2016-04-04 14:43 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Big number of connections
  2016-04-04 14:54 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Big number of connections
  2016-04-04 15:00 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Big number of connections
  2016-04-04 15:03 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: Big number of connections
  2016-04-04 15:06 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [15+ messages in thread]

Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 09:00 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 13:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 13:53 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 14:01 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 14:52 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 15:04 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 15:07 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 15:08 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-16 15:17 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-17 17:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-17 17:30 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-17 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-19 02:44 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-21 14:41 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-21 15:13 UTC  Oleg Bartunov <obartunov@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-21 15:33 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-03-22 16:41 UTC  Oleg Bartunov <obartunov@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
  2016-04-03 02:53 UTC  Jeff Janes <jeff.janes@gmail.com>
  [18+ messages in thread]

Fast HashJoin only after a cluster/recreate table
  2016-04-01 02:44 UTC  Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Fast HashJoin only after a cluster/recreate table
  2016-04-01 13:17 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Fast HashJoin only after a cluster/recreate table
  2016-04-01 17:34 UTC  Alexandre de Arruda Paes <adaldeia@gmail.com>
  [3+ messages in thread]

Query not using index
  2005-12-09 09:36 UTC  Kaloyan Iliev <news1@faith.digsys.bg>
` Re: Query not using index
  2005-12-09 15:06 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: Query not using index
  2005-12-09 16:38 UTC  Kaloyan Iliev <kaloyan@mbox.digsys.bg>
` Re: Query not using index
  2005-12-09 16:39 UTC  Kaloyan Iliev <news1@faith.digsys.bg>
` query not using index
  2013-12-19 13:06 UTC  Johann Spies <johann.spies@gmail.com>
` Re: query not using index
  2013-12-19 14:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query not using index
  2013-12-23 08:58 UTC  Johann Spies <johann.spies@gmail.com>
` Re: query not using index
  2013-12-28 02:31 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Query not using Index
  2016-03-26 13:14 UTC  Wei Shan <weishan.ang@gmail.com>
` Re: Query not using Index
  2016-03-26 14:13 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Query not using Index
  2016-03-27 16:12 UTC  Wei Shan <weishan.ang@gmail.com>
` Re: Query not using Index
  2016-03-27 19:20 UTC  Jeff Janes <jeff.janes@gmail.com>
  [12+ messages in thread]

Architectural question
  2016-02-11 18:06 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
  2016-02-18 20:33 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
  2016-02-22 14:40 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: Architectural question
  2016-03-11 16:37 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
  2016-03-23 09:14 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
  2016-03-23 09:50 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Architectural question
  2016-03-23 10:44 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
  2016-03-23 12:29 UTC  Mike Sofen <msofen@runbox.com>
` Re: Architectural question
  2016-03-23 13:18 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Architectural question
  2016-03-23 18:06 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: Architectural question
  2016-03-23 18:51 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
  2016-03-24 10:56 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
  [12+ messages in thread]

Disk Benchmarking Question
  2016-03-17 20:45 UTC  Dave Stibrany <dstibrany@gmail.com>
` Re: Disk Benchmarking Question
  2016-03-17 21:11 UTC  Mike Sofen <msofen@runbox.com>
` Re: Disk Benchmarking Question
  2016-03-18 14:48 UTC  Dave Stibrany <dstibrany@gmail.com>
` Re: Disk Benchmarking Question
  2016-03-19 03:22 UTC  Mike Sofen <msofen@runbox.com>
` Re: Disk Benchmarking Question
  2016-03-19 10:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Disk Benchmarking Question
  2016-03-19 10:32 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Disk Benchmarking Question
  2016-03-22 14:44 UTC  Dave Stibrany <dstibrany@gmail.com>
  [7+ messages in thread]

grant select on pg_stat_activity
  2016-03-18 20:09 UTC  avi Singh <avisingh19811981@gmail.com>
` Re: [GENERAL] grant select on pg_stat_activity
  2016-03-18 21:46 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: grant select on pg_stat_activity
  2016-03-21 14:15 UTC  Vick Khera <vivek@khera.org>
` Re: grant select on pg_stat_activity
  2016-03-21 15:19 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [4+ messages in thread]

Performance decline maybe caused by multi-column index?
  2016-03-18 13:26 UTC  Jan Bauer Nielsen <jbn@dbc.dk>
` Re: Performance decline maybe caused by multi-column index?
  2016-03-19 21:48 UTC  Jeff Janes <jeff.janes@gmail.com>
  [2+ messages in thread]

using shared_buffers during seq_scan
  2016-03-17 09:57 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: using shared_buffers during seq_scan
  2016-03-17 13:07 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: using shared_buffers during seq_scan
  2016-03-18 10:30 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
  [3+ messages in thread]

Nested Loop vs Hash Join based on predicate?
  2016-03-16 20:23 UTC  Doiron, Daniel <DoironD@advisory.com>
` Re: Nested Loop vs Hash Join based on predicate?
  2016-03-16 21:01 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [2+ messages in thread]

Merge joins on index scans
  2016-02-26 22:07 UTC  James Parks <james.parks@meraki.net>
` Re: Merge joins on index scans
  2016-02-28 10:06 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Merge joins on index scans
  2016-03-01 01:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Merge joins on index scans
  2016-03-02 07:36 UTC  James Parks <james.parks@meraki.net>
` Re: Merge joins on index scans
  2016-03-14 00:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

DIsk I/O from pg_stat_activity
  2016-03-13 17:39 UTC  Artem Tomyuk <admin@leboutique.com>
` Re: DIsk I/O from pg_stat_activity
  2016-03-13 17:50 UTC  Vladimir Borodin <root@simply.name>
  [2+ messages in thread]

using stale statistics instead of current ones because stats collector is not responding
  2016-03-09 00:18 UTC  Tory M Blue <tmblue@gmail.com>
` Re: using stale statistics instead of current ones because stats collector is not responding
  2016-03-09 11:37 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [2+ messages in thread]

Odd behavior with indices
  2016-02-26 19:43 UTC  joe meiring <josephmeiring@gmail.com>
` Re: Odd behavior with indices
  2016-02-26 20:02 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Odd behavior with indices
  2016-02-26 20:38 UTC  joe meiring <josephmeiring@gmail.com>
` Re: Odd behavior with indices
  2016-02-26 20:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Odd behavior with indices
  2016-02-28 13:26 UTC  Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Odd behavior with indices
  2016-02-29 18:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd behavior with indices
  2016-03-04 22:18 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Odd behavior with indices
  2016-03-04 23:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox