pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Which gives good performance? separate database vs separate schema
  2010-11-25 11:37 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 12:02 UTC  tv@fuzzy.cz
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 12:03 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 12:09 UTC  tv@fuzzy.cz
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 12:10 UTC  Andres Freund <andres@anarazel.de>
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 12:25 UTC  tv@fuzzy.cz
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 14:53 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Which gives good performance? separate database vs separate schema
  2010-11-25 15:46 UTC  tv@fuzzy.cz
` Re: Which gives good performance? separate database vs separate schema
  2010-11-26 11:38 UTC  Robert Klemme <shortcutter@googlemail.com>
  [9+ messages in thread]

postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-06 00:26 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-06 08:57 UTC  Pierre C <lists@peufeu.com>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-06 18:37 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 02:30 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 04:26 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 04:33 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 04:38 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 15:33 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-12 16:12 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: postmaster consuming /lots/ of memory with hash aggregate. why?
  2010-11-24 03:11 UTC  Robert Haas <robertmhaas@gmail.com>
  [10+ messages in thread]

Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 03:53 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 04:47 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 20:47 UTC  Tomas Vondra <tv@fuzzy.cz>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 21:50 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 21:51 UTC  Rich <rhdyes@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 22:00 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-17 23:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-18 06:14 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-18 21:00 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 06:00 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 06:20 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 06:25 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 11:38 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 14:34 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 14:53 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 15:14 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 15:23 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 15:36 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 15:42 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 15:56 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 17:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-21 18:55 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-22 06:21 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-22 11:00 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-22 11:02 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-22 12:22 UTC  tv@fuzzy.cz
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-23 00:12 UTC  Humair Mohammed <humairm@hotmail.com>
` Re: Query Performance SQL Server vs. Postgresql
  2010-11-23 14:20 UTC  Merlin Moncure <mmoncure@gmail.com>
  [28+ messages in thread]

Slow SELECT on small table
  2010-11-22 08:59 UTC  Martin Boese <boesemar@gmx.de>
` Re: Slow SELECT on small table
  2010-11-22 15:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [2+ messages in thread]

autovacuum blocks the operations of other manual vacuum
  2010-11-12 08:01 UTC  kuopo <spkuo@cs.nctu.edu.tw>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-16 15:26 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-18 07:10 UTC  kuopo <spkuo@cs.nctu.edu.tw>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-20 01:49 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-20 04:43 UTC  tv@fuzzy.cz
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-21 14:15 UTC  kuopo <spkuo@cs.nctu.edu.tw>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-21 14:55 UTC  kuopo <spkuo@cs.nctu.edu.tw>
` Re: autovacuum blocks the operations of other manual vacuum
  2010-11-21 16:25 UTC  Alvaro Herrera <alvherre@commandprompt.com>
  [8+ messages in thread]

Should changing offset in LIMIT change query plan (at all/so early)?
  2010-11-19 12:33 UTC  goran <goran.gugic@gmail.com>
` Re: Should changing offset in LIMIT change query plan (at all/so early)?
  2010-11-21 15:44 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [2+ messages in thread]

best db schema for time series data?
  2010-11-16 10:50 UTC  Louis-David Mitterrand <vindex+lists-pgsql-performance@apartia.org>
` Re: best db schema for time series data?
  2010-11-16 11:03 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: best db schema for time series data?
  2010-11-16 11:07 UTC  Louis-David Mitterrand <vindex+lists-pgsql-performance@apartia.org>
` Re: best db schema for time series data?
  2010-11-16 11:11 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: best db schema for time series data?
  2010-11-16 11:18 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: best db schema for time series data?
  2010-11-16 11:28 UTC  Louis-David Mitterrand <vindex+lists-pgsql-performance@apartia.org>
` Re: best db schema for time series data?
  2010-11-16 11:55 UTC  Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: best db schema for time series data?
  2010-11-16 16:28 UTC  Harald Fuchs <hari.fuchs@gmail.com>
` Re: best db schema for time series data?
  2010-11-16 16:35 UTC  Chris Browne <cbbrowne@acm.org>
` Re: best db schema for time series data?
  2010-11-19 09:46 UTC  Louis-David Mitterrand <vindex+lists-pgsql-performance@apartia.org>
` Re: best db schema for time series data?
  2010-11-19 09:50 UTC  Louis-David Mitterrand <vindex+lists-pgsql-performance@apartia.org>
` Re: best db schema for time series data?
  2010-11-19 17:13 UTC  Chris Browne <cbbrowne@acm.org>
` Re: best db schema for time series data?
  2010-11-20 00:16 UTC  Robert Klemme <shortcutter@googlemail.com>
` Re: best db schema for time series data?
  2010-11-20 16:27 UTC  Bob Lunney <bob_lunney@yahoo.com>
  [14+ messages in thread]

