pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Savepoint and Releasepoint in Logs
  2016-06-17 15:19 UTC  e.ratnakar.shetty@accenture.com
` Re: Savepoint and Releasepoint in Logs
  2016-06-19 16:55 UTC  Jeff Janes <jeff.janes@gmail.com>
  [2+ messages in thread]

index not used
  2005-04-21 19:05 UTC  Enrico Weigelt <weigelt@metux.de>
` Re: index not used
  2005-04-21 19:23 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: index not used
  2005-04-21 20:39 UTC  Litao Wu <litaowu@yahoo.com>
` Re: index not used
  2005-04-21 21:15 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Index not used
  2016-06-16 07:58 UTC  meike.talbach@women-at-work.org
` Re: Index not used
  2016-06-16 12:27 UTC  John Gorman <jgorman@eldocomp.com>
` Re: Index not used
  2016-06-16 15:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index not used
  2016-06-16 15:53 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Index not used
  2016-06-19 09:59 UTC  meike.talbach@women-at-work.org
  [9+ messages in thread]

9.6 query slower than 9.5.3
  2016-06-17 01:56 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 02:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 02:09 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 02:14 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 02:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 03:36 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 03:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 04:07 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 15:18 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: 9.6 query slower than 9.5.3
  2016-06-17 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [10+ messages in thread]

Indexes for hashes
  2016-06-15 09:34 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-15 12:45 UTC  Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: Indexes for hashes
  2016-06-15 13:03 UTC  ktm@rice.edu <ktm@rice.edu>
` Re: Indexes for hashes
  2016-06-15 13:09 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-15 13:16 UTC  ktm@rice.edu <ktm@rice.edu>
` Re: Indexes for hashes
  2016-06-15 13:38 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: Indexes for hashes
  2016-06-15 13:54 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-15 13:58 UTC  julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Indexes for hashes
  2016-06-15 14:00 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-15 14:20 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-15 14:36 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Indexes for hashes
  2016-06-15 14:53 UTC  ktm@rice.edu <ktm@rice.edu>
` Re: Indexes for hashes
  2016-06-15 15:14 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Indexes for hashes
  2016-06-17 03:51 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Indexes for hashes
  2016-06-17 04:09 UTC  julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Indexes for hashes
  2016-06-17 04:18 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Indexes for hashes
  2016-06-17 08:32 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Indexes for hashes
  2016-06-17 08:48 UTC  julyanto SUTANDANG <julyanto@equnix.co.id>
  [18+ messages in thread]

Many-to-many performance problem
  2016-06-10 13:04 UTC  Rowan Seymour <rowanseymour@gmail.com>
` Re: Many-to-many performance problem
  2016-06-10 14:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Many-to-many performance problem
  2016-06-10 14:27 UTC  Yves Dorfsman <yves@zioup.com>
` Re: Many-to-many performance problem
  2016-06-10 15:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Many-to-many performance problem
  2016-06-10 16:11 UTC  Alex Ignatov <a.ignatov@postgrespro.ru>
` Re: Many-to-many performance problem
  2016-06-16 08:29 UTC  Rowan Seymour <rowanseymour@gmail.com>
  [6+ messages in thread]

pg_restore seems very slow
  2016-06-15 22:00 UTC  Adrian Myers <hadrianmyers@gmail.com>
` Re: pg_restore seems very slow
  2016-06-15 22:08 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: pg_restore seems very slow
  2016-06-15 23:41 UTC  Adrian Myers <hadrianmyers@gmail.com>
