pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Inefficient min/max against partition (ver 9.1.1)
  2012-02-29 17:32 UTC  McGehee, Robert <Robert.McGehee@geodecapital.com>
` Re: Inefficient min/max against partition (ver 9.1.1)
  2012-03-02 19:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Large insert and delete batches
  2012-02-29 10:20 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Large insert and delete batches
  2012-03-01 19:06 UTC  Kääriäinen Anssi <anssi.kaariainen@thl.fi>
` Re: Large insert and delete batches
  2012-03-01 20:51 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Large insert and delete batches
  2012-03-02 12:51 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
  [4+ messages in thread]

PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 00:16 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 02:13 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 10:56 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 11:46 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 13:55 UTC  Stephen Frost <sfrost@snowman.net>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 15:20 UTC  Andy Colson <andy@squeakycode.net>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 19:11 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 19:20 UTC  Andy Colson <andy@squeakycode.net>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 19:35 UTC  Cédric Villemain <cedric@2ndquadrant.fr>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 19:36 UTC  Cédric Villemain <cedric@2ndquadrant.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 20:37 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 20:56 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 22:34 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-28 15:22 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-28 20:48 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-28 22:41 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-28 23:46 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-29 15:16 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-29 15:18 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-29 15:24 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-29 15:28 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 16:34 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 16:57 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 17:35 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 17:38 UTC  Dave Crooke <dcrooke@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 22:52 UTC  Stefan Keller <sfkeller@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-01 23:08 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-02 00:23 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-02 00:28 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-02 00:35 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-02 00:58 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-03-02 01:17 UTC  Andrew Dunstan <andrew@dunslane.net>
  [32+ messages in thread]

[planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 11:45 UTC  Marcin Mirosław <marcin@mejor.pl>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 11:50 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 12:02 UTC  Marcin Mirosław <marcin@mejor.pl>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 12:09 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 12:19 UTC  Marcin Mirosław <marcin@mejor.pl>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 16:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 17:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 18:19 UTC  Craig James <cjames@emolecules.com>
` Re: [planner] Ignore "order by" in subselect if parrent do count(*)
  2012-03-01 21:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Bad estimation for "where field not in"
  2012-03-01 16:40 UTC  Daniele Varrazzo <daniele.varrazzo@gmail.com>
` Re: Bad estimation for "where field not in"
  2012-03-01 17:53 UTC  Ants Aasma <ants.aasma@eesti.ee>
` Re: Bad estimation for "where field not in"
  2012-03-01 21:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

efficient data reduction (and deduping)
  2012-03-01 18:27 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 18:35 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 18:35 UTC  Craig James <cjames@emolecules.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 18:40 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: efficient data reduction (and deduping)
  2012-03-01 18:51 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:28 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:29 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:30 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:35 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:39 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:43 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 19:44 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: efficient data reduction (and deduping)
  2012-03-01 20:12 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [13+ messages in thread]

text search: tablescan cost for a tsvector
  2012-02-06 11:05 UTC  Marc Mamin <M.Mamin@intershop.de>
` Re: text search: tablescan cost for a tsvector
  2012-02-29 18:32 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: text search: tablescan cost for a tsvector
  2012-02-29 20:40 UTC  Marc Mamin <M.Mamin@intershop.de>
  [3+ messages in thread]

Vacuuming problems on TOAST table
  2012-02-08 19:33 UTC  Ofer Israeli <oferi@checkpoint.com>
` Re: Vacuuming problems on TOAST table
  2012-02-08 19:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuuming problems on TOAST table
  2012-02-08 19:59 UTC  Ofer Israeli <oferi@checkpoint.com>
` Re: Vacuuming problems on TOAST table
  2012-02-29 18:45 UTC  Robert Haas <robertmhaas@gmail.com>
  [4+ messages in thread]

How to improve insert speed with index on text column
  2012-01-30 09:27 UTC  Saurabh <saurabh.b85@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-30 14:10 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-30 15:24 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-30 17:46 UTC  Saurabh <saurabh.b85@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-30 18:20 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-30 18:33 UTC  Andy Colson <andy@squeakycode.net>
` Re: How to improve insert speed with index on text column
  2012-01-30 20:32 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-31 09:29 UTC  Saurabh <saurabh.b85@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-01-31 11:21 UTC  Tomas Vondra <tv@fuzzy.cz>
` Re: How to improve insert speed with index on text column
  2012-01-31 18:46 UTC  Josh Berkus <josh@agliodbs.com>
` Re: How to improve insert speed with index on text column
  2012-01-31 20:20 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-01 02:11 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-01 03:29 UTC  Rosser Schwarz <rosser.schwarz@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-01 03:49 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-01 03:51 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-03 19:03 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How to improve insert speed with index on text column
  2012-02-03 20:54 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-05 17:29 UTC  Saurabh <saurabh.b85@gmail.com>
` Re: How to improve insert speed with index on text column
  2012-02-29 18:35 UTC  Robert Haas <robertmhaas@gmail.com>
  [19+ messages in thread]

problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 19:16 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 19:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 19:33 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 20:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 21:38 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 21:48 UTC  Kääriäinen Anssi <anssi.kaariainen@thl.fi>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 21:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 22:46 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 23:00 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-28 23:43 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  2012-02-29 07:30 UTC  Ants Aasma <ants.aasma@eesti.ee>
  [11+ messages in thread]

Very long deletion time on a 200 GB database
  2012-02-23 08:39 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 09:50 UTC  Glyn Astill <glynastill@yahoo.co.uk>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 10:07 UTC  Marcin Mańk <marcin.mank@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 11:23 UTC  Richard Huxton <dev@archonet.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 14:07 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 14:25 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 15:25 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 15:28 UTC  ktm@rice.edu <ktm@rice.edu>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 15:42 UTC  Lew <noone@lewscanon.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 15:47 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 16:37 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 17:56 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 18:05 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 18:11 UTC  Andy Colson <andy@squeakycode.net>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 18:13 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 18:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 19:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very long deletion time on a 200 GB database
  2012-02-23 19:46 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 06:39 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 08:22 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 12:37 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 13:07 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 14:34 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 14:54 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 15:16 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-24 17:20 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-25 19:17 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-26 07:33 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-26 10:46 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 04:33 UTC  lephongvu <luoidocsach@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 08:08 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 14:45 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 14:53 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 14:59 UTC  Reuven M. Lerner <reuven@lerner.co.il>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 15:01 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 15:14 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 17:07 UTC  Lew <noone@lewscanon.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 19:01 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 21:13 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-27 21:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Very long deletion time on a 200 GB database
  2012-02-28 17:06 UTC  David Kerr <dmk@mr-paradox.net>
` Re: Very long deletion time on a 200 GB database
  2012-02-29 05:31 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
  [42+ messages in thread]

Index condition in a Nested Loop
  2012-02-26 14:16 UTC  Mark Hills <mark@pogo.org.uk>
` Re: Index condition in a Nested Loop
  2012-02-26 21:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index condition in a Nested Loop
  2012-02-27 23:13 UTC  Mark Hills <mark@pogo.org.uk>
` Re: Index condition in a Nested Loop
  2012-02-28 00:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Joining tables by UUID field - very slow
  2012-02-24 22:46 UTC  Cherio <cherio@gmail.com>
` Re: Joining tables by UUID field - very slow
  2012-02-27 14:53 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Joining tables by UUID field - very slow
  2012-02-27 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-23 20:14 UTC  Jayashankar K B <Jayashankar.KB@lnties.com>
` Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-23 20:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-23 21:09 UTC  Jayashankar K B <Jayashankar.KB@lnties.com>
` Re: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-23 22:58 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-24 22:42 UTC  Jayashankar K B <Jayashankar.KB@lnties.com>
` Re: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-24 23:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-26 12:16 UTC  Jayashankar K B <Jayashankar.KB@lnties.com>
` Re: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
  2012-02-27 14:39 UTC  Merlin Moncure <mmoncure@gmail.com>
  [8+ messages in thread]

: Cost calculation for EXPLAIN output
  2012-02-23 12:21 UTC  Venkat Balaji <venkat.balaji@verse.in>
` Re: : Cost calculation for EXPLAIN output
  2012-02-23 16:51 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Cost calculation for EXPLAIN output
  2012-02-23 16:56 UTC  Shaun Thomas <sthomas@peak6.com>
` Re: : Cost calculation for EXPLAIN output
  2012-02-26 17:14 UTC  Venkat Balaji <venkat.balaji@verse.in>
` Re: : Cost calculation for EXPLAIN output
  2012-02-26 17:22 UTC  Venkat Balaji <venkat.balaji@verse.in>
  [5+ messages in thread]

 Re: [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  2012-02-26 08:52 UTC  Wales Wang <wormwang@yahoo.com>

Indexes and Primary Keys on Rapidly Growing Tables
  2012-02-20 22:06 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: Indexes and Primary Keys on Rapidly Growing Tables
  2012-02-20 23:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Indexes and Primary Keys on Rapidly Growing Tables
  2012-02-21 17:59 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: Indexes and Primary Keys on Rapidly Growing Tables
  2012-02-21 23:53 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Indexes and Primary Keys on Rapidly Growing Tables
  2012-02-22 00:11 UTC  Alessandro Gagliardi <alessandro@path.com>
  [5+ messages in thread]

Why so slow?
  2006-04-27 18:12 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Why so slow?
  2006-04-27 18:28 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Why so slow?
  2006-04-28 11:41 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Why so slow?
  2006-04-28 14:58 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Why so slow?
  2006-04-28 15:02 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Why so slow?
  2006-04-28 17:31 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Why so slow?
  2006-04-28 17:37 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Why so slow?
  2006-04-28 17:43 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Why so slow?
  2006-04-28 19:00 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Why so slow?
  2006-04-29 01:46 UTC  K C Lau <kclau60@netvigator.com>
` Re: Why so slow?
  2006-04-29 02:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why so slow?
  2006-04-29 03:18 UTC  K C Lau <kclau60@netvigator.com>
` Re: Why so slow?
  2006-04-29 11:29 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Why so slow?
  2006-04-30 10:29 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Why so slow?
  2006-04-30 14:03 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Why so slow?
  2006-05-02 17:16 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Why so slow?
  2006-05-02 20:13 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Why so slow?
  2006-05-02 20:17 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Why so slow?
  2006-05-02 23:28 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Why so slow?
  2006-05-03 11:22 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Why so slow?
  2006-05-04 17:53 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Why so slow?
  2012-02-17 18:34 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: Why so slow?
  2012-02-17 19:21 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Why so slow?
  2012-02-17 22:20 UTC  Alessandro Gagliardi <alessandro@path.com>
` Re: Why so slow?
  2012-02-18 05:29 UTC  Ants Aasma <ants.aasma@eesti.ee>
` Re: Why so slow?
  2012-02-20 21:14 UTC  Alessandro Gagliardi <alessandro@path.com>
  [26+ messages in thread]

Insertions slower than Updates?
  2012-02-20 18:59 UTC  Ofer Israeli <oferi@checkpoint.com>
` Re: Insertions slower than Updates?
  2012-02-20 19:13 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Insertions slower than Updates?
  2012-02-20 19:21 UTC  Ofer Israeli <oferi@checkpoint.com>
` Re: Insertions slower than Updates?
  2012-02-20 19:29 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Insertions slower than Updates?
  2012-02-20 19:32 UTC  Steve Horn <steve@stevehorn.cc>
` Re: Insertions slower than Updates?
  2012-02-20 20:16 UTC  Ofer Israeli <oferi@checkpoint.com>
` Re: Insertions slower than Updates?
  2012-02-20 20:16 UTC  Ofer Israeli <oferi@checkpoint.com>
  [7+ messages in thread]

Query slow as function
  2012-02-18 14:50 UTC  Steve Horn <steve@stevehorn.cc>
` Query slow as Function
  2012-02-18 15:03 UTC  Steve Horn <steve@stevehorn.cc>
` Re: Query slow as Function
  2012-02-18 16:02 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Query slow as Function
  2012-02-18 16:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query slow as Function
  2012-02-18 16:41 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Query slow as Function
  2012-02-18 17:15 UTC  Steve Horn <steve@stevehorn.cc>
` Re: Query slow as Function
  2012-02-18 17:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query slow as Function
  2012-02-18 17:32 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Query slow as function
  2012-02-20 17:32 UTC  Merlin Moncure <mmoncure@gmail.com>
  [9+ messages in thread]

Optimizer is not choosing index
  2012-02-15 22:40 UTC  Markus Innerebner <markus.innerebner@inf.unibz.it>
` Re: Optimizer is not choosing index
  2012-02-15 23:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer is not choosing index
  2012-02-16 06:54 UTC  Markus Innerebner <markus.innerebner@inf.unibz.it>
  [3+ messages in thread]

client performance v.s. server statistics
  2012-02-15 03:59 UTC  Zhou Han <zhouhan@gmail.com>
` Re: client performance v.s. server statistics
  2012-02-15 05:23 UTC  Amit Kapila <amit.kapila@huawei.com>
` Re: client performance v.s. server statistics
  2012-02-15 07:01 UTC  Zhou Han <zhouhan@gmail.com>
` Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 09:38 UTC  Zhou Han <zhouhan@gmail.com>
` Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 10:19 UTC  Zhou Han <zhouhan@gmail.com>
` Re: Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 10:55 UTC  Andres Freund <andres@anarazel.de>
` Re: Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 11:02 UTC  Han Zhou <zhouhan@gmail.com>
` Re: Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 11:33 UTC  Han Zhou <zhouhan@gmail.com>
` Re: Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-15 11:36 UTC  Andres Freund <andres@anarazel.de>
` Re: client performance v.s. server statistics
  2012-02-15 15:24 UTC  Amit Kapila <amit.kapila@huawei.com>
` Re: Fwd: [HACKERS] client performance v.s. server statistics
  2012-02-16 01:44 UTC  Han Zhou <zhouhan@gmail.com>
  [11+ messages in thread]

UPDATE on NOT JOIN
  2012-02-15 18:33 UTC  Gabriel Biberian <admin@beemotechnologie.com>
` Re: UPDATE on NOT JOIN
  2012-02-15 19:12 UTC  Marti Raudsepp <marti@juffo.org>
  [2+ messages in thread]

rough benchmarks, sata vs. ssd
  2012-01-31 08:07 UTC  CSS <css@morefoo.com>
` Re: rough benchmarks, sata vs. ssd
  2012-02-03 11:23 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: rough benchmarks, sata vs. ssd
  2012-02-11 06:35 UTC  CSS <css@morefoo.com>
` Re: rough benchmarks, sata vs. ssd
  2012-02-13 21:49 UTC  CSS <css@morefoo.com>
` Re: rough benchmarks, sata vs. ssd
  2012-02-13 22:12 UTC  Ivan Voras <ivoras@freebsd.org>
  [5+ messages in thread]

random_page_cost = 2.0 on Heroku Postgres
  2012-02-08 00:59 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 00:50 UTC  Josh Berkus <josh@agliodbs.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 01:39 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 01:45 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 02:05 UTC  Marcos Ortiz Valmaseda <mlortiz@uci.cu>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 02:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 02:47 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 02:54 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 04:38 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 04:39 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 05:11 UTC  Marcos Ortiz Valmaseda <mlortiz@uci.cu>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 15:32 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-09 22:41 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-10 01:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-10 19:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-10 19:48 UTC  Cédric Villemain <cedric@2ndquadrant.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-10 21:30 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-11 01:40 UTC  Josh Berkus <josh@agliodbs.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-11 02:13 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-11 16:26 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-11 19:52 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-12 19:49 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-12 20:01 UTC  Joshua Berkus <josh@agliodbs.com>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-12 22:28 UTC  Peter van Hardenberg <pvh@pvh.ca>
` Re: random_page_cost = 2.0 on Heroku Postgres
  2012-02-12 23:37 UTC  Peter Geoghegan <peter@2ndquadrant.com>
  [25+ 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