pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Need Help on wal_compression
  2018-01-09 06:53 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: Need Help on wal_compression
  2018-01-09 16:53 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Need Help on wal_compression
  2018-01-09 20:39 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Need Help on wal_compression
  2018-01-09 21:33 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Need Help on wal_compression
  2018-01-10 01:24 UTC  Michael Paquier <michael.paquier@gmail.com>
  [5+ messages in thread]

Batch insert heavily affecting query performance.
  2017-12-24 19:51 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-24 23:52 UTC  MichaelDBA@sqlexec.com <michaeldba@sqlexec.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-25 00:09 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-25 01:30 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-25 02:59 UTC  Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-25 03:10 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 15:13 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 15:38 UTC  Rick Otten <rottenwindfish@gmail.com>
` RE: Batch insert heavily affecting query performance.
  2017-12-27 15:58 UTC  Mike Sofen <msofen@runbox.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 16:02 UTC  Jeremy Finzel <finzelj@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 16:23 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 16:23 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 16:34 UTC  Jean Baro <jfbaro@gmail.com>
` RE: Batch insert heavily affecting query performance.
  2017-12-27 16:36 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 16:37 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 17:02 UTC  Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 17:09 UTC  Alvaro Hernandez <aht@ongres.com>
` RE: Batch insert heavily affecting query performance.
  2017-12-27 17:10 UTC  Mike Sofen <msofen@runbox.com>
` Re: Batch insert heavily affecting query performance.
  2017-12-27 17:15 UTC  David Miller <miller392@yahoo.com>
` Re: Batch insert heavily affecting query performance.
  2018-01-09 19:45 UTC  Claudio Freire <klaussfreire@gmail.com>
  [20+ messages in thread]

Updating a large table
  2017-12-22 16:46 UTC  Timokhin Maxim <ncx2@yandex.com>
` Re: Updating a large table
  2017-12-23 11:31 UTC  salah jubeh <s_jubeh@yahoo.com>
` Re: Updating a large table
  2017-12-23 20:58 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Updating a large table
  2018-01-09 12:18 UTC  Timokhin Maxim <ncx2@yandex.com>
` Re: Updating a large table
  2018-01-09 12:53 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: Updating a large table
  2018-01-09 16:31 UTC  Timokhin Maxim <ncx2@yandex.com>
  [6+ messages in thread]

seeing lag in postgresql replication
  2018-01-08 09:21 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: seeing lag in postgresql replication
  2018-01-08 10:31 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [2+ messages in thread]

GEQO and join_collapse_limit correlation
  2018-01-05 14:30 UTC  Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
` Re: GEQO and join_collapse_limit correlation
  2018-01-05 16:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GEQO and join_collapse_limit correlation
  2018-01-05 20:17 UTC  Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
` Re: GEQO and join_collapse_limit correlation
  2018-01-05 20:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GEQO and join_collapse_limit correlation
  2018-01-06 11:31 UTC  Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
  [5+ messages in thread]

primary key hash index
  2018-01-02 14:02 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: primary key hash index
  2018-01-02 14:09 UTC  Magnus Hagander <magnus@hagander.net>
` Re: primary key hash index
  2018-01-04 20:01 UTC  Jeff Janes <jeff.janes@gmail.com>
  [3+ messages in thread]

Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04
  2018-01-02 13:27 UTC  Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04
  2018-01-02 13:30 UTC  Vasilis Ventirozos <v.ventirozos@gmail.com>
  [2+ messages in thread]

Re: partitioning an existing table - efficient pg_dump
  2017-12-30 18:42 UTC  Justin Pryzby <pryzby@telsasoft.com>

partitioning an existing table
  2017-12-30 04:37 UTC  Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: partitioning an existing table
  2017-12-30 05:38 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: partitioning an existing table
  2017-12-30 14:19 UTC  Robert Blayzor <rblayzor.bulk@inoc.net>
  [3+ messages in thread]

analyze stats: child vs parent
  2017-12-30 05:56 UTC  Justin Pryzby <pryzby@telsasoft.com>

Re: Table performance with millions of rows (partitioning)
  2017-12-28 01:20 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Table performance with millions of rows (partitioning)
  2017-12-28 01:27 UTC  Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: Table performance with millions of rows (partitioning)
  2017-12-28 02:22 UTC  pinker <pinker@onet.eu>
  [3+ messages in thread]

Table performance with millions of rows
  2017-12-28 00:54 UTC  Robert Blayzor <rblayzor.bulk@inoc.net>

Autoanalyze CPU usage
  2017-12-19 16:47 UTC  Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
  2017-12-19 17:09 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Autoanalyze CPU usage
  2017-12-19 22:03 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Autoanalyze CPU usage
  2017-12-19 22:53 UTC  Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
  2017-12-19 22:53 UTC  Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
  2017-12-19 22:55 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Autoanalyze CPU usage
  2017-12-20 01:10 UTC  Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Autoanalyze CPU usage
  2017-12-20 07:15 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Autoanalyze CPU usage
  2017-12-20 08:24 UTC  Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: Autoanalyze CPU usage
  2017-12-20 14:38 UTC  Habib Nahas <habibnahas@gmail.com>
  [10+ messages in thread]

WHERE IN for JOIN subquery?
  2017-12-19 00:00 UTC  Dave Johansen <davejohansen@gmail.com>
` Re: WHERE IN for JOIN subquery?
  2017-12-19 00:10 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: WHERE IN for JOIN subquery?
  2017-12-19 00:29 UTC  Dave Johansen <davejohansen@gmail.com>
  [3+ messages in thread]

Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
  2017-12-06 21:46 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
  2017-12-12 09:29 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
  2017-12-15 20:54 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
  2017-12-16 19:18 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
  2017-12-17 02:37 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [5+ messages in thread]

