pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
extract(year from date) doesn't use index but maybe could?
  2015-04-19 17:16 UTC  Jon Dufresne <jon.dufresne@gmail.com>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 17:42 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 20:10 UTC  Jon Dufresne <jon.dufresne@gmail.com>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 21:03 UTC  Adam Tauno Williams <awilliam@whitemice.org>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 21:12 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 21:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 22:05 UTC  Yves Dorfsman <yves@zioup.com>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-19 22:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-20 00:13 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: extract(year from date) doesn't use index but maybe could?
  2015-04-22 16:15 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
  [10+ messages in thread]

pushing order by + limit to union subqueries
  2015-02-28 09:08 UTC  Paolo Losi <paolo.losi@gmail.com>
` Re: pushing order by + limit to union subqueries
  2015-02-28 16:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] pushing order by + limit to union subqueries
  2015-04-16 18:49 UTC  Qingqing Zhou <zhouqq.postgres@gmail.com>
  [3+ messages in thread]

Performance of vacuumlo
  2015-04-15 01:46 UTC  Andreas Joseph Krogh <andreas@visena.com>

Some performance testing?
  2015-03-31 19:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
  2015-03-31 20:41 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
  2015-04-01 09:02 UTC  Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
  2015-04-03 17:44 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
  2015-04-06 20:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
  2015-04-07 16:46 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
  2015-04-07 17:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
  2015-04-07 18:07 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
  2015-04-08 19:05 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
  2015-04-08 21:29 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
  2015-04-08 22:09 UTC  Michael Nolan <htfoot@gmail.com>
` Re: Some performance testing?
  2015-04-09 09:04 UTC  Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
  2015-04-09 10:39 UTC  Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
  2015-04-09 11:01 UTC  Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
  2015-04-09 11:56 UTC  Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
  2015-04-09 13:35 UTC  Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
  2015-04-09 15:15 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Some performance testing?
  2015-04-09 15:20 UTC  Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Some performance testing?
  2015-04-10 13:21 UTC  Michael Nolan <htfoot@gmail.com>
` Re: Some performance testing?
  2015-04-10 13:29 UTC  Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
  2015-04-14 19:58 UTC  Josh Berkus <josh@agliodbs.com>
  [21+ messages in thread]

Cannot get query to use btree-gin index when ORDER BY
  2015-04-09 21:39 UTC  Andreas Joseph Krogh <andreas@visena.com>

NVMe or AHCI PCI-express? A comment for people benchmarking...
  2015-04-09 14:45 UTC  Graeme B. Bell <grb@skogoglandskap.no>

Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-01 13:56 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-01 14:27 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-01 14:32 UTC  Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-01 14:44 UTC  Wei Shan <weishan.ang@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-01 16:38 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 02:19 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 10:33 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 10:47 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 10:51 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 10:57 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 12:22 UTC  Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 12:29 UTC  didier <did447@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 12:51 UTC  Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 13:23 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 13:52 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 14:00 UTC  Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 14:25 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-02 15:11 UTC  didier <did447@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 13:43 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 13:55 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 15:00 UTC  Josh Krupka <jkrupka@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 15:10 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 15:21 UTC  Josh Krupka <jkrupka@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-03 15:33 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-07 16:49 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-07 17:17 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-07 17:45 UTC  Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
  2015-04-08 10:37 UTC  Pietro Pugni <pietro.pugni@gmail.com>
  [28+ messages in thread]

Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 08:53 UTC  Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 09:08 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 09:19 UTC  Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 09:41 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 13:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 15:58 UTC  Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-03-31 17:03 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-04-07 23:38 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
  2015-04-07 23:50 UTC  Qingqing Zhou <zhouqq.postgres@gmail.com>
  [9+ messages in thread]

views much slower in 9.3 than 8.4
  2015-03-18 17:00 UTC  Carson, Leonard <lcarson@sdsc.edu>
` Re: views much slower in 9.3 than 8.4
  2015-03-18 17:16 UTC  Kevin Grittner <kgrittn@ymail.com>
