pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication 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]
Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660
2014-10-07 10:13 UTC Vladimir Kamarzin <vvk@vvk.pp.ru>
` Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660
2014-10-07 13:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660
2014-10-08 08:40 UTC Vladimir Kamarzin <vvk@vvk.pp.ru>
[3+ messages in thread]
Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup
2014-10-08 06:35 UTC and <and.dietrich@gmail.com>
help: function failing
2014-10-02 23:00 UTC George Neuner <gneuner2@comcast.net>
` Re: help: function failing
2014-10-07 20:41 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: help: function failing
2014-10-07 21:27 UTC Andrew Dunstan <andrew@dunslane.net>
[3+ messages in thread]
pg_basebackup - odd performance
2014-10-06 18:53 UTC Mike Blackwell <mike.blackwell@rrd.com>
` Re: pg_basebackup - odd performance
2014-10-07 02:59 UTC Jov <amutu@amutu.com>
` Re: pg_basebackup - odd performance
2014-10-07 19:55 UTC Mike Blackwell <mike.blackwell@rrd.com>
[3+ messages in thread]
<idle> issue?
2014-10-06 14:54 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: <idle> issue?
2014-10-06 15:07 UTC Felipe Santos <felipepts@gmail.com>
` Re: <idle> issue?
2014-10-06 21:10 UTC jaime soler <jaime.soler@gmail.com>
[3+ messages in thread]
auto vaccum is dying
2014-10-02 04:43 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: auto vaccum is dying
2014-10-02 06:53 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: auto vaccum is dying
2014-10-02 07:42 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: auto vaccum is dying
2014-10-02 15:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: auto vaccum is dying
2014-10-04 17:31 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: auto vaccum is dying
2014-10-04 17:31 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: auto vaccum is dying
2014-10-04 18:12 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
Planning for Scalability
2014-10-03 08:55 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: Planning for Scalability
2014-10-03 10:47 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Planning for Scalability
2014-10-03 13:00 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Planning for Scalability
2014-10-03 13:43 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: Planning for Scalability
2014-10-03 16:33 UTC Claudio Freire <klaussfreire@gmail.com>
[5+ messages in thread]
performance of SELECT * much faster than SELECT <colname> with large offset
2014-10-03 02:17 UTC Marc Slemko <marcs@znep.com>
` Re: performance of SELECT * much faster than SELECT <colname> with large offset
2014-10-03 02:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: performance of SELECT * much faster than SELECT <colname> with large offset
2014-10-03 08:40 UTC Marti Raudsepp <marti@juffo.org>
[3+ messages in thread]
Very slow postgreSQL 9.3.4 query
2014-09-26 13:04 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-26 13:55 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-26 16:17 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-26 20:07 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-26 22:25 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-29 11:08 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Very slow postgreSQL 9.3.4 query
2014-09-30 02:59 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
[7+ messages in thread]
after upgrade 8.4->9.3 query is slow not using index scan
2014-09-26 14:04 UTC Matúš Svrček <svrcek@plaintext.sk>
` Re: after upgrade 8.4->9.3 query is slow not using index scan
2014-09-26 19:03 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: after upgrade 8.4->9.3 query is slow not using index scan
2014-09-28 20:24 UTC Matúš Svrček <svrcek@plaintext.sk>
[3+ messages in thread]
postgres 9.3 vs. 9.4
2014-09-18 09:58 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 10:17 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-18 13:49 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 14:56 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-18 15:09 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 17:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: postgres 9.3 vs. 9.4
2014-09-18 19:09 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 19:32 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: postgres 9.3 vs. 9.4
2014-09-18 19:50 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 20:32 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-18 20:56 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-18 21:01 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 21:10 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-18 21:28 UTC didier <did447@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-18 21:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-18 22:16 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-18 22:49 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-19 05:53 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-19 06:26 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-19 07:24 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-19 07:53 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-19 23:58 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-22 13:37 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-23 12:58 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-23 14:21 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-24 09:23 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-24 10:04 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: postgres 9.3 vs. 9.4
2014-09-24 13:03 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: postgres 9.3 vs. 9.4
2014-09-24 14:38 UTC Imre Samu <pella.samu@gmail.com>
` Re: postgres 9.3 vs. 9.4
2014-09-25 04:39 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[30+ 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