pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgresql 10.1 scanning all partitions instead of 1
  2018-02-04 09:23 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 scanning all partitions instead of 1
  2018-02-04 09:28 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [2+ messages in thread]

Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-01 14:30 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 09:36 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 14:04 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 15:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 15:49 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 15:58 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
  2018-02-02 17:01 UTC  Nandakumar M <m.nanda92@gmail.com>
  [7+ messages in thread]

bad plan using nested loops
  2018-02-01 10:42 UTC  Johan Fredriksson <eskil@kth.se>
` Re: bad plan using nested loops
  2018-02-01 15:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

8.2 Autovacuum BUG ?
  2007-08-31 15:30 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 15:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 16:05 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 16:11 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 16:25 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 16:29 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 17:46 UTC  Chris Browne <cbbrowne@acm.org>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 18:31 UTC  Mikko Partio <mpartio@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 18:42 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 18:47 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 18:51 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 19:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 19:13 UTC  Chris Browne <cbbrowne@acm.org>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 19:35 UTC  Erik Jones <erik@myemma.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 19:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 23:24 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: 8.2 Autovacuum BUG ?
  2007-08-31 23:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
  2018-01-22 06:09 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-22 09:41 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: 8.2 Autovacuum BUG ?
  2018-01-22 10:21 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-22 11:47 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 07:04 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 11:51 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 14:17 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 14:39 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 14:45 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 14:57 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 15:20 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 15:26 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 16:07 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 16:16 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-23 22:59 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 06:54 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 07:42 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 11:50 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 14:27 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 14:48 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 14:57 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-24 15:19 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: 8.2 Autovacuum BUG ?
  2018-01-25 03:47 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-25 21:30 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: 8.2 Autovacuum BUG ?
  2018-01-26 00:32 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-29 04:46 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-30 13:55 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-01-30 16:13 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
  2018-02-01 06:18 UTC  pavan95 <pavan.postgresdba@gmail.com>
  [46+ messages in thread]

Nested Loops
  2018-01-31 06:37 UTC  Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Nested Loops
  2018-01-31 08:42 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

SV: pgaudit and create postgis extension logs a lot inserts
  2018-01-19 11:03 UTC  Svensson Peter <peter.svensson@smhi.se>
` SV: pgaudit and create postgis extension logs a lot inserts
  2018-01-22 08:20 UTC  Svensson Peter <peter.svensson@smhi.se>
` Re: SV: pgaudit and create postgis extension logs a lot inserts
  2018-01-30 15:26 UTC  Bruce Momjian <bruce@momjian.us>
  [3+ messages in thread]

PostgreSQL 10.1 partitions and indexes
  2018-01-29 10:30 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>

performance drop after upgrade (9.6 > 10)
  2017-10-11 11:06 UTC  johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-11 11:11 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-11 12:19 UTC  johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-24 14:15 UTC  johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-24 15:18 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-24 15:57 UTC  Johannes Graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-24 16:17 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: performance drop after upgrade (9.6 > 10)
  2017-10-26 19:45 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: [PERFORM] performance drop after upgrade (9.6 > 10)
  2018-01-28 23:53 UTC  Bruce Momjian <bruce@momjian.us>
  [9+ messages in thread]

Query Slow After 2018
  2018-01-28 17:32 UTC  Nur Agus <nuragus.linux@gmail.com>
` Re: Query Slow After 2018
  2018-01-28 17:51 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Slow After 2018
  2018-01-28 21:40 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [3+ messages in thread]

SV: copy csv into partitioned table with unique index
  2018-01-28 11:57 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` SV: copy csv into partitioned table with unique index
  2018-01-28 12:04 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
  [2+ messages in thread]

copy csv into partitioned table with unique index
  2018-01-28 09:11 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: copy csv into partitioned table with unique index
  2018-01-28 10:55 UTC  legrand legrand <legrand_legrand@hotmail.com>
  [2+ messages in thread]

PG 10 hash index create times
  2018-01-26 10:58 UTC  Rick Otten <rottenwindfish@gmail.com>

need help on memory allocation
  2018-01-18 15:25 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: need help on memory allocation
  2018-01-19 10:07 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: need help on memory allocation
  2018-01-23 13:59 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: need help on memory allocation
  2018-01-23 14:08 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: need help on memory allocation
  2018-01-23 18:36 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: need help on memory allocation
  2018-01-23 22:36 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: need help on memory allocation
  2018-01-24 05:54 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: need help on memory allocation
  2018-01-24 07:15 UTC  Michael Paquier <michael.paquier@gmail.com>
` Re: need help on memory allocation
  2018-01-24 07:34 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: need help on memory allocation
  2018-01-24 08:03 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
  [10+ messages in thread]

Performance impact of lowering max_files_per_process
  2018-01-19 16:48 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Performance impact of lowering max_files_per_process
  2018-01-24 07:09 UTC  Thomas Kellerer <spam_eater@gmx.net>
  [2+ messages in thread]

bad plan
  2005-03-08 10:32 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
  2005-03-08 11:39 UTC  Richard Huxton <dev@archonet.com>
` Re: bad plan
  2005-03-08 12:22 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
  2005-03-08 13:20 UTC  Richard Huxton <dev@archonet.com>
` Re: bad plan
  2005-03-08 18:35 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
  2005-03-08 19:20 UTC  Richard Huxton <dev@archonet.com>
