pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Different plan chosen when in lateral subquery
  2017-12-05 18:04 UTC  Alex Reece <awreece@gmail.com>
` Re: Different plan chosen when in lateral subquery
  2017-12-05 18:08 UTC  Alex Reece <awreece@gmail.com>
` Re: Different plan chosen when in lateral subquery
  2017-12-05 18:16 UTC  Alex Reece <awreece@gmail.com>
` Re: Different plan chosen when in lateral subquery
  2017-12-06 08:20 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [4+ messages in thread]

Half billion records in one table? RDS
  2017-11-27 17:58 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Half billion records in one table? RDS
  2017-11-27 18:18 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Half billion records in one table? RDS
  2017-12-06 01:59 UTC  Aaron Werman <aaron.werman@gmail.com>
  [3+ messages in thread]

Extremely slow DELETE with cascade foreign keys
  2017-12-05 16:21 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 16:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 16:43 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 17:00 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 17:22 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 17:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 17:27 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 17:49 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 18:15 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
` Re: Extremely slow DELETE with cascade foreign keys
  2017-12-05 18:17 UTC  Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
  [10+ messages in thread]

vacuum after truncate
  2017-12-05 14:03 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: vacuum after truncate
  2017-12-05 14:40 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

Bad plan for ltree predicate <@
  2017-12-01 17:20 UTC  Roman Konoval <rkonoval@gmail.com>
` Re: Bad plan for ltree predicate <@
  2017-12-01 21:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad plan for ltree predicate <@
  2017-12-02 02:34 UTC  Roman Konoval <rkonoval@gmail.com>
  [3+ messages in thread]

Delete tables difference involves seq scan
  2017-12-01 13:03 UTC  Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Delete tables difference involves seq scan
  2017-12-01 13:17 UTC  Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Delete tables difference involves seq scan
  2017-12-01 14:52 UTC  Danylo Hlynskyi <abcz2.uprola@gmail.com>
  [3+ messages in thread]

CREATE TABLE vs CREATE MATERIALIZED VIEW
  2017-11-30 12:07 UTC  Caio Guimarães Figueiredo <apoema.asa@gmail.com>

ODBC--call failed :: Bindings were not allocated properly
  2017-11-29 14:47 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>

Bad plan chosen for union all
  2017-11-28 10:13 UTC  Alex Reece <awreece@gmail.com>
` Re: Bad plan chosen for union all
  2017-11-29 03:39 UTC  Alex Reece <awreece@gmail.com>
` Re: Bad plan chosen for union all
  2017-11-29 04:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad plan chosen for union all
  2017-11-29 05:31 UTC  Alex Reece <awreece@gmail.com>
  [4+ messages in thread]

Invalid mem alloc request on function
  2017-11-28 18:56 UTC  bima p <internetuser2013@gmail.com>

Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 14:13 UTC  Dmitry Shalashov <skaurus@gmail.com>
` RE: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 14:24 UTC  Alex Ignatov <a.ignatov@postgrespro.ru>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 14:29 UTC  Dmitry Shalashov <skaurus@gmail.com>
` RE: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 14:44 UTC  Alex Ignatov <a.ignatov@postgrespro.ru>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 14:51 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 15:07 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 21:34 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-22 23:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-23 14:58 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-23 17:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-24 15:44 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-24 16:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-25 11:54 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-25 12:13 UTC  Michael Paquier <michael.paquier@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-25 15:39 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-25 15:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query became very slow after 9.6 -> 10 upgrade
  2017-11-25 18:59 UTC  Dmitry Shalashov <skaurus@gmail.com>
  [18+ messages in thread]

Issue with postgres login
  2017-11-24 03:27 UTC  Daulat Ram <Daulat.Ram@cyient.com>
` Re: Issue with postgres login
  2017-11-24 03:37 UTC  Bob Strecansky <bob@mailchimp.com>
` RE: Re: Issue with postgres login
  2017-11-24 04:04 UTC  Daulat Ram <Daulat.Ram@cyient.com>
` Re: Re: Issue with postgres login
  2017-11-24 04:07 UTC  Bob Strecansky <bob@mailchimp.com>
` RE: Re: Re: Issue with postgres login
  2017-11-24 04:23 UTC  Daulat Ram <Daulat.Ram@cyient.com>
` Re: Re: Re: Issue with postgres login
  2017-11-24 04:25 UTC  Bob Strecansky <bob@mailchimp.com>
` RE: Re: Re: Re: Issue with postgres login
  2017-11-24 06:49 UTC  Daulat Ram <Daulat.Ram@cyient.com>
  [7+ messages in thread]

pgpool + repmgr - who should be responsible for failover
  2017-11-23 18:14 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>

Re: bad estimates
  2003-08-29 03:46 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 04:05 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: bad estimates
  2003-08-29 04:09 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 04:24 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: bad estimates
  2003-08-29 07:01 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 07:57 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 08:10 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 08:15 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: bad estimates
  2003-08-29 08:17 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 12:52 UTC  Jeff <threshar@torgo.978.org>
` Re: bad estimates
  2003-08-29 15:02 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: bad estimates
  2003-08-29 16:06 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 16:36 UTC  Sean Chittenden <sean@chittenden.org>
