pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is disableing nested_loops a bad idea ?
  2010-09-16 08:23 UTC  Franck Routier <franck.routier@axege.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 09:55 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 13:49 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 14:13 UTC  Franck Routier <franck.routier@axege.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 14:25 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-26 04:02 UTC  Robert Haas <robertmhaas@gmail.com>
  [6+ messages in thread]

locking issue on simple selects?
  2010-09-15 10:05 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-15 13:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: locking issue on simple selects?
  2010-09-15 19:07 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-15 19:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: locking issue on simple selects?
  2010-09-15 19:28 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: locking issue on simple selects?
  2010-09-15 19:32 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: locking issue on simple selects?
  2010-09-15 21:33 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-16 00:32 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: locking issue on simple selects?
  2010-09-23 20:47 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-23 20:55 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: locking issue on simple selects?
  2010-09-23 22:25 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-23 22:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [12+ messages in thread]

Using Between
  2010-08-28 00:21 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-08-28 00:41 UTC  Craig James <craig_james@emolecules.com>
` Re: Using Between
  2010-08-30 16:51 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-21 19:35 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-21 20:04 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-22 10:51 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-22 15:18 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-22 16:27 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-22 16:28 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-23 00:51 UTC  mark <dvlhntr@gmail.com>
  [10+ messages in thread]

Performance degradation, index bloat and planner estimates
  2010-09-20 11:59 UTC  Daniele Varrazzo <daniele.varrazzo@gmail.com>
` Re: Performance degradation, index bloat and planner estimates
  2010-09-22 04:09 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Performance degradation, index bloat and planner estimates
  2010-09-22 04:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

slow DDL creation
  2010-08-30 22:28 UTC  Kevin Kempter <cs_dba@consistentstate.com>
` Re: slow DDL creation
  2010-08-30 23:04 UTC  bricklen <bricklen@gmail.com>
` Re: slow DDL creation
  2010-08-31 00:31 UTC  David Fetter <david@fetter.org>
` Re: slow DDL creation
  2010-08-31 15:35 UTC  Kevin Kempter <cs_dba@consistentstate.com>
` Re: slow DDL creation
  2010-09-21 19:38 UTC  Robert Haas <robertmhaas@gmail.com>
  [5+ messages in thread]

GPU Accelerated Sorting
  2010-08-30 13:46 UTC  Eliot Gable <egable@gmail.com>
` GPU Accelerated Sorting
  2010-08-30 13:51 UTC  Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 14:05 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: GPU Accelerated Sorting
  2010-08-30 14:56 UTC  Gaël Le Mignot <gael@pilotsystems.net>
` Re: GPU Accelerated Sorting
  2010-08-30 18:49 UTC  Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 19:25 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 20:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 20:47 UTC  David Boreham <david_list@boreham.org>
` Re: GPU Accelerated Sorting
  2010-08-30 21:18 UTC  Chris Browne <cbbrowne@acm.org>
` Re: GPU Accelerated Sorting
  2010-08-30 22:01 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: GPU Accelerated Sorting
  2010-08-30 22:37 UTC  David Boreham <david_list@boreham.org>
` Re: GPU Accelerated Sorting
  2010-08-31 01:17 UTC  Scott Carey <scott@richrelevance.com>
` Re: GPU Accelerated Sorting
  2010-08-31 01:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GPU Accelerated Sorting
  2010-09-21 19:27 UTC  Robert Haas <robertmhaas@gmail.com>
  [14+ messages in thread]

3ware trivia overload
  2010-09-18 07:50 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: 3ware trivia overload
  2010-09-20 21:54 UTC  George Sexton <georges@mhsoftware.com>
` Re: 3ware trivia overload
  2010-09-20 22:09 UTC  David Rees <drees76@gmail.com>
  [3+ messages in thread]

cleanup on pg_ system tables?
  2010-09-20 17:25 UTC  mark <dvlhntr@gmail.com>
` Re: cleanup on pg_ system tables?
  2010-09-20 19:24 UTC  Josh Kupershmidt <schmiddy@gmail.com>
  [2+ messages in thread]

Need PostgreSQL data warehousing user, on the record
  2010-09-20 18:47 UTC  Josh Berkus <josh@agliodbs.com>

Where does data in pg_stat_user_tables come from?
  2010-09-13 23:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-13 23:41 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-13 23:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 00:12 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 00:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 01:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 03:57 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 18:39 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:02 UTC  Guillaume Lelarge <guillaume@lelarge.info>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:34 UTC  Josh Berkus <josh@agliodbs.com>
  [11+ messages in thread]

Performance problem with joined aggregate query
  2010-09-15 06:26 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Performance problem with joined aggregate query
  2010-09-15 22:25 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problem with joined aggregate query
  2010-09-16 05:51 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Performance problem with joined aggregate query
  2010-09-16 14:52 UTC  Merlin Moncure <mmoncure@gmail.com>
  [4+ messages in thread]

POSTGRES error
  2010-09-15 11:07 UTC  Timothy.Noonan@emc.com
