pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCPU 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]
[PATCH v1] Hand code string to integer conversion for performance.
2017-12-08 21:31 UTC Andres Freund <andres@anarazel.de>
[PATCH] Hand code string to int32 conversion for performance.
2017-12-08 21:31 UTC Andres Freund <andres@anarazel.de>
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]
Different 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>
[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