pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIncreased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6
2014-01-27 22:27 UTC Dattaram Porob <dattaram.porob@gmail.com>
` Fwd: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6
2014-01-27 22:31 UTC Dattaram Porob <dattaram.porob@gmail.com>
` Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6
2014-01-30 17:43 UTC Dattaram Porob <dattaram.porob@gmail.com>
` Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6
2014-02-05 01:32 UTC Claudio Freire <klaussfreire@gmail.com>
[4+ messages in thread]
Planner estimates and VACUUM/autovacuum
2014-02-03 18:57 UTC Artur Zając CFI <azajac@cfi.pl>
` Planner estimates and VACUUM/autovacuum
2014-02-03 19:29 UTC Artur Zając <azajac@ang.com.pl>
` Re: Planner estimates and VACUUM/autovacuum
2014-02-03 21:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
PostgreSQL 9.3.2 Performance tuning for 32 GB server
2014-01-25 06:32 UTC RAMAKRISHNAN KANDASAMY <ramky24@gmail.com>
` Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server
2014-01-31 13:55 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server
2014-02-02 23:52 UTC Tom Kincaid <tomjohnkincaid@gmail.com>
[3+ messages in thread]
trick the query optimiser to skip some optimisations
2014-01-29 23:38 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: trick the query optimiser to skip some optimisations
2014-01-29 23:50 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: trick the query optimiser to skip some optimisations
2014-01-30 00:17 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: trick the query optimiser to skip some optimisations
2014-01-30 20:36 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: trick the query optimiser to skip some optimisations
2014-01-30 22:03 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
WHERE with ORDER not using the best index
2014-01-29 21:19 UTC jugnooken <ken@jugnoo.com>
` Re: WHERE with ORDER not using the best index
2014-01-29 23:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: WHERE with ORDER not using the best index
2014-01-30 01:47 UTC jugnooken <ken@jugnoo.com>
` Re: WHERE with ORDER not using the best index
2014-01-30 16:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Select hangs and there are lots of files in table and index directories.
2014-01-27 22:06 UTC Peter Blair <petertblair@gmail.com>
` Re: Select hangs and there are lots of files in table and index directories.
2014-01-28 00:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select hangs and there are lots of files in table and index directories.
2014-01-28 14:47 UTC Peter Blair <petertblair@gmail.com>
` Re: Select hangs and there are lots of files in table and index directories.
2014-01-29 19:12 UTC Peter Blair <petertblair@gmail.com>
` Re: Select hangs and there are lots of files in table and index directories.
2014-01-29 22:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Slow query on join with Date >=
2014-01-28 22:01 UTC Jim Treinen <jtreinen@gmail.com>
Slow query (wrong index used maybe)
2014-01-27 14:44 UTC Stelian Iancu <stelian@iancu.ch>
` Re: Slow query (wrong index used maybe)
2014-01-27 15:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query (wrong index used maybe)
2014-01-27 17:20 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Slow query (wrong index used maybe)
2014-01-27 17:33 UTC Stelian Iancu <stelian@iancu.ch>
` Re: Slow query (wrong index used maybe)
2014-01-27 17:37 UTC Stelian Iancu <stelian@iancu.ch>
` Re: Slow query (wrong index used maybe)
2014-01-27 19:10 UTC bobJobS <russelljanusz@yahoo.com>
` Re: Slow query (wrong index used maybe)
2014-01-27 19:43 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Slow query (wrong index used maybe)
2014-01-28 08:29 UTC Stelian Iancu <stelian@iancu.ch>
` Re: Slow query (wrong index used maybe)
2014-01-28 13:39 UTC bobJobS <russelljanusz@yahoo.com>
[9+ messages in thread]
pg_repack solves alter table set tablespace lock
2014-01-24 20:48 UTC Ying He <yinghe0101@yahoo.com>
` Re: pg_repack solves alter table set tablespace lock
2014-01-24 21:42 UTC Josh Kupershmidt <schmiddy@gmail.com>
` Re: pg_repack solves alter table set tablespace lock
2014-01-27 14:15 UTC Ying He <yinghe0101@yahoo.com>
` Re: pg_repack solves alter table set tablespace lock
2014-01-27 14:24 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
[4+ messages in thread]
self join, parameterized base/join rel path row estimation and generally...
2014-01-27 05:58 UTC Bongseo Jang <graycells@gmail.com>
PostgreSQL 9.3.2 Performance issues
2014-01-24 16:23 UTC fburgess@radiantblue.com
` Re: PostgreSQL 9.3.2 Performance issues
2014-01-24 20:43 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ messages in thread]
Removing 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]
[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