pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
shared memory size during upgrade pgsql with partitions
  2019-12-17 20:03 UTC  Piotr Włodarczyk <piotr.wlodarczyk@gnb.pl>
` Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)
  2019-12-18 04:01 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)
  2019-12-18 09:16 UTC  Piotr Włodarczyk <piotr.wlodarczyk@gnb.pl>
  [3+ messages in thread]

performance degredation after upgrade from 9.6 to 12
  2019-11-24 12:53 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 13:15 UTC  Thomas Poty <thomas.poty@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 13:19 UTC  Andrew Zakharov <Andrew898@mail.ru>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 13:51 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 15:22 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 15:30 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 18:05 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 20:00 UTC  John Felix <johnfelix@zeelandnet.nl>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 20:50 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-11-24 21:49 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-12-03 21:13 UTC  Andres Freund <andres@anarazel.de>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-12-16 11:48 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` RE: performance degredation after upgrade from 9.6 to 12
  2019-12-16 12:27 UTC  Andrew Zakharov <Andrew898@mail.ru>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-12-16 13:01 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance degredation after upgrade from 9.6 to 12
  2019-12-16 17:29 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [15+ messages in thread]

Legal disclaimers on emails to this group
  2019-12-06 18:42 UTC  Craig James <cjames@emolecules.com>
` Re: Legal disclaimers on emails to this group
  2019-12-06 19:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Legal disclaimers on emails to this group
  2019-12-06 22:42 UTC  Tim Cross <theophilusx@gmail.com>
` Re: Legal disclaimers on emails to this group
  2019-12-07 12:10 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` RE: Legal disclaimers on emails to this group
  2019-12-09 23:05 UTC  Mike Schanne <mschanne@kns.com>
` Re: Legal disclaimers on emails to this group
  2019-12-12 14:49 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Legal disclaimers on emails to this group
  2019-12-12 15:03 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
  [7+ messages in thread]

unexpected result for wastedbytes query after vacuum full
  2019-12-06 17:18 UTC  Mike Schanne <mschanne@kns.com>
` Re: unexpected result for wastedbytes query after vacuum full
  2019-12-06 23:28 UTC  Justin Pryzby <pryzby@telsasoft.com>
` RE: unexpected result for wastedbytes query after vacuum full
  2019-12-09 23:06 UTC  Mike Schanne <mschanne@kns.com>
` Re: unexpected result for wastedbytes query after vacuum full
  2019-12-10 16:43 UTC  Guillaume Lelarge <guillaume@lelarge.info>
` Re: unexpected result for wastedbytes query after vacuum full
  2019-12-10 19:48 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: unexpected result for wastedbytes query after vacuum full
  2019-12-11 15:23 UTC  Guillaume Lelarge <guillaume@lelarge.info>
  [6+ messages in thread]

Logical replication performance
  2019-11-29 16:06 UTC  Florian Philippon <florian.philippon@doctolib.com>
` Re: Logical replication performance
  2019-11-29 16:25 UTC  Flavio Henrique Araque Gurgel <fhagur@gmail.com>
` Re: Logical replication performance
  2019-12-09 22:31 UTC  Jeff Janes <jeff.janes@gmail.com>
  [3+ messages in thread]

Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
  2019-12-08 18:14 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
  2019-12-08 20:04 UTC  Joe Conway <mail@joeconway.com>
` Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
  2019-12-08 21:59 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
  [3+ messages in thread]

query that canceled isnt logged
  2019-12-08 13:08 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: query that canceled isnt logged
  2019-12-08 15:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query that canceled isnt logged
  2019-12-08 15:18 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: query that canceled isnt logged
  2019-12-08 15:23 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: query that canceled isnt logged
  2019-12-08 15:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

How to run in parallel in Postgres
  2019-12-05 12:10 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: How to run in parallel in Postgres
  2019-12-05 16:42 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to run in parallel in Postgres
  2019-12-06 08:39 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: How to run in parallel in Postgres
  2019-12-07 01:23 UTC  Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: How to run in parallel in Postgres
  2019-12-07 01:25 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: How to run in parallel in Postgres
  2019-12-07 11:17 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: How to run in parallel in Postgres
  2019-12-07 11:27 UTC  Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
  [7+ messages in thread]

autovacuum locking question
  2019-12-05 17:46 UTC  Mike Schanne <mschanne@kns.com>
` Re: autovacuum locking question
  2019-12-05 22:49 UTC  Michael Lewis <mlewis@entrata.com>