` Fwd: views much slower in 9.3 than 8.4
  2015-03-18 22:18 UTC  Carson, Leonard <lcarson@sdsc.edu>
` Re: Fwd: views much slower in 9.3 than 8.4
  2015-03-18 22:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
  2015-03-19 17:24 UTC  Carson, Leonard <lcarson@sdsc.edu>
` Re: views much slower in 9.3 than 8.4
  2015-03-19 23:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
  2015-03-28 17:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
  2015-03-30 14:46 UTC  Kevin Grittner <kgrittn@ymail.com>
` Re: views much slower in 9.3 than 8.4
  2015-03-30 15:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
  2015-04-07 23:30 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
  [10+ messages in thread]

Poor performing query re-write using tsrange index
  2015-04-02 03:26 UTC  Burgess, Freddie <FBurgess@Radiantblue.com>

Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 12:04 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 12:45 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 14:22 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 16:07 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 17:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 18:07 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 20:00 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-25 21:45 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 07:48 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 08:17 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 08:26 UTC  Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 12:44 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 16:35 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
  2015-03-26 22:19 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [14+ messages in thread]

query faster with a foreign table
  2015-03-26 10:46 UTC  Dominique Vallée <dominique.vallee@mnhn.fr>

Query RE: Optimising UUID Lookups
  2015-03-20 19:01 UTC  Roland Dunn <roland.dunn@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-21 09:10 UTC  Maxim Boguk <maxim.boguk@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-21 10:34 UTC  Roland Dunn <roland.dunn@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-24 05:28 UTC  Maxim Boguk <maxim.boguk@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-24 07:49 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-24 10:45 UTC  Roland Dunn <roland.dunn@gmail.com>
` Re: Query RE: Optimising UUID Lookups
  2015-03-24 11:43 UTC  Maxim Boguk <maxim.boguk@gmail.com>
  [7+ messages in thread]

Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-02-24 13:42 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-02-26 06:25 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-02-27 08:52 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-02-27 11:11 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-02-27 11:42 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: [GENERAL] Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-03 13:54 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-05 08:25 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-17 10:22 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: [GENERAL] Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-19 17:30 UTC  Sergey Shchukin <shchukin.s.a@gmail.com>
` Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-20 15:00 UTC  Vladimir Borodin <root@simply.name>
` Re: [GENERAL] [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
  2015-03-23 14:45 UTC  Vladimir Borodin <root@simply.name>
  [11+ messages in thread]

Performance issues
  2011-03-07 13:45 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-07 14:01 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Performance issues
  2011-03-07 14:17 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-07 14:22 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Performance issues
  2011-03-07 14:29 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-07 15:34 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Performance issues
  2011-03-07 21:49 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-07 23:29 UTC  David Kerr <dmk@mr-paradox.net>
` Re: Performance issues
  2011-03-08 00:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issues
  2011-03-08 08:42 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-08 15:21 UTC  Andy Colson <andy@squeakycode.net>
` Re: Performance issues
  2011-03-08 16:58 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-08 17:00 UTC  Andreas Forø Tollefsen <andreasft@gmail.com>
` Re: Performance issues
  2011-03-08 19:13 UTC  Andy Colson <andy@squeakycode.net>
` Performance issues
  2015-03-13 11:44 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-13 12:58 UTC  Varadharajan Mukundan <srinathsmn@gmail.com>
` Re: Performance issues
  2015-03-13 13:03 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-13 13:10 UTC  Varadharajan Mukundan <srinathsmn@gmail.com>
` Re: Performance issues
  2015-03-13 19:59 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-13 20:36 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-13 20:46 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-13 21:20 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-13 22:03 UTC  Varadharajan Mukundan <srinathsmn@gmail.com>
` Re: Performance issues
  2015-03-13 22:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance issues
  2015-03-13 23:28 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-14 00:12 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-14 21:06 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Performance issues
  2015-03-14 21:23 UTC  Varadharajan Mukundan <srinathsmn@gmail.com>
