pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM VERBOSE ANALYZE taking long time to process.
2015-09-09 10:43 UTC anil7385 <anilnk7385@gmail.com>
` Re: VACUUM VERBOSE ANALYZE taking long time to process.
2015-09-15 23:52 UTC Ben Chobot <bench@silentmedia.com>
[2+ messages in thread]
Server slowing down over time
2015-08-27 17:21 UTC Jean Cavallo <jean.cavallo@coopengo.com>
` Re: Server slowing down over time
2015-09-03 13:07 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Server slowing down over time
2015-09-04 06:13 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Server slowing down over time
2015-09-04 11:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Server slowing down over time
2015-09-14 22:08 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[5+ messages in thread]
Announcing the public availability of the TPCx-V prototype
2015-09-10 18:59 UTC Reza Taheri <rtaheri@vmware.com>
pg_stat_all_indexes understand
2015-07-09 12:20 UTC Nicolas Paris <niparisco@gmail.com>
` Re: pg_stat_all_indexes understand
2015-07-09 16:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_stat_all_indexes understand
2015-09-09 21:51 UTC Bruce Momjian <bruce@momjian.us>
[3+ messages in thread]
query with pg_trgm sometimes very slow
2015-09-02 14:00 UTC Volker Böhm <volker@vboehm.de>
` Re: query with pg_trgm sometimes very slow
2015-09-02 19:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-03 23:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 19:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 21:21 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 21:24 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 13:53 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 16:06 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 16:45 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 18:49 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 19:12 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 20:21 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:25 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:58 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:23 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:38 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 23:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 00:24 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 01:44 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 13:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:21 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:23 UTC Bruce Momjian <bruce@momjian.us>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:37 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-05 18:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-06 13:49 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-08 16:00 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-08 18:26 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
[23+ messages in thread]
PostgreSQL Tuning for Messaging/Messenger/Chatting Application
2015-09-02 12:16 UTC FattahRozzaq <ssoorruu@gmail.com>
` Re: PostgreSQL Tuning for Messaging/Messenger/Chatting Application
2015-09-03 13:40 UTC Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
[2+ messages in thread]
Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:09 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:03 UTC twoflower <standa.kurik@gmail.com>
` Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:19 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:22 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:46 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 20:24 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 20:30 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 21:00 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 07:53 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 09:45 UTC 林士博 <lin@repica.co.jp>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 09:51 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 10:15 UTC 林士博 <lin@repica.co.jp>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 10:25 UTC 林士博 <lin@repica.co.jp>
[15+ messages in thread]
Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:19 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
is there any way we can push join predicate into inner table
2015-08-31 13:51 UTC 挨踢人 <2363541664@qq.com>
` Re: is there any way we can push join predicate into inner table
2015-08-31 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Gist indexing performance with cidr types
2015-08-25 13:11 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-25 14:25 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 07:58 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 09:00 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 09:47 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 11:29 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 13:46 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 16:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Gist indexing performance with cidr types
2015-08-27 09:21 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-27 09:35 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-27 16:05 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-28 14:05 UTC Henrik Thostrup Jensen <htj@nordu.net>
[12+ messages in thread]
Index creation running now for 14 hours
2015-08-26 19:14 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index creation running now for 14 hours
2015-08-26 19:18 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Index creation running now for 14 hours
2015-08-26 19:25 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index creation running now for 14 hours
2015-08-26 19:36 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Index creation running now for 14 hours
2015-08-26 20:26 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index creation running now for 14 hours
2015-08-26 21:45 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
` Re: Index creation running now for 14 hours
2015-08-26 21:53 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index creation running now for 14 hours
2015-08-26 22:36 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index creation running now for 14 hours
2015-08-26 22:42 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index creation running now for 14 hours
2015-08-26 22:58 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
[10+ messages in thread]
Long running query: How to monitor the progress
2015-08-25 07:22 UTC Johann Spies <johann.spies@gmail.com>
` Re: Long running query: How to monitor the progress
2015-08-25 13:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
query not using GIN index
2015-08-22 01:55 UTC Guo, Yun <YGuo@cvent.com>
` Re: query not using GIN index
2015-08-22 04:36 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query not using GIN index
2015-08-24 14:45 UTC Guo, Yun <YGuo@cvent.com>
` Re: query not using GIN index
2015-08-24 15:08 UTC Guo, Yun <YGuo@cvent.com>
` Re: query not using GIN index
2015-08-24 17:04 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
problem with select *
2015-08-24 07:04 UTC bhuvan Mitra <bhuvanrjb@gmail.com>
` Re: problem with select *
2015-08-24 07:13 UTC Wei Shan <weishan.ang@gmail.com>
` Re: problem with select *
2015-08-24 08:59 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: problem with select *
2015-08-24 11:44 UTC Andrew Dunstan <andrew@dunslane.net>
[4+ messages in thread]
Performance bottleneck due to array manipulation
2015-08-21 12:48 UTC Genc, Ömer <Oemer.Genc@iais.fraunhofer.de>
` Re: Performance bottleneck due to array manipulation
2015-08-21 14:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance bottleneck due to array manipulation
2015-08-21 14:11 UTC Félix GERZAGUET <felix.gerzaguet@gmail.com>
` Re: Performance bottleneck due to array manipulation
2015-08-21 14:50 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Performance bottleneck due to array manipulation
2015-08-24 10:22 UTC Genc, Ömer <Oemer.Genc@iais.fraunhofer.de>
[5+ messages in thread]
Most efficient way of querying M 'related' tables where N out of M may contain the key
2015-08-21 00:03 UTC Stephane Bailliez <sbailliez@gmail.com>
` Re: Most efficient way of querying M 'related' tables where N out of M may contain the key
2015-08-21 00:19 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Most efficient way of querying M 'related' tables where N out of M may contain the key
2015-08-21 12:07 UTC Stephane Bailliez <sbailliez@gmail.com>
` Re: Most efficient way of querying M 'related' tables where N out of M may contain the key
2015-08-21 12:24 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
incredible surprise news from intel/micron right now...
2015-07-28 20:29 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: incredible surprise news from intel/micron right now...
2015-08-20 08:26 UTC Graeme B. Bell <graeme.bell@nibio.no>
[2+ messages in thread]
Strange query stalls on replica in 9.3.9
2015-08-13 17:09 UTC Josh Berkus <josh@agliodbs.com>
` Re: Strange query stalls on replica in 9.3.9
2015-08-13 20:24 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Strange query stalls on replica in 9.3.9
2015-08-13 20:59 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Strange query stalls on replica in 9.3.9
2015-08-14 16:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: Strange query stalls on replica in 9.3.9
2015-08-14 16:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Strange query stalls on replica in 9.3.9
2015-08-18 17:44 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Query Plan Performance on Partitioned Table
2015-08-11 08:46 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 11:43 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 13:44 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 13:53 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 14:00 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 14:01 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 14:42 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 14:51 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-11 17:03 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-12 01:49 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-12 07:00 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Query Plan Performance on Partitioned Table
2015-08-12 08:25 UTC Rural Hunter <ruralhunter@gmail.com>
[12+ messages in thread]
Slow HashAggregate/cache access
2015-08-05 01:41 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-05 17:24 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Slow HashAggregate/cache access
2015-08-05 18:25 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-05 19:29 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-05 19:55 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Slow HashAggregate/cache access
2015-08-05 20:53 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-05 21:00 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Slow HashAggregate/cache access
2015-08-05 21:06 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow HashAggregate/cache access
2015-08-05 22:07 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow HashAggregate/cache access
2015-08-05 23:58 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-06 01:09 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Slow HashAggregate/cache access
2015-08-06 10:05 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Slow HashAggregate/cache access
2015-08-10 03:16 UTC David Rowley <david.rowley@2ndquadrant.com>
[13+ messages in thread]
Performance issue with NestedLoop query
2015-07-30 07:51 UTC Ram N <yramiyer@gmail.com>
` Re: Performance issue with NestedLoop query
2015-07-30 20:24 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
` Re: Performance issue with NestedLoop query
2015-07-31 17:55 UTC Ram N <yramiyer@gmail.com>
` Re: Performance issue with NestedLoop query
2015-07-31 18:06 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Performance issue with NestedLoop query
2015-07-31 18:08 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Performance issue with NestedLoop query
2015-07-31 18:37 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
` Re: Performance issue with NestedLoop query
2015-08-05 03:40 UTC Ram N <yramiyer@gmail.com>
` Re: Performance issue with NestedLoop query
2015-08-05 17:12 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
[8+ messages in thread]
Are many idle connections bad?
2015-07-25 14:50 UTC Craig James <cjames@emolecules.com>
` Re: Are many idle connections bad?
2015-07-25 15:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Are many idle connections bad?
2015-07-25 16:06 UTC Craig James <cjames@emolecules.com>
` Re: Are many idle connections bad?
2015-07-26 00:43 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Are many idle connections bad?
2015-07-30 06:28 UTC Alex Hunsaker <badalex@gmail.com>
[5+ messages in thread]
autofreeze/vacuuming - avoiding the random performance hit
2015-07-28 15:39 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: autofreeze/vacuuming - avoiding the random performance hit
2015-07-28 15:51 UTC Wei Shan <weishan.ang@gmail.com>
` Re: autofreeze/vacuuming - avoiding the random performance hit
2015-07-28 16:16 UTC Graeme B. Bell <graeme.bell@nibio.no>
[3+ messages in thread]
Any ideas how can I speed up this query?
2015-07-28 07:52 UTC Priyank Tiwari <priyankgt@gmail.com>
` Re: Any ideas how can I speed up this query?
2015-07-28 08:19 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Any ideas how can I speed up this query?
2015-07-28 08:57 UTC 林士博 <lin@repica.co.jp>
[3+ 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