pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedupdating statistics on slow running query
2014-11-10 17:43 UTC Eric Ramirez <eric.ramirez.sv@gmail.com>
` Re: updating statistics on slow running query
2014-11-10 18:57 UTC desmodemone <desmodemone@gmail.com>
` Re: updating statistics on slow running query
2014-11-10 22:52 UTC Eric Ramirez <eric.ramirez.sv@gmail.com>
` Re: updating statistics on slow running query
2014-11-15 01:53 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[4+ messages in thread]
9.0 performance degradation with kernel 3.11
2014-11-13 08:10 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: 9.0 performance degradation with kernel 3.11
2014-11-14 16:08 UTC Glyn Astill <glynastill@yahoo.co.uk>
[2+ messages in thread]
Increased shared_buffer setting = lower hit ratio ?
2014-11-13 23:09 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Increased shared_buffer setting = lower hit ratio ?
2014-11-13 23:16 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Increased shared_buffer setting = lower hit ratio ?
2014-11-13 23:35 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Increased shared_buffer setting = lower hit ratio ?
2014-11-14 00:01 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Lock pileup causes server to stall
2014-11-10 19:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: Lock pileup causes server to stall
2014-11-10 21:40 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Lock pileup causes server to stall
2014-11-11 17:11 UTC Josh Berkus <josh@agliodbs.com>
` Re: Lock pileup causes server to stall
2014-11-11 17:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Lock pileup causes server to stall
2014-11-12 06:49 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Lock pileup causes server to stall
2014-11-12 13:51 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Lock pileup causes server to stall
2014-11-12 17:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: Lock pileup causes server to stall
2014-11-13 06:53 UTC Jesper Krogh <jesper@krogh.cc>
[8+ messages in thread]
trigger Before or After
2014-11-11 06:38 UTC avpro avpro <avprowebeden@gmail.com>
` Re: [GENERAL] trigger Before or After
2014-11-11 08:19 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: trigger Before or After
2014-11-11 13:58 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[3+ messages in thread]
Performance bug in prepared statement binding in 9.2?
2013-05-30 00:14 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-30 00:59 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-30 13:55 UTC Amit Kapila <amit.kapila@huawei.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-30 18:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-30 20:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-31 07:39 UTC Amit Kapila <amit.kapila@huawei.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-05-31 18:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-08-01 17:58 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-08-01 19:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 00:38 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 01:04 UTC Bruce Momjian <bruce@momjian.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 01:36 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 01:45 UTC Bruce Momjian <bruce@momjian.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 02:06 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 02:16 UTC Bruce Momjian <bruce@momjian.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 05:43 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 11:50 UTC Bruce Momjian <bruce@momjian.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 12:20 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 12:32 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 12:45 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 13:21 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 13:23 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-10 13:41 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-11 18:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-11 19:06 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-11 21:10 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-11 21:12 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-12 02:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-09-25 06:38 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-11-08 19:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-11-09 16:30 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-11-13 01:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-11-13 19:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2013-11-13 20:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bug in prepared statement binding in 9.2?
2013-12-31 17:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 18:48 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 18:59 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 19:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 19:08 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 19:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 19:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 20:13 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance bug in prepared statement binding in 9.2?
2014-11-10 23:51 UTC Josh Berkus <josh@agliodbs.com>
[43+ messages in thread]
9.3 performance issues, lots of bind and parse log entries
2014-11-04 17:01 UTC Tory M Blue <tmblue@gmail.com>
` Re: 9.3 performance issues, lots of bind and parse log entries
2014-11-04 20:07 UTC Tory M Blue <tmblue@gmail.com>
` Re: 9.3 performance issues, lots of bind and parse log entries
2014-11-04 20:31 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: 9.3 performance issues, lots of bind and parse log entries
2014-11-05 19:16 UTC Tory M Blue <tmblue@gmail.com>
` Re: 9.3 performance issues, lots of bind and parse log entries
2014-11-06 01:54 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: 9.3 performance issues, lots of bind and parse log entries
2014-11-10 18:56 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
Postgres does not use indexes with OR-conditions
2014-11-07 04:16 UTC arhipov <arhipov@dc.baikal.ru>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 04:38 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 05:06 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 13:55 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 14:17 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 15:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres does not use indexes with OR-conditions
2014-11-07 16:50 UTC David G Johnston <david.g.johnston@gmail.com>
[7+ messages in thread]
log_temp_files (integer), tuning work_mem
2014-11-05 21:32 UTC Tory M Blue <tmblue@gmail.com>
` Re: log_temp_files (integer), tuning work_mem
2014-11-06 06:31 UTC Guillaume Lelarge <guillaume@lelarge.info>
[2+ messages in thread]
Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-28 20:55 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-28 21:19 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-29 15:12 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-29 15:34 UTC Mathis, Jason <jmathis@enova.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-29 16:33 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-30 16:23 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-30 16:58 UTC Jerry Sievers <gsievers19@comcast.net>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-10-30 19:08 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-11-04 16:28 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
` Re: Incredibly slow restore times after 9.0>9.2 upgrade
2014-11-04 18:59 UTC jmcdonagh <Joseph.E.McDonagh@gmail.com>
[10+ messages in thread]
unnecessary sort in the execution plan when doing group by
2014-10-28 06:26 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: unnecessary sort in the execution plan when doing group by
2014-10-28 07:06 UTC David Rowley <dgrowleyml@gmail.com>
` Re: unnecessary sort in the execution plan when doing group by
2014-10-28 23:43 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: unnecessary sort in the execution plan when doing group by
2014-11-04 16:02 UTC Simon Riggs <simon@2ndQuadrant.com>
[4+ messages in thread]
Replication Lag Causes
2014-11-01 22:33 UTC Mike Wilson <mfwilson@gmail.com>
` Re: Replication Lag Causes
2014-11-01 23:14 UTC Valentine Gogichashvili <valgog@gmail.com>
` Re: Replication Lag Causes
2014-11-02 20:58 UTC Mike Wilson <mfwilson@gmail.com>
` Re: Replication Lag Causes
2014-11-02 21:16 UTC Mike Wilson <mfwilson@gmail.com>
` Re: Replication Lag Causes
2014-11-03 14:34 UTC Felipe Santos <felipepts@gmail.com>
` Re: Replication Lag Causes
2014-11-04 12:34 UTC Stuart Bishop <stuart@stuartbishop.net>
[6+ messages in thread]
assignment vs SELECT INTO
2014-11-03 20:00 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: assignment vs SELECT INTO
2014-11-03 20:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: assignment vs SELECT INTO
2014-11-03 20:27 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: assignment vs SELECT INTO
2014-11-03 20:31 UTC Andrew Dunstan <andrew@dunslane.net>
[4+ messages in thread]
Sanity checking big select performance
2014-10-28 21:15 UTC Jeff Chen <jeff@pixleeteam.com>
` Re: Sanity checking big select performance
2014-10-28 21:42 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Sanity checking big select performance
2014-10-29 13:47 UTC Kevin Grittner <kgrittn@ymail.com>
[3+ messages in thread]
extremly bad select performance on huge table
2014-10-21 17:26 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: extremly bad select performance on huge table
2014-10-21 17:35 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: extremly bad select performance on huge table
2014-10-21 17:39 UTC Igor Neyman <ineyman@perceptron.com>
` Re: extremly bad select performance on huge table
2014-10-21 19:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: extremly bad select performance on huge table
2014-10-21 19:32 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: extremly bad select performance on huge table
2014-10-21 19:53 UTC Igor Neyman <ineyman@perceptron.com>
` Re: extremly bad select performance on huge table
2014-10-22 05:05 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: extremly bad select performance on huge table
2014-10-22 13:57 UTC Igor Neyman <ineyman@perceptron.com>
` Re: extremly bad select performance on huge table
2014-10-22 14:53 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: extremly bad select performance on huge table
2014-10-22 15:13 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: extremly bad select performance on huge table
2014-10-24 05:16 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
[11+ messages in thread]
Checkpoints tuning
2014-10-23 13:24 UTC pinker <pinker@onet.eu>
Query with large number of joins
2014-10-20 20:32 UTC Marco Di Cesare <Marco.DiCesare@pointclickcare.com>
` Re: Query with large number of joins
2014-10-20 23:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with large number of joins
2014-10-21 10:45 UTC Felipe Santos <felipepts@gmail.com>
` Re: Query with large number of joins
2014-10-21 13:39 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query with large number of joins
2014-10-21 16:09 UTC Marco Di Cesare <Marco.DiCesare@pointclickcare.com>
` Re: Query with large number of joins
2014-10-21 16:31 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Query with large number of joins
2014-10-21 16:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with large number of joins
2014-10-21 16:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with large number of joins
2014-10-21 20:02 UTC Marco Di Cesare <Marco.DiCesare@pointclickcare.com>
` Re: Query with large number of joins
2014-10-21 20:06 UTC Marco Di Cesare <Marco.DiCesare@pointclickcare.com>
` Re: Query with large number of joins
2014-10-21 20:12 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Query with large number of joins
2014-10-22 13:22 UTC Merlin Moncure <mmoncure@gmail.com>
[12+ messages in thread]
IS NOT NULL and LEFT JOIN
2014-10-19 04:10 UTC Laurent Martelli <laurent.martelli@enercoop.org>
` Re: IS NOT NULL and LEFT JOIN
2014-10-19 08:41 UTC David Rowley <dgrowleyml@gmail.com>
` Re: IS NOT NULL and LEFT JOIN
2014-10-20 09:29 UTC Laurent Martelli <laurent.martelli@enercoop.org>
` Re: IS NOT NULL and LEFT JOIN
2014-10-20 13:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: IS NOT NULL and LEFT JOIN
2014-10-20 21:02 UTC Laurent Martelli <laurent.martelli@enercoop.org>
` Re: IS NOT NULL and LEFT JOIN
2014-10-20 22:19 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: IS NOT NULL and LEFT JOIN
2014-10-20 22:30 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: IS NOT NULL and LEFT JOIN
2014-10-21 08:44 UTC David Rowley <dgrowleyml@gmail.com>
` Re: IS NOT NULL and LEFT JOIN
2014-10-22 06:29 UTC Laurent Martelli <laurent.martelli@enercoop.org>
[9+ messages in thread]
ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine
2014-10-21 22:25 UTC Montana Low <montanalow@gmail.com>
` Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine
2014-10-21 22:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine
2014-10-21 22:46 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine
2014-10-21 22:55 UTC Montana Low <montanalow@gmail.com>
` Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine
2014-10-22 06:23 UTC Montana Low <montanalow@gmail.com>
[5+ messages in thread]
Query performance problem
2004-08-20 16:25 UTC Danilo Mota <dmota@nexen.com.br>
` Re: Query performance problem
2004-08-20 16:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance problem
2004-08-20 16:48 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Query performance problem
2004-08-20 16:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Query Performance Problem
2014-10-21 12:57 UTC john@jpm-cola.com
` Re: Query Performance Problem
2014-10-21 13:16 UTC Felipe Santos <felipepts@gmail.com>
[6+ messages in thread]
9.4 performance improvements test
2014-10-16 20:06 UTC Josh Berkus <josh@agliodbs.com>
CopyManager(In/out) vs. delete/insert directly
2014-10-16 18:30 UTC Emi Lu <emilu@encs.concordia.ca>
Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 12:35 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 13:19 UTC François Beausoleil <francois@teksol.info>
` Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 13:33 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 17:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 17:15 UTC Felipe Santos <felipepts@gmail.com>
` Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT
2014-10-16 17:22 UTC Дмитрий Шалашов <skaurus@gmail.com>
[6+ messages in thread]
char(N), varchar(N), varchar, text
2014-10-08 14:22 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: char(N), varchar(N), varchar, text
2014-10-08 14:30 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: char(N), varchar(N), varchar, text
2014-10-08 14:42 UTC Emi Lu <emilu@encs.concordia.ca>
[3+ messages in thread]
query plan question, nested loop vs hash join
2014-10-03 15:38 UTC Andrey Lizenko <lizenko79@gmail.com>
` query plan question, nested loop vs hash join
2014-10-05 18:57 UTC Andrey Lizenko <lizenko79@gmail.com>
` Re: query plan question, nested loop vs hash join
2014-10-05 19:18 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: query plan question, nested loop vs hash join
2014-10-05 19:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query plan question, nested loop vs hash join
2014-10-06 12:50 UTC Andrey Lizenko <lizenko79@gmail.com>
` Re: query plan question, nested loop vs hash join
2014-10-06 12:58 UTC Andrey Lizenko <lizenko79@gmail.com>
` Re: query plan question, nested loop vs hash join
2014-10-07 20:26 UTC Marti Raudsepp <marti@juffo.org>
` Re: query plan question, nested loop vs hash join
2014-10-08 09:48 UTC Andrey Lizenko <lizenko79@gmail.com>
[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