pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDifferent 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