` Re: Performance issues
  2015-03-14 21:32 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Performance issues
  2015-03-16 12:24 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-16 17:49 UTC  Marc Mamin <M.Mamin@intershop.de>
` Re: Performance issues
  2015-03-16 18:24 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-16 18:32 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-16 19:43 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Performance issues
  2015-03-16 20:59 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 00:06 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Performance issues
  2015-03-17 07:41 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 11:07 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 11:42 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 11:45 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 12:05 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 12:10 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 13:55 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 14:19 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Performance issues
  2015-03-17 14:43 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 15:10 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 15:16 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-17 15:24 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Performance issues
  2015-03-17 15:28 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-17 15:30 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-18 17:31 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-18 17:51 UTC  Felipe Santos <felipepts@gmail.com>
` Re: Performance issues
  2015-03-18 18:36 UTC  Jerry Sievers <gsievers19@comcast.net>
` Re: Performance issues
  2015-03-18 18:48 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-18 19:07 UTC  Vitalii Tymchyshyn <vit@tym.im>
` Re: Performance issues
  2015-03-18 19:23 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Performance issues
  2015-03-21 07:39 UTC  Josh Krupka <jkrupka@gmail.com>
` Re: Performance issues
  2015-03-22 21:50 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: Performance issues
  2015-03-22 22:01 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [59+ messages in thread]

Very slow checkpoints
  2015-03-18 11:21 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-18 11:25 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-18 11:42 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Very slow checkpoints
  2015-03-18 11:58 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-18 12:13 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Very slow checkpoints
  2015-03-18 12:17 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Very slow checkpoints
  2015-03-18 12:19 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-18 12:21 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-18 12:28 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Very slow checkpoints
  2015-03-18 15:27 UTC  didier <did447@gmail.com>
` Re: Very slow checkpoints
  2015-03-19 05:28 UTC  Steven Jones <steven.jones1201@outlook.com>
` Re: Very slow checkpoints
  2015-03-19 19:40 UTC  Joao Junior <jcoj2006@gmail.com>
  [12+ messages in thread]

Merge Join chooses very slow index scan
  2015-03-19 06:23 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Merge Join chooses very slow index scan
  2015-03-19 06:42 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Merge Join chooses very slow index scan
  2015-03-19 07:04 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Merge Join chooses very slow index scan
  2015-03-19 14:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Merge Join chooses very slow index scan
  2015-03-19 14:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Merge Join chooses very slow index scan
  2015-03-19 16:40 UTC  Jake Magner <jakemagner90@gmail.com>
` Re: Merge Join chooses very slow index scan
  2015-03-19 19:15 UTC  Jake Magner <jakemagner90@gmail.com>
  [7+ messages in thread]

Hardware Configuration and other Stuff
  2015-03-18 19:07 UTC  Vivekanand Joshi <vjoshi@zetainteractive.com>
` Re: [ADMIN] Hardware Configuration and other Stuff
  2015-03-18 19:37 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Hardware Configuration and other Stuff
  2015-03-18 19:39 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Hardware Configuration and other Stuff
  2015-03-18 19:40 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [4+ messages in thread]

EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-04 19:03 UTC  Gunnlaugur Thor Briem <gunnlaugur@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-04 20:10 UTC  Marc Mamin <M.Mamin@intershop.de>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-05 15:01 UTC  Gunnlaugur Thor Briem <gunnlaugur@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-05 16:25 UTC  Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-05 21:13 UTC  Marc Mamin <M.Mamin@intershop.de>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-06 00:20 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-06 00:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-06 17:18 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-06 18:18 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-06 18:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-07 01:24 UTC  Kevin Grittner <kgrittn@ymail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-07 01:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-07 02:26 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-07 15:44 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-11 15:54 UTC  Gunnlaugur Thor Briem <gunnlaugur@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-11 16:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-11 17:30 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-11 17:55 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-16 19:23 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-16 19:24 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
  2015-03-16 21:08 UTC  Gunnlaugur Thor Briem <gunnlaugur@gmail.com>
  [21+ messages in thread]