` RE: autovacuum locking question
  2019-12-05 23:18 UTC  Mike Schanne <mschanne@kns.com>
` Re: autovacuum locking question
  2019-12-05 23:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum locking question
  2019-12-05 23:55 UTC  Jeff Janes <jeff.janes@gmail.com>
` RE: autovacuum locking question
  2019-12-06 15:46 UTC  Mike Schanne <mschanne@kns.com>
` RE: autovacuum locking question
  2019-12-06 15:55 UTC  Mike Schanne <mschanne@kns.com>
` Re: autovacuum locking question
  2019-12-06 17:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum locking question
  2019-12-06 17:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum locking question
  2019-12-06 17:47 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: autovacuum locking question
  2019-12-06 17:49 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: autovacuum locking question
  2019-12-06 17:50 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: autovacuum locking question
  2019-12-07 00:59 UTC  Jeff Janes <jeff.janes@gmail.com>
  [13+ messages in thread]

threads (Re: Legal disclaimers on emails to this group)
  2019-12-06 21:55 UTC  Justin Pryzby <pryzby@telsasoft.com>

Postgres backup tool recommendations for multi-terabyte database in Google Cloud
  2019-12-05 17:47 UTC  Craig Jackson <craig.jackson@broadcom.com>
` Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud
  2019-12-05 19:51 UTC  Craig James <cjames@emolecules.com>
` Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud
  2019-12-05 21:05 UTC  Craig Jackson <craig.jackson@broadcom.com>
` Re: Postgres backup tool recommendations for multi-terabyte database in Google Cloud
  2019-12-05 21:08 UTC  Nikolay Samokhvalov <samokhvalov@gmail.com>
  [4+ messages in thread]

Make recently inserted/updated records available in the buffer/cache
  2019-12-02 17:03 UTC  Sachin Divekar <ssd532@gmail.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-02 17:13 UTC  Hüseyin Demir <demirhuseyinn.94@gmail.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-02 17:17 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-03 17:29 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-03 17:32 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-03 18:45 UTC  Sachin Divekar <ssd532@gmail.com>
` Re: Make recently inserted/updated records available in the buffer/cache
  2019-12-03 18:58 UTC  Michael Lewis <mlewis@entrata.com>
  [7+ messages in thread]

[External] Join queries slow with predicate, limit, and ordering
  2019-12-02 12:43 UTC  Aufar Gilbran <aufar.gilbran@grab.com>
` Re: [External] Join queries slow with predicate, limit, and ordering
  2019-12-03 00:38 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: [External] Join queries slow with predicate, limit, and ordering
  2019-12-03 07:50 UTC  Aufar Gilbran <aufar.gilbran@grab.com>
  [3+ messages in thread]

Considerable performance downgrade of v11 and 12 on Windows
  2019-11-29 10:04 UTC  Eugene Podshivalov <yaugenka@gmail.com>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-11-29 10:36 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-11-29 10:47 UTC  Eugene Podshivalov <yaugenka@gmail.com>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-11-29 12:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-11-29 12:22 UTC  Eugene Podshivalov <yaugenka@gmail.com>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-11-30 19:47 UTC  Eugene Podshivalov <yaugenka@gmail.com>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-12-02 09:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Considerable performance downgrade of v11 and 12 on Windows
  2019-12-02 19:03 UTC  Eugene Podshivalov <yaugenka@gmail.com>
  [8+ messages in thread]

Postgresql planning time too high
  2019-11-22 11:21 UTC  Sterpu Victor <victor@caido.ro>
` RE: Postgresql planning time too high
  2019-11-22 11:35 UTC  Fırat Güleç <firat.gulec@hepsijet.com>
` Re: Postgresql planning time too high
  2019-11-22 12:22 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Postgresql planning time too high
  2019-11-22 19:36 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [4+ messages in thread]

