pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedno 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]
pg_basebackup running slow
2016-10-14 12:35 UTC Swapnil Vaze <swapvaze28@gmail.com>
` Re: pg_basebackup running slow
2016-10-14 13:21 UTC Samir Magar <samirmagar8@gmail.com>
` Re: pg_basebackup running slow
2016-10-14 13:37 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: pg_basebackup running slow
2016-10-14 13:37 UTC Stephen Frost <sfrost@snowman.net>
[4+ messages in thread]
Delay in converting logs from ready state to done state
2016-10-12 05:26 UTC Samir Magar <samirmagar8@gmail.com>
` Re: Delay in converting logs from ready state to done state
2016-10-12 06:03 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Fwd: Delay in converting logs from ready state to done state
2016-10-12 07:04 UTC Samir Magar <samirmagar8@gmail.com>
[3+ messages in thread]
Why query plan is different?
2016-10-10 15:31 UTC Andrzej Zawadzki <zawadaa@wp.pl>
` Re: Why query plan is different?
2016-10-10 17:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Why query plan is different?
2016-10-10 20:51 UTC Andrzej Zawadzki <zawadaa@gmail.com>
` Re: Why query plan is different?
2016-10-10 21:17 UTC Andrzej Zawadzki <zawadaa@gmail.com>
` Re: Why query plan is different?
2016-10-11 01:47 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Why query plan is different?
2016-10-11 11:19 UTC Andrzej Zawadzki <zawadaa@gmail.com>
` Re: Why query plan is different?
2016-10-11 11:21 UTC Pavel Stehule <pavel.stehule@gmail.com>
[7+ messages in thread]
MYSQL Stats
2016-09-30 12:03 UTC Joe Proietti <joe.proietti@cleargageinc.com>
` Re: MYSQL Stats
2016-09-30 13:44 UTC Joe Proietti <joe.proietti@cleargageinc.com>
` Re: MYSQL Stats
2016-10-04 04:20 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
[3+ messages in thread]
Understanding BRIN index performance
2016-10-03 09:00 UTC Ivan Voras <ivoras@gmail.com>
` Re: Understanding BRIN index performance
2016-10-03 09:26 UTC Madusudanan.B.N <b.n.madusudanan@gmail.com>
` Re: Understanding BRIN index performance
2016-10-03 09:40 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Understanding BRIN index performance
2016-10-03 09:58 UTC Ivan Voras <ivoras@gmail.com>
` Re: Understanding BRIN index performance
2016-10-03 10:05 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Understanding BRIN index performance
2016-10-03 11:29 UTC Ivan Voras <ivoras@gmail.com>
[6+ messages in thread]
Unexpected expensive index scan
2016-09-28 00:02 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-28 00:21 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-28 00:41 UTC Mike Sofen <msofen@runbox.com>
` Re: Unexpected expensive index scan
2016-09-28 01:03 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-28 01:24 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-28 02:45 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-28 13:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected expensive index scan
2016-09-28 18:11 UTC Jake Nielsen <jake.k.nielsen@gmail.com>
` Re: Unexpected expensive index scan
2016-09-30 22:19 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[9+ messages in thread]
Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 13:24 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 13:37 UTC Madusudanan.B.N <b.n.madusudanan@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 14:32 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 14:36 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 14:39 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-22 16:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-23 06:35 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 12:20 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 18:03 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 18:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 18:48 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 18:49 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 19:11 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 20:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-29 20:35 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-30 11:22 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
2016-09-30 11:29 UTC Sven R. Kunze <srkunze@mail.de>
[17+ messages in thread]
Failing Multi-Job Restores, Missing Indexes on Restore
2016-09-29 12:36 UTC Cea Stapleton <cea@healthfinch.com>
` Re: Failing Multi-Job Restores, Missing Indexes on Restore
2016-09-29 12:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Failing Multi-Job Restores, Missing Indexes on Restore
2016-09-29 12:56 UTC Cea Stapleton <cea@healthfinch.com>
` Re: Failing Multi-Job Restores, Missing Indexes on Restore
2016-09-29 13:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
PostgreSQL on ZFS: performance tuning
2016-07-29 06:04 UTC trafdev <trafdev@mail.ru>
` Re: PostgreSQL on ZFS: performance tuning
2016-07-29 06:30 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: PostgreSQL on ZFS: performance tuning
2016-07-29 06:47 UTC trafdev <trafdev@mail.ru>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-27 16:00 UTC Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-27 21:38 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-27 22:15 UTC Karl Denninger <karl@denninger.net>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-28 04:06 UTC Jov <zhao6014@gmail.com>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-28 04:11 UTC Jov <zhao6014@gmail.com>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-28 11:44 UTC Karl Denninger <karl@denninger.net>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-28 18:42 UTC trafdev <trafdev@mail.ru>
` Re: PostgreSQL on ZFS: performance tuning
2016-09-28 19:06 UTC Karl Denninger <karl@denninger.net>
[11+ messages in thread]
Storing large documents - one table or partition by doc?
2016-09-23 10:12 UTC Dev Nop <devnop0@gmail.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-23 12:14 UTC Mike Sofen <msofen@runbox.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-23 18:59 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-24 11:33 UTC Dev Nop <devnop0@gmail.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-24 21:30 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-26 00:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-26 08:27 UTC Dev Nop <devnop0@gmail.com>
` Re: Storing large documents - one table or partition by doc?
2016-09-26 19:58 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[8+ messages in thread]
temporary table vs array performance
2016-09-26 15:39 UTC dbyzaa@163.com <dbyzaa@163.com>
` Re: [HACKERS] temporary table vs array performance
2016-09-26 15:49 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: [HACKERS] temporary table vs array performance
2016-09-26 16:16 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: [HACKERS] temporary table vs array performance
2016-09-26 16:23 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-19 07:29 UTC Knels, Udo <U.Knels@treubuch-it.de>
` Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-21 21:48 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-22 12:39 UTC Knels, Udo <U.Knels@treubuch-it.de>
` Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-22 13:38 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-22 14:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
2016-09-26 15:59 UTC Knels, Udo <U.Knels@treubuch-it.de>
[6+ messages in thread]
Strange nested loop for an INSERT
2016-09-12 14:15 UTC phb07 <phb07@apra.asso.fr>
` Re: Strange nested loop for an INSERT
2016-09-12 14:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange nested loop for an INSERT
2016-09-12 18:05 UTC phb07 <phb07@apra.asso.fr>
` Re: Strange nested loop for an INSERT
2016-09-21 21:42 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Strange nested loop for an INSERT
2016-09-23 17:59 UTC phb07 <phb07@apra.asso.fr>
` Re: Strange nested loop for an INSERT
2016-09-23 18:51 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[6+ messages in thread]
query against single partition uses index, against master table does seq scan
2016-09-21 16:53 UTC Mike Broers <mbroers@gmail.com>
` Re: query against single partition uses index, against master table does seq scan
2016-09-21 17:15 UTC Ganesh Kannan <ganesh.kannan@weatheranalytics.com>
` Re: query against single partition uses index, against master table does seq scan
2016-09-21 17:37 UTC Mike Broers <mbroers@gmail.com>
` Re: query against single partition uses index, against master table does seq scan
2016-09-21 21:00 UTC Mike Broers <mbroers@gmail.com>
` Re: query against single partition uses index, against master table does seq scan
2016-09-22 02:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query against single partition uses index, against master table does seq scan
2016-09-22 04:09 UTC Mike Broers <mbroers@gmail.com>
` Re: query against single partition uses index, against master table does seq scan
2016-09-22 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ 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