MusicBrainz postgres performance issues
  2015-03-15 10:54 UTC  Robert Kaye <rob@musicbrainz.org>
` Re: MusicBrainz postgres performance issues
  2015-03-15 11:13 UTC  Josh Krupka <jkrupka@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 11:41 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: MusicBrainz postgres performance issues
  2015-03-15 12:07 UTC  Robert Kaye <rob@musicbrainz.org>
` Re: MusicBrainz postgres performance issues
  2015-03-15 12:08 UTC  Robert Kaye <rob@musicbrainz.org>
` Re: MusicBrainz postgres performance issues
  2015-03-15 12:29 UTC  Rural Hunter <ruralhunter@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 12:32 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 12:45 UTC  Josh Krupka <jkrupka@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 13:27 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 13:28 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 13:30 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 13:50 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 16:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 16:47 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 16:49 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:09 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:11 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:20 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:42 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:46 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 17:54 UTC  Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 18:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 22:47 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 23:13 UTC  michael@sqlexec.com <michael@sqlexec.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 23:29 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 23:30 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 23:41 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-15 23:55 UTC  michael@sqlexec.com <michael@sqlexec.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 00:07 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 00:12 UTC  Andres Freund <andres@2ndquadrant.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 00:17 UTC  michael@sqlexec.com <michael@sqlexec.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 00:22 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: MusicBrainz postgres performance issues
  2015-03-16 02:23 UTC  Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 12:59 UTC  Robert Kaye <rob@musicbrainz.org>
` Re: MusicBrainz postgres performance issues
  2015-03-16 13:22 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: MusicBrainz postgres performance issues
  2015-03-16 13:38 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: MusicBrainz postgres performance issues
  2015-03-16 14:32 UTC  Robert Kaye <rob@musicbrainz.org>
` Re: MusicBrainz postgres performance issues
  2015-03-16 17:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 19:24 UTC  Joao Junior <jcoj2006@gmail.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 20:01 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: MusicBrainz postgres performance issues
  2015-03-16 20:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [41+ messages in thread]

Best VPS provider for running performant PostgreSQL database server
  2015-03-16 05:08 UTC  Some Developer <someukdeveloper@gmail.com>
` Re: Best VPS provider for running performant PostgreSQL database server
  2015-03-16 19:33 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
  [2+ messages in thread]

Bad cost estimate with FALSE filter condition
  2015-02-28 01:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Bad cost estimate with FALSE filter condition
  2015-03-16 17:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Bad cost estimate with FALSE filter condition
  2015-03-16 18:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad cost estimate with FALSE filter condition
  2015-03-16 19:12 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ messages in thread]

Anyone have experience using PG on a NetApp All-Flash FAS8000?
  2015-03-13 19:18 UTC  Mel Llaguno <mllaguno@coverity.com>
` Re: Anyone have experience using PG on a NetApp All-Flash FAS8000?
  2015-03-14 07:02 UTC  Varadharajan Mukundan <srinathsmn@gmail.com>
  [2+ messages in thread]

Postgres inconsistent use of Index vs. Seq Scan
  2015-03-13 21:27 UTC  Jim Carroll <jim@carroll.com>
` Re: Postgres inconsistent use of Index vs. Seq Scan
  2015-03-13 22:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

How to get explain plan to prefer Hash Join
  2015-03-11 17:01 UTC  atxcanadian <matthew.boyda@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-11 21:11 UTC  Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-11 22:33 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 00:35 UTC  atxcanadian <matthew.boyda@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 05:42 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 15:45 UTC  atxcanadian <matthew.boyda@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 15:53 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 15:59 UTC  atxcanadian <matthew.boyda@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 16:25 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to get explain plan to prefer Hash Join
  2015-03-12 17:58 UTC  atxcanadian <matthew.boyda@gmail.com>
  [10+ 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