pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery 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]
no MCV list of tiny table with unique columns
2016-11-02 18:53 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: no MCV list of tiny table with unique columns
2016-11-02 20:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: no MCV list of tiny table with unique columns
2016-11-02 20:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: no MCV list of tiny table with unique columns
2016-11-02 23:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: no MCV list of tiny table with unique columns
2016-11-05 22:36 UTC Justin Pryzby <pryzby@telsasoft.com>
[5+ messages in thread]
Big Memory Boxes and pgtune
2016-10-28 15:44 UTC Warner, Gary, Jr <gar@uab.edu>
` Re: Big Memory Boxes and pgtune
2016-10-28 17:09 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: Big Memory Boxes and pgtune
2016-10-28 19:33 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Big Memory Boxes and pgtune
2016-11-02 23:46 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Big Memory Boxes and pgtune
2016-11-04 02:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
[5+ messages in thread]
Hot migration of tables
2016-11-03 18:07 UTC YueLi <liyueam10@gmail.com>
query slowdown after 9.0 -> 9.4 migration
2016-10-26 13:48 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: query slowdown after 9.0 -> 9.4 migration
2016-10-26 22:55 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query slowdown after 9.0 -> 9.4 migration
2016-10-27 05:38 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: query slowdown after 9.0 -> 9.4 migration
2016-10-28 01:37 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: query slowdown after 9.0 -> 9.4 migration
2016-11-02 23:43 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[5+ messages in thread]
limit 1 on view never finishes
2016-10-27 20:46 UTC Craig James <cjames@emolecules.com>
` Re: limit 1 on view never finishes
2016-11-02 23:37 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
Refresh materialized view vs recreate
2016-11-01 06:26 UTC Антон Мазунин <mazuninanton@gmail.com>
` Re: Refresh materialized view vs recreate
2016-11-01 15:25 UTC Kevin Grittner <kgrittn@gmail.com>
[2+ messages in thread]
Tuning Checkpoints
2016-10-31 19:19 UTC Andre Henry <ahenry@thinkthroughmath.com>
` Re: Tuning Checkpoints
2016-10-31 21:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Fast insert, but slow join and updates for table with 4 billion rows
2016-10-24 08:11 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: Fast insert, but slow join and updates for table with 4 billion rows
2016-10-24 12:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fast insert, but slow join and updates for table with 4 billion rows
2016-10-24 20:07 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: Fast insert, but slow join and updates for table with 4 billion rows
2016-10-24 20:23 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Fast insert, but slow join and updates for table with 4 billion rows
2016-10-24 20:44 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: Fast insert, but slow join and updates for table with 4 billion rows
2016-10-25 20:52 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
[6+ messages in thread]
Performance of a nested loop, whose inner loop uses an index scan.
2016-10-19 10:54 UTC negora <public@negora.com>
` Re: Performance of a nested loop, whose inner loop uses an index scan.
2016-10-19 11:15 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Performance of a nested loop, whose inner loop uses an index scan.
2016-10-19 17:07 UTC negora <public@negora.com>
[3+ messages in thread]
Should I generate strings in Postgres of Python?
2016-10-18 20:35 UTC Bobby Mozumder <bmozumder@gmail.com>
` Re: Should I generate strings in Postgres of Python?
2016-10-18 22:53 UTC Sam Gendler <sgendler@ideasculptor.com>
[2+ messages in thread]
Hibernate generated query slow compared to 'equivalent' hand written one
2016-10-14 17:27 UTC Kyle Moser <moser.kyle@gmail.com>
` Re: Hibernate generated query slow compared to 'equivalent' hand written one
2016-10-14 17:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hibernate generated query slow compared to 'equivalent' hand written one
2016-10-14 18:09 UTC Kyle Moser <moser.kyle@gmail.com>
` Re: Hibernate generated query slow compared to 'equivalent' hand written one
2016-10-14 18:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ 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