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