pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance 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]
Which update action quicker?
2014-09-23 20:37 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: Which update action quicker?
2014-09-24 13:48 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Which update action quicker?
2014-09-24 14:13 UTC Emi Lu <emilu@encs.concordia.ca>
[3+ messages in thread]
query a table with lots of coulmns
2014-09-19 11:51 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: query a table with lots of coulmns
2014-09-19 12:04 UTC Szymon Guz <mabewlun@gmail.com>
` Re: query a table with lots of coulmns
2014-09-19 12:48 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: query a table with lots of coulmns
2014-09-19 13:32 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: query a table with lots of coulmns
2014-09-19 21:40 UTC Josh Berkus <josh@agliodbs.com>
` Re: query a table with lots of coulmns
2014-09-20 07:19 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
` Re: query a table with lots of coulmns
2014-09-20 10:36 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: query a table with lots of coulmns
2014-09-20 11:51 UTC Björn Wittich <Bjoern_Wittich@gmx.de>
[8+ messages in thread]
Aggregating tsqueries
2014-09-17 04:56 UTC Alexander Hill <alex@hill.net.au>
` Re: Aggregating tsqueries
2014-09-18 07:20 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[2+ messages in thread]
Postgres Replaying WAL slowly
2014-06-29 08:14 UTC Soni M <diptatapa@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-29 08:31 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Postgres Replaying WAL slowly
2014-06-29 12:43 UTC Soni M <diptatapa@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-29 13:05 UTC Soni M <diptatapa@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 07:05 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 14:46 UTC Soni M <diptatapa@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 16:14 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 17:04 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 17:14 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 17:29 UTC Soni M <diptatapa@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 18:34 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 18:39 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 18:40 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:17 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:25 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:42 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:54 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 19:57 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 20:15 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 20:21 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 20:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Replaying WAL slowly
2014-06-30 20:46 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 21:52 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 23:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Replaying WAL slowly
2014-06-30 23:17 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres Replaying WAL slowly
2014-06-30 23:57 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-07-01 17:12 UTC Jeff Frost <jeff@pgexperts.com>
` Re: Postgres Replaying WAL slowly
2014-07-01 19:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Replaying WAL slowly
2014-07-02 19:01 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres Replaying WAL slowly
2014-07-02 19:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Replaying WAL slowly
2014-07-03 09:34 UTC Simon Riggs <simon@2ndQuadrant.com>
` Re: Postgres Replaying WAL slowly
2014-09-17 17:15 UTC Simon Riggs <simon@2ndquadrant.com>
[33+ messages in thread]
How to interpret view pg_stat_bgwriter
2014-09-17 00:21 UTC Huang, Suya <Suya.Huang@au.experian.com>
Strange performance problem with query
2014-09-15 09:38 UTC Van Der Berg, Stefan <SvanderBerg@fnb.co.za>
` Re: Strange performance problem with query
2014-09-15 13:25 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Strange performance problem with query
2014-09-16 06:51 UTC Van Der Berg, Stefan <SvanderBerg@fnb.co.za>
[3+ messages in thread]
weird execution plan
2014-09-12 02:26 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: weird execution plan
2014-09-12 02:45 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: weird execution plan
2014-09-12 03:41 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: weird execution plan
2014-09-12 21:34 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: weird execution plan
2014-09-15 00:39 UTC Huang, Suya <Suya.Huang@au.experian.com>
[5+ messages in thread]
how to change the provoke table in hash join
2014-09-11 01:05 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: how to change the provoke table in hash join
2014-09-11 14:09 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: how to change the provoke table in hash join
2014-09-11 18:09 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: how to change the provoke table in hash join
2014-09-12 03:33 UTC Huang, Suya <Suya.Huang@au.experian.com>
[4+ messages in thread]
query performance with hstore vs. non-hstore
2014-09-01 06:10 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: query performance with hstore vs. non-hstore
2014-09-01 06:21 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: query performance with hstore vs. non-hstore
2014-09-01 06:54 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: query performance with hstore vs. non-hstore
2014-09-01 07:06 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: query performance with hstore vs. non-hstore
2014-09-02 00:53 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: query performance with hstore vs. non-hstore
2014-09-02 03:38 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: query performance with hstore vs. non-hstore
2014-09-04 07:33 UTC Huang, Suya <Suya.Huang@au.experian.com>
[7+ messages in thread]
Performance issue: index not used on GROUP BY...
2014-08-28 08:50 UTC gmb <gmbouwer@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 08:57 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 09:08 UTC gmb <gmbouwer@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 09:28 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 09:29 UTC Marti Raudsepp <marti@juffo.org>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 11:29 UTC gmb <gmbouwer@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 12:25 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Performance issue: index not used on GROUP BY...
2014-08-28 20:48 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance issue: index not used on GROUP BY...
2014-09-03 19:50 UTC gmb <gmbouwer@gmail.com>
[9+ messages in thread]
why after increase the hash table partitions, tpmc decrease
2014-09-02 06:59 UTC Xiaoyulei <xiaoyulei@huawei.com>
` Re: why after increase the hash table partitions, tpmc decrease
2014-09-03 00:12 UTC Takashi Horikawa <t-horikawa@aj.jp.nec.com>
[2+ messages in thread]
Implementing a functionality for processing heavy insertion
2014-09-02 14:44 UTC Shadin A <shadin__a@hotmail.com>
Very slow running query PostgreSQL 9.3.4
2014-08-29 04:28 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
` Re: Very slow running query PostgreSQL 9.3.4
2014-08-29 06:38 UTC Victor Yegorov <vyegorov@gmail.com>
[2+ messages in thread]
autocommit (true/false) for more than 1 million records
2014-08-22 20:49 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: autocommit (true/false) for more than 1 million records
2014-08-22 20:58 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-22 21:00 UTC Stephen Frost <sfrost@snowman.net>
` Re: autocommit (true/false) for more than 1 million records
2014-08-22 21:11 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: autocommit (true/false) for more than 1 million records
2014-08-22 21:21 UTC Stephen Frost <sfrost@snowman.net>
` Re: autocommit (true/false) for more than 1 million records
2014-08-25 13:40 UTC Emi Lu <emilu@encs.concordia.ca>
` Re: autocommit (true/false) for more than 1 million records
2014-08-25 13:51 UTC David Johnston <david.g.johnston@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-25 14:02 UTC Felipe Santos <felipepts@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-25 15:48 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-26 22:10 UTC Alex Goncharov <alex.goncharov.usa@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-26 22:33 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 01:20 UTC Alex Goncharov <alex.goncharov.usa@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 03:40 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 05:02 UTC Alex Goncharov <alex.goncharov.usa@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 06:10 UTC David Johnston <david.g.johnston@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 08:42 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 11:50 UTC Felipe Santos <felipepts@gmail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 12:41 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: autocommit (true/false) for more than 1 million records
2014-08-27 12:59 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: autocommit (true/false) for more than 1 million records
2014-08-28 14:49 UTC Emi Lu <emilu@encs.concordia.ca>
[20+ 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