pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRemoving nulls with 6NF
2014-01-23 16:34 UTC Robert DiFalco <robert.difalco@gmail.com>
Time of query result delivery
2014-01-20 13:55 UTC ARCEnergo <it@kipspb.ru>
` Re: Time of query result delivery
2014-01-21 18:55 UTC Josh Berkus <josh@agliodbs.com>
` Re: Time of query result delivery
2014-01-22 20:01 UTC Josh Berkus <josh@agliodbs.com>
[3+ messages in thread]
Increasing query time after updates
2014-01-21 06:26 UTC Katharina Koobs <katharina.koobs@uni-konstanz.de>
` Re: Increasing query time after updates
2014-01-21 08:06 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Increasing query time after updates
2014-01-21 08:37 UTC Katharina Koobs <katharina.koobs@uni-konstanz.de>
` Re: Increasing query time after updates
2014-01-21 08:45 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Increasing query time after updates
2014-01-21 10:57 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Increasing query time after updates
2014-01-21 18:53 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[6+ messages in thread]
Wrong index selection
2014-01-17 22:57 UTC Piotr Gasidło <quaker@barbara.eu.org>
` Re: Wrong index selection
2014-01-18 00:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Issue with query scanning through all data even with indexes
2014-01-09 21:36 UTC Kai Sellgren <kaisellgren@gmail.com>
` Re: Issue with query scanning through all data even with indexes
2014-01-16 15:41 UTC Igor Neyman <ineyman@perceptron.com>
[2+ messages in thread]
Slow counting on v9.3
2014-01-13 21:57 UTC Kai Sellgren <kaisellgren@gmail.com>
` Re: Slow counting on v9.3
2014-01-16 08:37 UTC Mehmet Çakoğlu <mehmetcakoglu@gmail.com>
` Re: Slow counting on v9.3
2014-01-16 08:42 UTC Guillaume Cottenceau <gc@mnc.ch>
[3+ messages in thread]
COMMIT stuck for days after bulk delete
2014-01-14 16:51 UTC Josh Kupershmidt <schmiddy@gmail.com>
` Re: COMMIT stuck for days after bulk delete
2014-01-14 17:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: COMMIT stuck for days after bulk delete
2014-01-14 18:24 UTC Josh Kupershmidt <schmiddy@gmail.com>
[3+ messages in thread]
PostgreSQL query for cache performance counters?
2014-01-10 09:46 UTC ambilalmca <ambilalmca@gmail.com>
query plan not optimal
2013-12-19 15:33 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: query plan not optimal
2013-12-19 18:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: query plan not optimal
2013-12-19 19:00 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: query plan not optimal
2013-12-19 20:36 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: query plan not optimal
2013-12-20 06:05 UTC Marc Cousin <cousinmarc@gmail.com>
` query plan not optimal
2013-12-29 18:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: query plan not optimal
2014-01-06 14:41 UTC Marc Cousin <cousinmarc@gmail.com>
[7+ messages in thread]
Wrong rows count estimation in query with simple UNION ALL leads to drammatically slow plan
2014-01-06 05:50 UTC Michael Kolomeitsev <mkolomeitsev@gmail.com>
window function induces full table scan
2014-01-02 21:32 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-02 21:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: window function induces full table scan
2014-01-02 22:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: window function induces full table scan
2014-01-02 22:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: window function induces full table scan
2014-01-02 22:45 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-02 23:12 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-02 23:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: window function induces full table scan
2014-01-03 00:13 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-03 04:37 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-03 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: window function induces full table scan
2014-01-03 17:44 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
` Re: window function induces full table scan
2014-01-03 18:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: window function induces full table scan
2014-01-03 18:25 UTC Thomas Mayer <thomas.mayer@student.kit.edu>
[13+ messages in thread]
DATE_TRUNC() and GROUP BY?
2013-12-20 00:35 UTC Dave Johansen <davejohansen@gmail.com>
` Re: DATE_TRUNC() and GROUP BY?
2013-12-21 05:46 UTC David Rowley <dgrowleyml@gmail.com>
` Re: DATE_TRUNC() and GROUP BY?
2014-01-02 18:39 UTC Dave Johansen <davejohansen@gmail.com>
` Re: DATE_TRUNC() and GROUP BY?
2014-01-02 19:36 UTC Dave Johansen <davejohansen@gmail.com>
` Re: DATE_TRUNC() and GROUP BY?
2014-01-02 19:47 UTC Dave Johansen <davejohansen@gmail.com>
[5+ messages in thread]
Recommendations for partitioning?
2013-12-05 15:36 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-07 17:09 UTC desmodemone <desmodemone@gmail.com>
` Re: Recommendations for partitioning?
2013-12-07 20:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Recommendations for partitioning?
2013-12-07 20:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Recommendations for partitioning?
2013-12-19 16:53 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-19 17:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Recommendations for partitioning?
2013-12-20 15:52 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-20 15:59 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Recommendations for partitioning?
2013-12-20 16:07 UTC bricklen <bricklen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-20 16:18 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Recommendations for partitioning?
2013-12-20 16:23 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-20 16:24 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Recommendations for partitioning?
2013-12-30 20:21 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: Recommendations for partitioning?
2013-12-30 21:29 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
[14+ messages in thread]
Possible regression (slow query on 9.2/9.3 when compared to 9.1)
2013-12-26 19:49 UTC Ronaldo Maia <romaia@async.com.br>
` Re: Possible regression (slow query on 9.2/9.3 when compared to 9.1)
2013-12-29 22:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Error install -pgmemcache
2013-11-20 12:36 UTC Rogerio Pereira <rogerio.pereira@riosoft.com.br>
` Re: Error install -pgmemcache
2013-12-29 20:08 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
[2+ messages in thread]
Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-27 06:35 UTC Michael Kolomeitsev <mkolomeitsev@gmail.com>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:03 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:19 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-29 00:52 UTC Michael Kolomeitsev <mkolomeitsev@gmail.com>
[5+ messages in thread]
Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 05:19 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 09:54 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 11:40 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:20 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:46 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:54 UTC Andrew Dunstan <andrew@dunslane.net>
[6+ messages in thread]
Does fsync on/off for wal AND Checkpoint?
2013-12-27 15:55 UTC GR Vishwanath <grv144@gmail.com>
` Re: Does fsync on/off for wal AND Checkpoint?
2013-12-27 16:27 UTC Andreas Karlsson <andreas@proxel.se>
[2+ messages in thread]
Re: How to completely delete iPhone all data before selling?
2013-12-26 08:46 UTC shirleymi <shirleymi@yeah.net>
Bytea(TOAST) vs large object facility(OID)
2013-12-23 20:16 UTC kosalram Babu Chellappa <kosalram@yahoo.com>
` Re: Bytea(TOAST) vs large object facility(OID)
2013-12-24 07:55 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[2+ messages in thread]
Optimizing a query
2006-12-13 18:48 UTC James Cloos <cloos@jhcloos.com>
` Re: Optimizing a query
2006-12-13 19:25 UTC Tomeh, Husam <htomeh@firstam.com>
` Re: Optimizing a query
2006-12-13 21:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing a query
2006-12-13 22:35 UTC James Cloos <cloos@jhcloos.com>
` Re: Optimizing a query
2006-12-13 23:15 UTC Tomeh, Husam <htomeh@firstam.com>
` Optimizing a query
2013-12-18 02:48 UTC Kai Sellgren <kaisellgren@gmail.com>
` Re: Optimizing a query
2013-12-19 17:53 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Optimizing a query
2013-12-24 00:32 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[8+ messages in thread]
slow query - will CLUSTER help?
2013-12-12 17:30 UTC Sev Zaslavsky <sevzas@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 18:19 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:14 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:34 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 21:24 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-20 14:42 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-20 16:11 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-20 21:19 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: slow query - will CLUSTER help?
2013-12-23 16:41 UTC Shaun Thomas <sthomas@optionshouse.com>
[10+ messages in thread]
Strange number of rows in plan cost
2013-12-23 06:32 UTC Алексей Кузнецов <alex_kuznetcov@mail.ru>
Unexpected pgbench result
2013-12-19 17:00 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-19 17:44 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Unexpected pgbench result
2013-12-19 22:06 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-20 14:10 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Unexpected pgbench result
2013-12-20 15:02 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-20 15:22 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Unexpected pgbench result
2013-12-20 15:40 UTC Dave Johansen <davejohansen@gmail.com>
[7+ messages in thread]
Regarding Hardware Tuning
2013-12-18 20:12 UTC prashant Pandey <prashantpandeyfun10@gmail.com>
` Re: Regarding Hardware Tuning
2013-12-19 23:40 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Regarding Hardware Tuning
2013-12-20 00:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Regarding Hardware Tuning
2013-12-20 14:29 UTC Shaun Thomas <sthomas@optionshouse.com>
[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