` Re: POSTGRES error
  2010-09-15 13:38 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [2+ messages in thread]

Held idle connections vs use of a Pooler
  2010-09-14 16:10 UTC  mark <dvlhntr@gmail.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 16:44 UTC  Craig James <craig_james@emolecules.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 16:58 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 17:01 UTC  Merlin Moncure <mmoncure@gmail.com>
  [4+ messages in thread]

Problem with mergejoin performance
  2010-09-13 05:49 UTC  azajac@ang.com.pl
` Re: Problem with mergejoin performance
  2010-09-13 14:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with mergejoin performance
  2010-09-13 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Problem with mergejoin performance (some bug?)
  2010-09-12 17:34 UTC  azajac@ang.com.pl

Slow SQL lookup due to every field being listed in SORT KEY
  2010-09-10 22:35 UTC  Mason Harding <mason.harding@gmail.com>
` Re: Slow SQL lookup due to every field being listed in SORT KEY
  2010-09-11 01:59 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Slow SQL lookup due to every field being listed in SORT KEY
  2010-09-11 02:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow SQL lookup due to every field being listed in SORT KEY
  2010-09-11 02:03 UTC  Stephen Frost <sfrost@snowman.net>
  [4+ messages in thread]

pgbench could not send data to client: Broken pipe
  2010-09-08 17:46 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 19:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 19:27 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 19:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 19:56 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 19:58 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 20:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 20:44 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 20:56 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 21:20 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 21:51 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 22:00 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 22:27 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-08 22:29 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-09 14:38 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-09 15:12 UTC  David Kerr <dmk@mr-paradox.net>
` Re: pgbench could not send data to client: Broken	 pipe
  2010-09-09 16:05 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: pgbench could not send data to client: Broken pipe
  2010-09-09 17:24 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: pgbench could not send data to client: Broken		 pipe
  2010-09-09 18:07 UTC  Greg Smith <greg@2ndquadrant.com>
  [19+ messages in thread]

Question about LEFT JOIN and query plan
  2010-09-03 16:16 UTC  Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Question about LEFT JOIN and query plan
  2010-09-03 17:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about LEFT JOIN and query plan
  2010-09-03 17:16 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Question about LEFT JOIN and query plan
  2010-09-07 07:19 UTC  Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Question about LEFT JOIN and query plan
  2010-09-07 13:13 UTC  Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Question about LEFT JOIN and query plan
  2010-09-07 13:28 UTC  Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Question about LEFT JOIN and query plan
  2010-09-07 14:29 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Question about LEFT JOIN and query plan
  2010-09-07 16:54 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [8+ messages in thread]

Odd estimation issue with user-defined type
  2010-09-03 14:15 UTC  Florian Weimer <fweimer@bfk.de>
` Re: Odd estimation issue with user-defined type
  2010-09-03 15:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd estimation issue with user-defined type
  2010-09-03 15:28 UTC  Florian Weimer <fweimer@bfk.de>
  [3+ messages in thread]

Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 08:07 UTC  Philippe Rimbault <primbault@edd.fr>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 09:51 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 10:23 UTC  Philippe Rimbault <primbault@edd.fr>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 12:27 UTC  Philippe Rimbault <primbault@edd.fr>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 16:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 18:25 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-19 18:31 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-27 04:30 UTC  Scott Carey <scott@richrelevance.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-27 17:25 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-29 15:07 UTC  Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 04:40 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 05:01 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 07:58 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 08:29 UTC  Scott Carey <scott@richrelevance.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 10:54 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 12:52 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 15:15 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 15:15 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 16:09 UTC  Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 20:41 UTC  Clemens Eisserer <linuxhippy@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-30 22:31 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 01:29 UTC  Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 12:41 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 15:43 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 15:53 UTC  Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 16:06 UTC  Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 16:08 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 17:03 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 17:04 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 17:19 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 18:55 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: Performance on new 64bit server compared to my 32bit desktop
  2010-08-31 18:56 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [32+ messages in thread]

[Fwd: postgres 8.4.1 number of connections]
  2010-08-26 20:29 UTC  Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
` Re: [Fwd: postgres 8.4.1 number of connections]
  2010-08-26 21:13 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [Fwd: postgres 8.4.1 number of connections]
  2010-08-27 01:05 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [Fwd: postgres 8.4.1 number of connections]
  2010-08-27 07:54 UTC  Magnus Hagander <magnus@hagander.net>
` Re: [Fwd: postgres 8.4.1 number of connections]
  2010-08-30 13:53 UTC  Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
  [5+ messages in thread]

array can be slow when joining?
  2010-08-29 13:18 UTC  Volodymyr Kostyrko <c.kworr@gmail.com>
` Re: array can be slow when joining?
  2010-08-30 03:53 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [2+ messages in thread]

write barrier question
  2010-08-18 19:24 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: write barrier question
  2010-08-18 19:56 UTC  Craig James <craig_james@emolecules.com>
` Re: write barrier question
  2010-08-18 20:25 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: write barrier question
  2010-08-18 22:05 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: write barrier question
  2010-08-18 22:06 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: write barrier question
  2010-08-28 10:17 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
  [6+ messages in thread]

SubQuery Performance
  2010-08-26 01:18 UTC  mike <mail4mz@gmail.com>
` Re: SubQuery Performance
  2010-08-26 05:24 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
  [2+ messages in thread]

New servers, need suggestions for sensible tuning settings
  2010-08-25 15:58 UTC  Bob Branch <bbranch@nabancard.com>
` Re: New servers, need suggestions for sensible tuning settings
  2010-08-25 16:24 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [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