` Re: pg_restore seems very slow
  2016-06-16 01:43 UTC  Adam Scott <adam.c.scott@gmail.com>
  [4+ messages in thread]

Clarification on using pg_upgrade
  2016-03-04 22:27 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Clarification on using pg_upgrade
  2016-03-04 22:58 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Clarification on using pg_upgrade
  2016-03-11 16:46 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Clarification on using pg_upgrade
  2016-03-24 17:43 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Clarification on using pg_upgrade
  2016-04-03 17:13 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Clarification on using pg_upgrade
  2016-04-20 04:01 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Clarification on using pg_upgrade
  2016-06-14 21:03 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Clarification on using pg_upgrade
  2016-06-14 21:08 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Clarification on using pg_upgrade
  2016-06-15 10:14 UTC  Glyn Astill <glynastill@yahoo.co.uk>
  [9+ messages in thread]

pg_database_size
  2016-06-04 07:35 UTC  sangeetha <tune2sangee@gmail.com>
` Re: pg_database_size
  2016-06-04 08:10 UTC  Venkata Balaji N <nag1010@gmail.com>
` Re: pg_database_size
  2016-06-14 21:00 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
  [3+ messages in thread]

array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 11:44 UTC  Nicolas Paris <niparisco@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 12:31 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 12:36 UTC  Nicolas Paris <niparisco@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 12:39 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 12:42 UTC  Nicolas Paris <niparisco@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 12:58 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 13:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-07 19:23 UTC  Nicolas Paris <niparisco@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-08 05:56 UTC  Michael Paquier <michael.paquier@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-08 06:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-09 13:31 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-09 13:43 UTC  Nicolas Paris <niparisco@gmail.com>
` Re: array size exceeds the maximum allowed (1073741823) when building a json
  2016-06-09 20:36 UTC  Merlin Moncure <mmoncure@gmail.com>
  [13+ messages in thread]

Performance of LIKE/NOT LIKE when used in single query
  2016-06-08 04:57 UTC  Ed Felstein <efelstein@gmail.com>
` Re: Performance of LIKE/NOT LIKE when used in single query
  2016-06-08 05:33 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Performance of LIKE/NOT LIKE when used in single query
  2016-06-09 16:37 UTC  Jeff Janes <jeff.janes@gmail.com>
  [3+ messages in thread]

Combination of partial and full indexes
  2016-06-07 13:39 UTC  Rafał Gutkowski <goodkowski@gmail.com>
` Re: Combination of partial and full indexes
  2016-06-07 17:36 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Combination of partial and full indexes
  2016-06-08 08:52 UTC  Rafał Gutkowski <goodkowski@gmail.com>
` Re: Combination of partial and full indexes
  2016-06-08 09:01 UTC  Rafał Gutkowski <goodkowski@gmail.com>
  [4+ messages in thread]

Locking concurrency: select for update vs update
  2016-06-07 07:31 UTC  Streamsoft - Mirek Szajowski <m.szajowski@streamsoft.pl>
` Re: Locking concurrency: select for update vs update
  2016-06-07 07:35 UTC  Szymon Lipiński <mabewlun@gmail.com>
` Re: Locking concurrency: select for update vs update
  2016-06-07 07:38 UTC  Streamsoft - Mirek Szajowski <m.szajowski@streamsoft.pl>
` Re: Locking concurrency: select for update vs update
  2016-06-07 13:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Locking concurrency: select for update vs update
  2016-06-07 13:26 UTC  Streamsoft - Mirek Szajowski <m.szajowski@streamsoft.pl>
  [5+ messages in thread]

similarity and operator '%'
  2016-05-30 17:53 UTC  Volker Boehm <volker@vboehm.de>
` Re: similarity and operator '%'
  2016-05-30 18:20 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: similarity and operator '%'
  2016-05-30 20:05 UTC  Jeff Janes <jeff.janes@gmail.com>
  [3+ messages in thread]

Planner chooses slow index heap scan despite accurate row estimates
  2016-05-27 19:08 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Planner chooses slow index heap scan despite accurate row estimates
  2016-05-27 23:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner chooses slow index heap scan despite accurate row estimates
  2016-05-27 23:30 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Re: Planner chooses slow index heap scan despite accurate row estimates
  2016-05-28 00:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner chooses slow index heap scan despite accurate row estimates
  2016-05-29 00:38 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Re: Planner chooses slow index heap scan despite accurate row estimates
  2016-05-30 19:34 UTC  Jeff Janes <jeff.janes@gmail.com>
  [6+ messages in thread]

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]


[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