Hash Join over Nested Loop
  2019-11-22 17:33 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Hash Join over Nested Loop
  2019-11-22 17:43 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Hash Join over Nested Loop
  2019-11-22 17:55 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Hash Join over Nested Loop
  2019-11-22 18:48 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Hash Join over Nested Loop
  2019-11-22 18:54 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [5+ messages in thread]

Re[4]: Postgresql planning time too high
  2019-11-22 12:25 UTC  Sterpu Victor <victor@caido.ro>
` Re[4]: Postgresql planning time too high
  2019-11-22 12:44 UTC  Sterpu Victor <victor@caido.ro>
` Re[4]: Postgresql planning time too high
  2019-11-22 13:45 UTC  Sterpu Victor <victor@caido.ro>
` Re[4]: Postgresql planning time too high
  2019-11-22 14:06 UTC  Sterpu Victor <victor@caido.ro>
` Re: Re[4]: Postgresql planning time too high
  2019-11-22 14:29 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Re[4]: Postgresql planning time too high
  2019-11-22 18:13 UTC  Michael Lewis <mlewis@entrata.com>
  [6+ messages in thread]

Re[2]: Postgresql planning time too high
  2019-11-22 11:44 UTC  Sterpu Victor <victor@caido.ro>
` Re[2]: Postgresql planning time too high
  2019-11-22 11:46 UTC  Sterpu Victor <victor@caido.ro>
` RE: Re[2]: Postgresql planning time too high
  2019-11-22 12:05 UTC  Fırat Güleç <firat.gulec@hepsijet.com>
` Re: Re[2]: Postgresql planning time too high
  2019-11-22 12:59 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [4+ messages in thread]

Re[3]: Postgresql planning time too high
  2019-11-22 12:50 UTC  Sterpu Victor <victor@caido.ro>

Wrong estimations and NL Anti join poor performance
  2019-11-18 17:35 UTC  Andrew Zakharov <Andrew898@mail.ru>

Out of memory error on automatic vacuum
  2019-11-18 11:41 UTC  Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
  2019-11-18 12:25 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of memory error on automatic vacuum
  2019-11-18 14:02 UTC  Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
  2019-11-18 14:16 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of memory error on automatic vacuum
  2019-11-18 14:46 UTC  Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
  2019-11-18 15:10 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [6+ messages in thread]

Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-14 22:19 UTC  Craig James <cjames@emolecules.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-14 22:22 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-14 22:24 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-14 22:28 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-14 22:29 UTC  Andres Freund <andres@anarazel.de>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-15 21:06 UTC  Craig James <cjames@emolecules.com>
` RE: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-15 21:11 UTC  Ravi Rai <ravi.p.rai@live.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-15 22:44 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-16 00:26 UTC  Craig James <cjames@emolecules.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-16 15:16 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
  2019-11-16 17:17 UTC  Craig James <cjames@emolecules.com>
  [11+ messages in thread]

JSON path
  2019-11-14 13:55 UTC  Jesper Pedersen <jesper.pedersen@redhat.com>
` Re: JSON path
  2019-11-14 18:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: JSON path
  2019-11-14 20:46 UTC  Jesper Pedersen <jesper.pedersen@redhat.com>
  [3+ messages in thread]

Re:  parallel query
  2019-04-02 11:28 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Parallel Query
  2019-11-13 20:16 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
  2019-11-13 20:40 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
  2019-11-13 20:47 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Parallel Query
  2019-11-13 21:04 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
  2019-11-13 21:07 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
  2019-11-13 22:08 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
  2019-11-13 22:21 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
  2019-11-14 11:14 UTC  Luís Roberto Weck <luisroberto@siscobra.com.br>
  [9+ messages in thread]

Slow "not in array" operation
  2019-11-12 17:29 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-12 18:39 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
  2019-11-12 19:04 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-12 19:20 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
  2019-11-12 19:53 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow "not in array" operation
  2019-11-12 20:06 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-12 20:31 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
  2019-11-12 20:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow "not in array" operation
  2019-11-12 21:40 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-12 23:33 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 09:20 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 10:46 UTC  Morris de Oryx <morrisdeoryx@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 11:18 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 11:30 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 11:56 UTC  Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 12:18 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
  2019-11-13 16:15 UTC  Marco Colli <collimarco91@gmail.com>
  [17+ 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