` Re: bad estimates
  2003-08-29 16:56 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-29 17:03 UTC  Sean Chittenden <sean@chittenden.org>
` Re: bad estimates
  2003-08-30 02:55 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: bad estimates
  2003-08-30 05:05 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-30 07:38 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates
  2003-08-30 14:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Bad estimates
  2017-11-22 14:29 UTC  Artur Zając <azajac@ang.com.pl>
` Re: Bad estimates
  2017-11-22 14:49 UTC  Don Seiler <don@seiler.us>
` Re: Bad estimates
  2017-11-22 15:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: Bad estimates
  2017-11-22 15:05 UTC  Alex Ignatov <a.ignatov@postgrespro.ru>
` Re: Bad estimates
  2017-11-22 15:09 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Bad estimates
  2017-11-22 16:52 UTC  Artur Zając <azajac@ang.com.pl>
  [25+ messages in thread]

Re: Bad estimates (DEFAULT_UNK_SEL)
  2017-11-22 14:57 UTC  Justin Pryzby <pryzby@telsasoft.com>

Using GROUPING SETS with more than one set disables predicate pushdown?
  2017-11-21 11:04 UTC  Zakhar Shapurau <zak@zvs.no>
` Re: Using GROUPING SETS with more than one set disables predicate pushdown?
  2017-11-21 14:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using GROUPING SETS with more than one set disables predicate pushdown?
  2017-11-21 18:16 UTC  Andres Freund <andres@anarazel.de>
  [3+ messages in thread]

POWA doesn't show queries executed
  2017-11-18 01:52 UTC  Neto pr <netopr9@gmail.com>
` Re: [PERFORM] POWA doesn't show queries executed
  2017-11-21 08:00 UTC  phb07 <phb07@apra.asso.fr>
` Re: [PERFORM] POWA doesn't show queries executed
  2017-11-21 15:29 UTC  Marco Nietz <pg@mnietz.de>
  [3+ messages in thread]

Migration to pglister - Before
  2017-11-20 14:33 UTC  Stephen Frost <sfrost@snowman.net>
` Re: [ADMIN] Migration to pglister - Before
  2017-11-20 15:30 UTC  Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: [ADMIN] Migration to pglister - Before
  2017-11-20 15:34 UTC  Stephen Frost <sfrost@snowman.net>
  [3+ messages in thread]

Migration to PGLister - After
  2017-11-20 15:03 UTC  Stephen Frost <sfrost@snowman.net>

PostgreSQL 9.6 wals management
  2017-11-20 09:02 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: PostgreSQL 9.6 wals management
  2017-11-20 12:28 UTC  Michael Paquier <michael.paquier@gmail.com>
` Re: PostgreSQL 9.6 wals management
  2017-11-20 12:56 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [3+ messages in thread]

CREATE STATISTICS and join selectivity
  2017-11-15 20:19 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: CREATE STATISTICS and join selectivity
  2017-11-15 23:47 UTC  David Rowley <david.rowley@2ndquadrant.com>
  [2+ messages in thread]

Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 16:44 UTC  Oliver Mattos <omattos@gmail.com>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 20:06 UTC  Arne Roland <A.Roland@index.de>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 21:51 UTC  Oliver Mattos <omattos@gmail.com>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 22:48 UTC  Arne Roland <A.Roland@index.de>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 22:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-13 23:20 UTC  Oliver Mattos <omattos@gmail.com>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-14 21:26 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: Query planner gaining the ability to replanning after start of query execution.
  2017-11-15 19:57 UTC  Gunter <raj@gusw.net>
  [8+ messages in thread]

DB slowness after upgrade from Postgres 9.1 to 9.4
  2017-11-10 10:58 UTC  p kirti <kirtip92@gmail.com>
` Re: DB slowness after upgrade from Postgres 9.1 to 9.4
  2017-11-12 19:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

overestimate on empty table
  2017-11-10 20:40 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: overestimate on empty table
  2017-11-10 21:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: overestimate on empty table
  2017-11-11 17:19 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: overestimate on empty table
  2017-11-11 17:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Performance loss upgrading from 9.3 to 9.6
  2017-11-06 13:18 UTC  Adam Torres <atorres@amplify-nation.com>
` Re: Performance loss upgrading from 9.3 to 9.6
  2017-11-06 14:21 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance loss upgrading from 9.3 to 9.6
  2017-11-06 21:12 UTC  Adam Torres <atorres@amplify-nation.com>
` Re: Performance loss upgrading from 9.3 to 9.6
  2017-11-07 02:59 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Performance loss upgrading from 9.3 to 9.6
  2017-11-07 05:11 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [5+ 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