pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOrdering on GIN Index
2016-12-14 02:18 UTC Rory <roryv@grindinggear.com>
Querying with multicolumn index
2016-12-09 17:00 UTC Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
2016-12-09 17:56 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Querying with multicolumn index
2016-12-09 18:58 UTC Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
2016-12-09 23:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
2016-12-10 08:06 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Querying with multicolumn index
2016-12-10 20:15 UTC Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
2016-12-10 20:34 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Querying with multicolumn index
2016-12-11 00:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
2016-12-11 00:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
2016-12-11 02:08 UTC Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
2016-12-11 06:04 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Querying with multicolumn index
2016-12-13 21:14 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
[12+ messages in thread]
Isolation of tx logs on VMware
2016-12-13 20:16 UTC ProPAAS DBA <dba@propaas.com>
` Re: Isolation of tx logs on VMware
2016-12-13 20:22 UTC Joshua D. Drake <jd@commandprompt.com>
[2+ messages in thread]
performance issue with bitmap index scans on huge amounts of big jsonb documents
2016-11-30 12:26 UTC Marc-Olaf Jaschke <marc-olaf.jaschke@s24.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
2016-12-05 02:28 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
2016-12-05 14:51 UTC Marc-Olaf Jaschke <marc-olaf.jaschke@s24.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
2016-12-09 17:03 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Slow query question
2016-12-06 14:35 UTC Andrey Povazhnyi <w0rse.t@gmail.com>
` Re: Slow query question
2016-12-06 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query question
2016-12-07 09:51 UTC Andrey Povazhnyi <w0rse.t@gmail.com>
[3+ messages in thread]
Substantial different index use between 9.5 and 9.6
2016-12-01 23:38 UTC Bill Measday <bill@measday.com>
` Re: Substantial different index use between 9.5 and 9.6
2016-12-01 23:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Substantial different index use between 9.5 and 9.6
2016-12-02 00:26 UTC Bill Measday <bill@measday.com>
` Re: Substantial different index use between 9.5 and 9.6
2016-12-02 15:41 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Substantial different index use between 9.5 and 9.6
2016-12-03 20:42 UTC Bill Measday <bill@measday.com>
[5+ messages in thread]
can trigger monitor two tables?
2016-11-28 08:59 UTC zhangkai.gis <zhangkai.gis@163.com>
` Re: can trigger monitor two tables?
2016-11-28 10:49 UTC Andreas Kretschmer <akretschmer@spamfence.net>
[2+ messages in thread]
Slow UPDATE in logs that's usually fast
2016-11-26 05:13 UTC Aldo Sarmiento <aldo@bigpurpledot.com>
Millions of tables
2016-09-26 02:50 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 03:04 UTC julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Millions of tables
2016-09-26 03:23 UTC Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
2016-09-26 04:05 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 04:19 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 05:04 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Millions of tables
2016-09-26 06:07 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
2016-09-26 06:28 UTC julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Millions of tables
2016-09-26 08:28 UTC Álvaro Hernández Tortosa <aht@8kdata.com>
` Re: Millions of tables
2016-09-26 09:43 UTC Stuart Bishop <stuart@stuartbishop.net>
` Re: Millions of tables
2016-09-26 10:23 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Millions of tables
2016-09-26 12:53 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 12:54 UTC Yves Dorfsman <yves@zioup.com>
` Re: Millions of tables
2016-09-26 13:05 UTC Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
2016-09-26 13:51 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 13:53 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 13:57 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 14:09 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 14:21 UTC Stuart Bishop <stuart@stuartbishop.net>
` Re: Millions of tables
2016-09-26 14:24 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-26 16:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
2016-09-26 16:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Millions of tables
2016-09-27 14:30 UTC Craig James <cjames@emolecules.com>
` Re: Millions of tables
2016-09-27 15:10 UTC Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
2016-09-27 15:42 UTC Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
2016-09-27 15:46 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-27 15:49 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-27 16:15 UTC Terry Schmitt <tschmitt@schmittworks.com>
` Re: Millions of tables
2016-09-27 16:27 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-28 15:39 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Millions of tables
2016-09-28 16:05 UTC Richard Albright <rla3rd@gmail.com>
` Re: Millions of tables
2016-09-28 16:27 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-28 17:27 UTC Stephen Frost <sfrost@snowman.net>
` Re: Millions of tables
2016-09-28 17:38 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-09-28 18:00 UTC Stephen Frost <sfrost@snowman.net>
` Re: Millions of tables
2016-09-29 08:21 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Millions of tables
2016-09-29 11:11 UTC Alex Ignatov (postgrespro) <a.ignatov@postgrespro.ru>
` Re: Millions of tables
2016-09-30 22:49 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Millions of tables
2016-10-01 17:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
2016-10-05 12:34 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
2016-10-08 21:42 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Millions of tables
2016-11-25 17:14 UTC Robert Klemme <shortcutter@googlemail.com>
[42+ messages in thread]
How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-23 22:15 UTC Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-24 04:19 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-24 08:17 UTC Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-24 11:46 UTC Imre Samu <pella.samu@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-24 15:31 UTC Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
2016-11-24 18:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
DO I miss something ?
2016-11-18 13:52 UTC Metatrader EA <metatraderea@gmail.com>
` Re: DO I miss something ?
2016-11-18 14:04 UTC vinny <vinny@xs4all.nl>
[2+ messages in thread]
Query hangs sometimes
2016-11-17 10:43 UTC Metatrader EA <metatraderea@gmail.com>
` Re: Query hangs sometimes
2016-11-17 11:02 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Query hangs sometimes
2016-11-17 11:55 UTC Metatrader EA <metatraderea@gmail.com>
` Re: Query hangs sometimes
2016-11-17 21:49 UTC Michael Paquier <michael.paquier@gmail.com>
[4+ messages in thread]
materialized view order by and clustering
2016-11-17 16:36 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: materialized view order by and clustering
2016-11-17 17:06 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Query planner chooses index scan backward instead of better index option
2016-11-14 12:01 UTC Seckin Pulatkan <seckinpulatkan@gmail.com>
` Re: Query planner chooses index scan backward instead of better index option
2016-11-14 16:50 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query planner chooses index scan backward instead of better index option
2016-11-15 08:44 UTC Seckin Pulatkan <seckinpulatkan@gmail.com>
` Re: Query planner chooses index scan backward instead of better index option
2016-11-17 12:33 UTC Seckin Pulatkan <seckinpulatkan@gmail.com>
[4+ messages in thread]
Run one query and execution time is very different
2016-11-16 09:10 UTC Metatrader EA <metatraderea@gmail.com>
Performance decrease after upgrade to 9.6.1
2016-11-15 21:57 UTC Gabriela Serventi <gabrielaserventi@hotmail.com>
` Re: Performance decrease after upgrade to 9.6.1
2016-11-15 22:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance decrease after upgrade to 9.6.1
2016-11-16 00:50 UTC Gabriela Serventi <gabrielaserventi@hotmail.com>
[3+ messages in thread]
Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
2016-11-14 11:45 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
2016-11-14 17:36 UTC domenico febbo <mimmopasticcio@gmail.com>
` Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
2016-11-14 20:50 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
2016-11-14 21:24 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
2016-11-15 23:47 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
Sql Query :: Any advice ?
2016-11-15 13:27 UTC Henrik Ekenberg <henrik@ekenberg.pw>
` Re: Sql Query :: Any advice ?
2016-11-15 13:50 UTC vinny <vinny@xs4all.nl>
` Re: Sql Query :: Any advice ?
2016-11-15 14:30 UTC Henrik Ekenberg <henrik@ekenberg.pw>
` Re: Sql Query :: Any advice ?
2016-11-15 15:44 UTC vinny <vinny@xs4all.nl>
` Re: Sql Query :: Any advice ?
2016-11-15 17:23 UTC Henrik <Henrik@ekenberg.pw>
[5+ messages in thread]
Why is the optimiser choosing a sub-optimal plan?
2016-11-14 17:53 UTC Stephen Cresswell <pgsql-performance@stephen-cresswell.net>
` Re: Why is the optimiser choosing a sub-optimal plan?
2016-11-14 19:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Inlining of functions (doing LIKE on an array)
2016-11-11 06:54 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-11 12:43 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-11 16:14 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-11 16:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-11 23:32 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-12 00:41 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-12 19:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inlining of functions (doing LIKE on an array)
2016-11-12 20:17 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
[8+ messages in thread]
Any advice tuning this query ?
2016-11-11 15:19 UTC Henrik Ekenberg <henrik@ekenberg.pw>
` Re: Any advice tuning this query ?
2016-11-11 15:55 UTC Devrim Gündüz <devrim@gunduz.org>
` Re: Any advice tuning this query ?
2016-11-11 16:22 UTC Andreas Karlsson <andreas@proxel.se>
` Re: Any advice tuning this query ?
2016-11-12 19:25 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Perf decreased although server is better
2016-11-02 13:26 UTC Benjamin Toueg <btoueg@gmail.com>
` Re: Perf decreased although server is better
2016-11-02 14:36 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Perf decreased although server is better
2016-11-02 14:38 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: Perf decreased although server is better
2016-11-02 14:55 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Perf decreased although server is better
2016-11-03 14:51 UTC Benjamin Toueg <btoueg@gmail.com>
` Re: Perf decreased although server is better
2016-11-04 00:05 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: Perf decreased although server is better
2016-11-04 11:53 UTC Benjamin Toueg <btoueg@gmail.com>
` Re: Perf decreased although server is better
2016-11-04 13:27 UTC Will Platnick <wplatnick@gmail.com>
` Re: Perf decreased although server is better
2016-11-04 13:29 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Perf decreased although server is better
2016-11-04 14:05 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: Perf decreased although server is better
2016-11-10 09:52 UTC Benjamin Toueg <btoueg@gmail.com>
[11+ messages in thread]
Tuning one Recurcive CTE
2016-11-09 13:05 UTC Henrik Ekenberg <henrik@ekenberg.pw>
` Re: Tuning one Recurcive CTE
2016-11-09 13:29 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Tuning one Recurcive CTE
2016-11-09 14:30 UTC Henrik Ekenberg <henrik@ekenberg.pw>
` Re: Tuning one Recurcive CTE
2016-11-09 16:22 UTC Andreas Joseph Krogh <andreas@visena.com>
[4+ messages in thread]
archive_command too slow.
2016-11-02 19:06 UTC Joao Junior <jcoj2006@gmail.com>
` Re: archive_command too slow.
2016-11-04 16:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: archive_command too slow.
2016-11-04 22:30 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: archive_command too slow.
2016-11-08 15:47 UTC Stephen Frost <sfrost@snowman.net>
[4+ messages in thread]
Query much slower after upgrade to 9.6.1
2016-11-07 15:52 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Query much slower after upgrade to 9.6.1
2016-11-07 18:05 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Query much slower after upgrade to 9.6.1
2016-11-07 19:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query much slower after upgrade to 9.6.1
2016-11-07 19:26 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Query much slower after upgrade to 9.6.1
2016-11-07 19:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query much slower after upgrade to 9.6.1
2016-11-07 20:31 UTC Adam Brusselback <adambrusselback@gmail.com>
[6+ 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