How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 14:26 UTC  Eric Comeau <ecomeau@signiant.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 15:25 UTC  J. Roeleveld <joost@antarean.org>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 15:28 UTC  Digimer <linux@alteeve.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 15:49 UTC  Lutz Steinborn <l.steinborn@4c-ag.de>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 16:12 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 17:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 18:48 UTC  Scott Carey <scott@richrelevance.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 18:58 UTC  Scott Carey <scott@richrelevance.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 21:11 UTC  Eric Comeau <Eric.Comeau@signiant.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 23:27 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-17 23:43 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  2010-11-20 10:16 UTC  Dimitri <dimitrik.fr@gmail.com>
  [12+ messages in thread]

Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-10-31 12:13 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-10-31 19:59 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-10-31 23:10 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-01 01:29 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-01 05:03 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 21:10 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 21:21 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 21:24 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 22:06 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 22:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 23:32 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-05 23:39 UTC  Pierre C <lists@peufeu.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-07 23:35 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-07 23:45 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 00:05 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 02:35 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 14:23 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 18:13 UTC  Scott Carey <scott@richrelevance.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 18:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 22:12 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-08 22:32 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-13 17:38 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-13 18:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-14 09:47 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-16 20:39 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-16 23:10 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-16 23:25 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-16 23:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 00:01 UTC  Marti Raudsepp <marti@juffo.org>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 00:05 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 00:30 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 00:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:01 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:12 UTC  Andres Freund <andres@anarazel.de>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 01:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 03:07 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 19:26 UTC  Scott Carey <scott@richrelevance.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 20:19 UTC  Scott Carey <scott@richrelevance.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 21:24 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 21:36 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 22:48 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-17 23:20 UTC  Scott Carey <scott@richrelevance.com>
` Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  2010-11-19 14:52 UTC  Jignesh Shah <jkshah@gmail.com>
  [46+ messages in thread]

Low disk performance?
  2010-11-18 11:09 UTC  Martin Chlupac <martin.chlupac@rcware.eu>
` Re: Low disk performance?
  2010-11-18 13:33 UTC  tv@fuzzy.cz
  [2+ messages in thread]

Anyone seen this kind of lock pileup?
  2010-11-17 17:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Anyone seen this kind of lock pileup?
  2010-11-17 21:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Anyone seen this kind of lock pileup?
  2010-11-17 22:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Anyone seen this kind of lock pileup?
  2010-11-17 22:53 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: Anyone seen this kind of lock pileup?
  2010-11-17 23:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Anyone seen this kind of lock pileup?
  2010-11-17 23:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

(no subject)
  2010-11-15 20:14 UTC  Humair Mohammed <humairm@hotmail.com>
` Re:
  2010-11-16 07:00 UTC  Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re:
  2010-11-16 07:08 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re:
  2010-11-16 07:12 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [4+ messages in thread]

Difference between explain analyze and real execution time
  2010-11-15 08:21 UTC  Artur Zając <azajac@ang.com.pl>
` Re: Difference between explain analyze and real execution time
  2010-11-15 15:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Difference between explain analyze and real execution time
  2010-11-15 15:24 UTC  Artur Zając <azajac@ang.com.pl>
` Re: Difference between explain analyze and real execution time
  2010-11-15 15:25 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Difference between explain analyze and real execution time
  2010-11-15 19:39 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Difference between explain analyze and real execution time
  2010-11-15 20:43 UTC  Artur Zając <azajac@ang.com.pl>
` Re: Difference between explain analyze and real execution time
  2010-11-15 21:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Difference between explain analyze and real execution time
  2010-11-15 21:30 UTC  Artur Zając <azajac@ang.com.pl>
  [8+ messages in thread]

Why dose the planner select one bad scan plan.
  2010-11-10 09:37 UTC  静安寺 <asen_huang@qq.com>
` Re: Why dose the planner select one bad scan plan.
  2010-11-10 12:48 UTC  tv@fuzzy.cz
` Re: Why dose the planner select one bad scan plan.
  2010-11-11 07:03 UTC  静安寺 <asen_huang@qq.com>
` Re: Why dose the planner select one bad scan plan.
  2010-11-11 08:43 UTC  tv@fuzzy.cz
` Re: Why dose the planner select one bad scan plan.
  2010-11-14 23:00 UTC  Robert Haas <robertmhaas@gmail.com>
  [5+ messages in thread]

temporary tables, indexes, and query plans
  2010-10-27 17:29 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 17:44 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: temporary tables, indexes, and query plans
  2010-10-27 17:59 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 18:23 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 18:32 UTC  Reid Thompson <Reid.Thompson@ateb.com>
` Re: temporary tables, indexes, and query plans
  2010-10-27 18:52 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 19:23 UTC  Justin Pitts <justinpitts@gmail.com>
` Re: temporary tables, indexes, and query plans
  2010-10-27 19:29 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 19:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-10-27 19:44 UTC  Justin Pitts <justinpitts@gmail.com>
