pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIndex 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]
hyperthreadin low performance
2015-07-21 02:59 UTC Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
` Re: hyperthreadin low performance
2015-07-21 08:04 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: hyperthreadin low performance
2015-07-21 09:07 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: hyperthreadin low performance
2015-07-23 11:37 UTC domenico febbo <mimmopasticcio@gmail.com>
` Re: hyperthreadin low performance
2015-07-25 04:10 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[5+ messages in thread]
bitmap heap scan recheck for gin/fts with no lossy blocks
2015-07-23 16:58 UTC Laurent Debacker <debackerl@gmail.com>
` Re: bitmap heap scan recheck for gin/fts with no lossy blocks
2015-07-23 18:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: bitmap heap scan recheck for gin/fts with no lossy blocks
2015-07-24 21:40 UTC Laurent Debacker <debackerl@gmail.com>
` Re: bitmap heap scan recheck for gin/fts with no lossy blocks
2015-07-24 22:27 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
parallelisation provides postgres performance (script example + ppt slides)
2015-07-23 13:45 UTC Graeme B. Bell <graeme.bell@nibio.no>
Re: hyperthreadin low performance (and some discussion about benchmarking)
2015-07-23 12:41 UTC Graeme B. Bell <graeme.bell@nibio.no>
How to find the culprit in server load spikes?
2015-07-22 12:50 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: How to find the culprit in server load spikes?
2015-07-22 16:40 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: How to find the culprit in server load spikes?
2015-07-22 17:18 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Different plan for very similar queries
2015-05-29 08:55 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Different plan for very similar queries
2015-05-29 09:51 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Different plan for very similar queries
2015-05-29 23:47 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Different plan for very similar queries
2015-05-30 19:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Different plan for very similar queries
2015-05-31 11:00 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Different plan for very similar queries
2015-05-31 15:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Different plan for very similar queries
2015-05-31 16:05 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Different plan for very similar queries
2015-05-31 16:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Different plan for very similar queries
2015-05-31 16:39 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Different plan for very similar queries
2015-07-19 20:41 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
[10+ messages in thread]
intel s3500 -- hot stuff
2014-11-05 17:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: intel s3500 -- hot stuff
2014-11-05 18:09 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: intel s3500 -- hot stuff
2014-12-06 13:08 UTC Bruce Momjian <bruce@momjian.us>
` Re: intel s3500 -- hot stuff
2014-12-08 21:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: intel s3500 -- hot stuff
2014-12-09 20:43 UTC Bruce Momjian <bruce@momjian.us>
` Re: intel s3500 -- hot stuff
2014-12-10 16:52 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: intel s3500 -- hot stuff
2015-07-18 10:03 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: [PERFORM] intel s3500 -- hot stuff
2015-07-18 10:17 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
[8+ messages in thread]
Re: could not create shared memory segment: Invalid argument
2015-07-14 00:08 UTC Ryan King - NOAA Affiliate <ryan.king@noaa.gov>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 00:15 UTC Scott Whitney <scott@journyx.com>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 00:16 UTC Scott Ribe <scott_ribe@elevated-dev.com>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 00:26 UTC Ryan King - NOAA Affiliate <ryan.king@noaa.gov>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 00:43 UTC Scott Ribe <scott_ribe@elevated-dev.com>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 00:49 UTC Ryan King - NOAA Affiliate <ryan.king@noaa.gov>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 01:15 UTC Scott Ribe <scott_ribe@elevated-dev.com>
` Re: could not create shared memory segment: Invalid argument
2015-07-14 13:59 UTC Andy Colson <andy@squeakycode.net>
` Re: could not create shared memory segment: Invalid argument
2015-07-15 14:13 UTC Ryan King - NOAA Affiliate <ryan.king@noaa.gov>
` Re: could not create shared memory segment: Invalid argument
2015-07-16 20:22 UTC Andy Colson <andy@squeakycode.net>
[10+ messages in thread]
Insert vs Update
2015-07-15 16:16 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Insert vs Update
2015-07-15 17:10 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Insert vs Update
2015-07-15 17:15 UTC Michael Nolan <htfoot@gmail.com>
` Re: Insert vs Update
2015-07-15 17:33 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Insert vs Update
2015-07-15 17:56 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Insert vs Update
2015-07-15 18:15 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Insert vs Update
2015-07-15 19:16 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Insert vs Update
2015-07-15 19:32 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Insert vs Update
2015-07-15 19:49 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Insert vs Update
2015-07-15 20:53 UTC Michael Nolan <htfoot@gmail.com>
` Re: Insert vs Update
2015-07-15 21:14 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Insert vs Update
2015-07-16 05:13 UTC Guillaume Lelarge <guillaume@lelarge.info>
[12+ messages in thread]
Query planner not using indexes with JOIN query and OR clause
2015-07-13 20:54 UTC Ben Hoyt <benhoyt@gmail.com>
` Re: Query planner not using indexes with JOIN query and OR clause
2015-07-13 21:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query planner not using indexes with JOIN query and OR clause
2015-07-14 13:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query planner not using indexes with JOIN query and OR clause
2015-07-14 20:17 UTC Ben Hoyt <benhoyt@gmail.com>
[4+ messages in thread]
Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-02 16:15 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 03:05 UTC Craig James <cjames@emolecules.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 05:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 11:06 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 17:48 UTC Craig James <cjames@emolecules.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 17:52 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 18:08 UTC Craig James <cjames@emolecules.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 18:46 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 20:27 UTC Andres Freund <andres@anarazel.de>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 22:38 UTC Craig James <cjames@emolecules.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-08 22:45 UTC Andres Freund <andres@anarazel.de>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 03:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 08:59 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 09:00 UTC Andres Freund <andres@anarazel.de>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 09:44 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 12:56 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 13:03 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 13:22 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 15:04 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 15:12 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 15:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-09 16:31 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
2015-07-11 23:18 UTC James Cloos <cloos@jhcloos.com>
[23+ 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