CPU 100% usage caused by unknown postgres process..
  2017-12-13 10:12 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: CPU 100% usage caused by unknown postgres process..
  2017-12-13 10:36 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: CPU 100% usage caused by unknown postgres process..
  2017-12-13 12:19 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: CPU 100% usage caused by unknown postgres process..
  2017-12-13 15:22 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [4+ messages in thread]

PostgreSQL database size is not reasonable
  2017-12-12 15:15 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: PostgreSQL database size is not reasonable
  2017-12-12 15:21 UTC  David G. Johnston <david.g.johnston@gmail.com>
` RE: PostgreSQL database size is not reasonable
  2017-12-12 15:44 UTC  Craig McIlwee <craigm@q-free.com>
` Re: PostgreSQL database size is not reasonable
  2017-12-12 15:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL database size is not reasonable
  2017-12-12 16:22 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: PostgreSQL database size is not reasonable
  2017-12-12 17:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Prepared Transactions
  2017-12-11 00:39 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Prepared Transactions
  2017-12-11 08:14 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: Prepared Transactions
  2017-12-11 12:13 UTC  jwhiting@redhat.com
  [3+ messages in thread]

Learning EXPLAIN
  2017-12-08 01:12 UTC  Flávio Henrique <yoshimit@gmail.com>
` Re: Learning EXPLAIN
  2017-12-08 13:20 UTC  Guillaume Lelarge <guillaume@lelarge.info>
` Re: Learning EXPLAIN
  2017-12-08 13:32 UTC  Flavio Henrique Araque Gurgel <fhagur@gmail.com>
` Re: Learning EXPLAIN
  2017-12-08 16:44 UTC  Gustavo Velasquez <gustavojunior@gmail.com>
` Re: Learning EXPLAIN
  2017-12-09 04:47 UTC  Sam Gendler <sgendler@ideasculptor.com>
` Re: Learning EXPLAIN
  2017-12-09 04:52 UTC  Sam Gendler <sgendler@ideasculptor.com>
  [6+ messages in thread]

Table with large number of int columns, very slow COPY FROM
  2017-12-08 04:21 UTC  Alex Tokarev <dwalin@dwalin.ru>
` Re: Table with large number of int columns, very slow COPY FROM
  2017-12-08 07:20 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Table with large number of int columns, very slow COPY FROM
  2017-12-08 18:17 UTC  Andres Freund <andres@anarazel.de>
  [3+ messages in thread]

Setting effective_io_concurrency in VM?
  2017-11-27 18:23 UTC  Don Seiler <don@seiler.us>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 18:40 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 21:06 UTC  Fernando Hevia <fhevia@gmail.com>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 21:44 UTC  Andrew Kerber <andrew.kerber@gmail.com>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 22:03 UTC  Don Seiler <don@seiler.us>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 23:18 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Setting effective_io_concurrency in VM?
  2017-11-27 23:57 UTC  Andres Freund <andres@anarazel.de>
` Re: Setting effective_io_concurrency in VM?
  2017-12-08 04:51 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [8+ messages in thread]

pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 14:28 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:25 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:27 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:34 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:37 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:44 UTC  Shaul Dar <shauldar@gmail.com>
` RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:44 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:48 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 16:57 UTC  Igor Neyman <ineyman@perceptron.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 17:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 18:39 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 18:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 18:53 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 18:59 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-21 21:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 03:48 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 06:18 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 10:32 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 12:17 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 13:06 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 16:56 UTC  Andres Freund <andres@anarazel.de>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 19:52 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 20:06 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-22 21:07 UTC  Patrick KUI-LI <pkuili@hipay.com>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-11-23 09:26 UTC  Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-12-07 12:46 UTC  Gunther <raj@gusw.net>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-12-07 17:31 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  2017-12-07 17:56 UTC  Claudio Freire <klaussfreire@gmail.com>
  [28+ messages in thread]

Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 10:11 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 15:11 UTC  Andres Freund <andres@anarazel.de>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 17:48 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 19:45 UTC  Andres Freund <andres@anarazel.de>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 21:25 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 21:39 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 23:04 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-07 23:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-11-08 09:31 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-12-07 12:54 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-12-07 16:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-12-07 16:15 UTC  Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
  2017-12-07 16:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [13+ messages in thread]

Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-03 04:04 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-03 23:21 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-03 23:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-04 00:27 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-05 18:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap scan is undercosted? - boolean correlation
  2017-12-07 04:51 UTC  Jeff Janes <jeff.janes@gmail.com>
  [6+ messages in thread]

insert and query performance on big string table with pg_trgm
  2017-11-20 22:54 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: insert and query performance on big string table with pg_trgm
  2017-11-21 01:42 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: insert and query performance on big string table with pg_trgm
  2017-11-21 08:05 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: insert and query performance on big string table with pg_trgm
  2017-11-25 06:35 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: insert and query performance on big string table with pg_trgm
  2017-11-25 09:19 UTC  Gábor SZŰCS <surrano@gmail.com>
` Re: insert and query performance on big string table with pg_trgm
  2017-12-06 06:15 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: insert and query performance on big string table with pg_trgm
  2017-12-06 07:23 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: insert and query performance on big string table with pg_trgm
  2017-12-07 02:04 UTC  Matthew Hall <mhall@mhcomputing.net>
  [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