` Re: bad plan
  2005-03-08 20:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad plan
  2005-03-08 20:25 UTC  Richard Huxton <dev@archonet.com>
` Re: bad plan
  2005-03-08 20:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad plan
  2005-03-09 00:47 UTC  Gaetano Mendola <mendola@bigfoot.com>
` bad plan
  2012-04-05 11:47 UTC  Julien Cigar <jcigar@ulb.ac.be>
` Re: bad plan
  2012-04-05 14:26 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: bad plan
  2012-04-05 19:47 UTC  Ants Aasma <ants@cybertec.at>
` Re: bad plan
  2012-04-06 11:16 UTC  Julien Cigar <jcigar@ulb.ac.be>
` Bad plan
  2018-01-23 12:03 UTC  Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
  2018-01-23 15:18 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bad plan
  2018-01-23 15:38 UTC  Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
  2018-01-23 15:59 UTC  Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
  2018-01-23 17:18 UTC  Matthew Bellew <matthewb@labkey.com>
  [19+ messages in thread]

RE: Inefficient full seq scan on pg_largeobject instead of index scan
  2018-01-23 14:08 UTC  Jean-Marc Lessard <Jean-Marc.Lessard@ultra-ft.com>

query execution time (with cache)
  2018-01-21 18:43 UTC  Neto pr <netopr9@gmail.com>

pgaudit and create postgis extension logs a lot inserts
  2018-01-18 12:12 UTC  Svensson Peter <peter.svensson@smhi.se>
` Re: pgaudit and create postgis extension logs a lot inserts
  2018-01-18 16:54 UTC  Joe Conway <mail@joeconway.com>
` Re: pgaudit and create postgis extension logs a lot inserts
  2018-01-19 11:05 UTC  Magnus Hagander <magnus@hagander.net>
` RE: pgaudit and create postgis extension logs a lot inserts
  2018-01-19 12:24 UTC  Karen Stone <kstone@eldocomp.com>
` Re: pgaudit and create postgis extension logs a lot inserts
  2018-01-19 13:41 UTC  David Steele <david@pgmasters.net>
` Re: pgaudit and create postgis extension logs a lot inserts
  2018-01-19 13:51 UTC  David Steele <david@pgmasters.net>
` Re: pgaudit and create postgis extension logs a lot inserts
  2018-01-20 13:05 UTC  Magnus Hagander <magnus@hagander.net>
  [7+ messages in thread]

PGadmin error while connecting with database.
  2018-01-12 04:55 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: PGadmin error while connecting with database.
  2018-01-12 08:44 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: Re: PGadmin error while connecting with database.
  2018-01-14 04:10 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
  [3+ messages in thread]

Slow queries after Windows startup
  2018-01-11 08:19 UTC  POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` Re: Slow queries after Windows startup
  2018-01-11 09:01 UTC  Robert Zenz <robert.zenz@sibvisions.com>
` RE: Slow queries after Windows startup
  2018-01-11 09:06 UTC  POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` Re: Slow queries after Windows startup
  2018-01-11 09:54 UTC  Robert Zenz <robert.zenz@sibvisions.com>
` RE: Slow queries after Windows startup
  2018-01-11 13:36 UTC  POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` RE: Slow queries after Windows startup
  2018-01-11 21:08 UTC  Éric Fontaine <efontaine2@yahoo.fr>
  [6+ messages in thread]

Disjunctions and sequential scans
  2018-01-11 16:30 UTC  Ronuk Raval <ronuk.raval@gmail.com>

PG 9.5 2 tables same DDL with diff size
  2018-01-09 22:54 UTC  ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
` RE: PG 9.5 2 tables same DDL with diff size
  2018-01-10 15:14 UTC  Igor Neyman <ineyman@perceptron.com>
` RE: PG 9.5 2 tables same DDL with diff size
  2018-01-10 15:48 UTC  Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
` RE: PG 9.5 2 tables same DDL with diff size
  2018-01-10 16:10 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: PG 9.5 2 tables same DDL with diff size
  2018-01-10 18:49 UTC  ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
  [5+ messages in thread]

View preformance oracle to postgresql
  2018-01-09 21:32 UTC  Reddygari, Pavan <pkreddy@amazon.com>
` Re: View preformance oracle to postgresql
  2018-01-10 10:41 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: View preformance oracle to postgresql
  2018-01-10 13:58 UTC  Merlin Moncure <mmoncure@gmail.com>
  [3+ messages in thread]

Unable to connect Postgres using psql while postgres is already running.
  2018-01-10 09:01 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Unable to connect Postgres using psql while postgres is already running.
  2018-01-10 09:10 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Re: Unable to connect Postgres using psql while postgres is already running.
  2018-01-10 12:42 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
  [3+ messages in thread]

Performance of a Query
  2018-01-09 21:18 UTC  Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
  2018-01-09 22:08 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
  2018-01-09 22:25 UTC  Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
  2018-01-09 22:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
  2018-01-09 23:09 UTC  Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
  2018-01-09 23:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
  2018-01-10 03:29 UTC  Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Performance of a Query
  2018-01-10 08:51 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [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