` Re: temporary tables, indexes, and query plans
  2010-10-27 20:29 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 21:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-10-27 22:02 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-27 22:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-10-28 14:08 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-10-28 14:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-10-29 18:16 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: temporary tables, indexes, and query plans
  2010-11-13 03:31 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-11-13 15:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-11-13 16:14 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temporary tables, indexes, and query plans
  2010-11-13 16:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-11-14 00:46 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: temporary tables, indexes, and query plans
  2010-11-14 00:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: temporary tables, indexes, and query plans
  2010-11-14 02:54 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: temporary tables, indexes, and query plans
  2010-11-14 15:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [25+ messages in thread]

do temporary tables have hint bits?
  2010-11-13 13:53 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: do temporary tables have hint bits?
  2010-11-13 14:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

questions regarding shared_buffers behavior
  2010-11-07 20:33 UTC  Mark Rostron <mrostron@ql2.com>
` Re: questions regarding shared_buffers behavior
  2010-11-07 23:30 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: questions regarding shared_buffers behavior
  2010-11-08 00:33 UTC  Mark Rostron <mrostron@ql2.com>
` Re: questions regarding shared_buffers behavior
  2010-11-08 03:03 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: questions regarding shared_buffers behavior
  2010-11-12 21:07 UTC  Robert Haas <robertmhaas@gmail.com>
  [5+ messages in thread]

equivalent queries lead to different query plans for self-joins with group by?
  2010-11-11 21:52 UTC  Ben <midfield@gmail.com>
` Re: equivalent queries lead to different query plans for self-joins with group by?
  2010-11-11 22:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: equivalent queries lead to different query plans for self-joins with group by?
  2010-11-11 23:56 UTC  Ben <midfield@gmail.com>
  [3+ messages in thread]

CREATE INDEX as bottleneck
  2010-11-11 13:41 UTC  Marc Mamin <M.Mamin@intershop.de>
` Re: CREATE INDEX as bottleneck
  2010-11-11 13:58 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: CREATE INDEX as bottleneck
  2010-11-11 18:54 UTC  Alex Hunsaker <badalex@gmail.com>
` Re: CREATE INDEX as bottleneck
  2010-11-11 20:05 UTC  Marc Mamin <M.Mamin@intershop.de>
  [4+ messages in thread]

Array interface
  2010-11-02 19:46 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Array interface
  2010-11-02 21:18 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Array interface
  2010-11-02 21:32 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Array interface
  2010-11-02 22:40 UTC  Conor Walsh <ctw@adverb.ly>
` Re: Array interface
  2010-11-03 14:56 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Array interface
  2010-11-10 09:10 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Array interface
  2010-11-10 09:42 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [7+ messages in thread]

Huge overestimation in rows expected results in bad plan
  2010-11-09 21:26 UTC  bricklen <bricklen@gmail.com>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-09 22:48 UTC  Andy Colson <andy@squeakycode.net>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-09 22:59 UTC  bricklen <bricklen@gmail.com>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-09 23:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-09 23:39 UTC  bricklen <bricklen@gmail.com>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-09 23:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge overestimation in rows expected results in bad plan
  2010-11-10 00:10 UTC  bricklen <bricklen@gmail.com>
  [7+ messages in thread]

Out of Memory Problem.
  2006-07-12 07:38 UTC  nicky <nicky@valuecare.nl>
` out of memory problem
  2010-11-09 10:39 UTC  Till Kirchner <till.kirchner@vti.bund.de>
` Re: out of memory problem
  2010-11-09 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: out of memory problem
  2010-11-09 16:02 UTC  Bob Lunney <bob_lunney@yahoo.com>
  [4+ messages in thread]

Select * is very slow
  2010-11-08 06:16 UTC  shaiju.ck <shaiju.ck@gmail.com>
` Re: Select * is very slow
  2010-11-08 15:23 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Select * is very slow
  2010-11-08 15:30 UTC  Thom Brown <thom@linux.com>
` Re: Select * is very slow
  2010-11-08 15:37 UTC  Justin Pitts <justinpitts@gmail.com>
` Re: Select * is very slow
  2010-11-08 17:01 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Select * is very slow
  2010-11-08 17:08 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Select * is very slow
  2010-11-08 17:09 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Select * is very slow
  2010-11-08 17:15 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Select * is very slow
  2010-11-08 18:41 UTC  Pierre C <lists@peufeu.com>
  [9+ messages in thread]

Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:19 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:27 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:38 UTC  Andres Freund <andres@anarazel.de>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 20:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 21:26 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 22:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Major Linux performance regression; shouldn't we be worried about RHEL6?
  2010-11-05 22:30 UTC  Scott Carey <scott@richrelevance.com>
  [9+ messages in thread]

Bufer cache replacement LRU algorithm?
  2010-11-03 16:35 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Bufer cache replacement LRU algorithm?
  2010-11-03 16:52 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Bufer cache replacement LRU algorithm?
  2010-11-03 17:09 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Bufer cache replacement LRU algorithm?
  2010-11-05 20:58 UTC  Greg Smith <greg@2ndquadrant.com>
  [4+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox