pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Query much faster with enable_seqscan=0
  2010-09-21 17:32 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 18:06 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 18:21 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 18:51 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 19:02 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 19:07 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 19:16 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 19:34 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 23:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query much faster with enable_seqscan=0
  2010-09-21 23:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query much faster with enable_seqscan=0
  2010-09-22 13:36 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-24 17:34 UTC  Scott Carey <scott@richrelevance.com>
` Re: Query much faster with enable_seqscan=0
  2010-09-28 16:03 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Query much faster with enable_seqscan=0
  2010-10-13 00:23 UTC  Ogden <lists@darkstatic.com>
` Re: Query much faster with enable_seqscan=0
  2010-10-13 02:28 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Query much faster with enable_seqscan=0
  2010-10-28 16:21 UTC  Robert Haas <robertmhaas@gmail.com>
  [16+ messages in thread]

Slow Query- Simple taking
  2010-10-19 18:21 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Slow Query- Simple taking
  2010-10-19 20:58 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow Query- Simple taking
  2010-10-19 21:51 UTC  Mathieu De Zutter <mathieu@dezutter.org>
` Re: Slow Query- Simple taking
  2010-10-19 22:05 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Slow Query- Simple taking
  2010-10-28 14:39 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Slow Query- Simple taking
  2010-10-28 14:40 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Slow Query- Simple taking
  2010-10-28 14:42 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Slow Query- Simple taking
  2010-10-28 14:51 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Slow Query- Simple taking
  2010-10-28 14:53 UTC  Richard Broersma <richard.broersma@gmail.com>
` Re: Slow Query- Simple taking
  2010-10-28 15:23 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Slow Query- Simple taking
  2010-10-28 16:18 UTC  Robert Haas <robertmhaas@gmail.com>
  [11+ messages in thread]

How does PG know if data is in memory?
  2010-09-29 16:31 UTC  Fabrício dos Anjos Silva <fabricio.silva@linkcom.com.br>
` Re: How does PG know if data is in memory?
  2010-09-29 16:36 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How does PG know if data is in memory?
  2010-09-29 17:08 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: How does PG know if data is in memory?
  2010-10-01 11:12 UTC  Fabrício dos Anjos Silva <fabricio.silva@linkcom.com.br>
` Re: How does PG know if data is in memory?
  2010-10-01 12:24 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: How does PG know if data is in memory?
  2010-10-01 13:45 UTC  Pierre C <lists@peufeu.com>
` Re: How does PG know if data is in memory?
  2010-10-01 13:46 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How does PG know if data is in memory?
  2010-10-01 14:00 UTC  Fabrício dos Anjos Silva <fabricio.silva@linkcom.com.br>
` Re: How does PG know if data is in memory?
  2010-10-01 14:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How does PG know if data is in memory?
  2010-10-01 16:50 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: How does PG know if data is in memory?
  2010-10-03 02:42 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: How does PG know if data is in memory?
  2010-10-04 03:07 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How does PG know if data is in memory?
  2010-10-04 03:22 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How does PG know if data is in memory?
  2010-10-04 03:29 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How does PG know if data is in memory?
  2010-10-04 03:34 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How does PG know if data is in memory?
  2010-10-04 04:02 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: How does PG know if data is in memory?
  2010-10-04 20:39 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: How does PG know if data is in memory?
  2010-10-04 22:47 UTC  Jeremy Harris <jgh@wizmail.org>
` Re: How does PG know if data is in memory?
  2010-10-12 02:59 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: How does PG know if data is in memory?
  2010-10-12 03:11 UTC  gnuoytr@rcn.com
` Re: How does PG know if data is in memory?
  2010-10-12 12:34 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: How does PG know if data is in memory?
  2010-10-12 14:20 UTC  gnuoytr@rcn.com
` Re: How does PG know if data is in memory?
  2010-10-12 14:35 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How does PG know if data is in memory?
  2010-10-12 14:49 UTC  gnuoytr@rcn.com
` Re: How does PG know if data is in memory?
  2010-10-12 15:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How does PG know if data is in memory?
  2010-10-13 03:16 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: How does PG know if data is in memory?
  2010-10-13 06:40 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: How does PG know if data is in memory?
  2010-10-14 18:47 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: How does PG know if data is in memory?
  2010-10-21 18:55 UTC  Bruce Momjian <bruce@momjian.us>
` Re: How does PG know if data is in memory?
  2010-10-28 02:30 UTC  Francisco Reyes <lists@stringsutils.com>
` Re: How does PG know if data is in memory?
  2010-10-28 15:31 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
  [31+ messages in thread]

Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:12 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:20 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:26 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:31 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:33 UTC  Josh Kupershmidt <schmiddy@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:36 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:38 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:42 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:46 UTC  Steve Singer <ssinger@ca.afilias.info>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:52 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 18:56 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 19:21 UTC  Ray Stell <stellr@cns.vt.edu>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 19:26 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 19:51 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 20:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-25 20:51 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 11:44 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 13:20 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 15:08 UTC  Leonardo Francalanci <m_lists@yahoo.it>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 15:41 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 21:02 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 21:27 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 21:54 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 22:14 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 22:50 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-26 23:16 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 03:10 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 10:13 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 11:05 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 14:00 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 15:42 UTC  Steve Singer <ssinger@ca.afilias.info>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 15:49 UTC  Reid Thompson <Reid.Thompson@ateb.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 15:50 UTC  David Wilson <david.t.wilson@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 16:12 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 17:48 UTC  Scott Carey <scott@richrelevance.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:06 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:06 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:13 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:14 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:42 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:51 UTC  Steve Singer <ssinger@ca.afilias.info>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 18:51 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 19:45 UTC  Alex Hunsaker <badalex@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-27 19:47 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 02:01 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 03:08 UTC  Divakar Singh <dpsmails@yahoo.com>
` Re: Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 03:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 04:23 UTC  Alex Hunsaker <badalex@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 04:26 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 13:13 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: [PERFORM] Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 14:23 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Postgres insert performance and storage requirement compared to Oracle
  2010-10-28 15:28 UTC  Jesper Krogh <jesper@krogh.cc>
  [53+ messages in thread]

Select count(*), the sequel
  2010-10-16 16:51 UTC  Mladen Gogala <gogala.mladen@gmail.com>
` Select count(*), the sequel
  2010-10-16 16:53 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Select count(*), the sequel
  2010-10-16 18:44 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Select count(*), the sequel
  2010-10-18 07:58 UTC  Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Select count(*), the sequel
  2010-10-18 11:41 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Select count(*), the sequel
  2010-10-26 22:45 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Select count(*), the sequel
  2010-10-26 22:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select count(*), the sequel
  2010-10-27 01:48 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Select count(*), the sequel
  2010-10-27 19:52 UTC  Pierre C <lists@peufeu.com>
` Re: Select count(*), the sequel
  2010-10-27 20:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Select count(*), the sequel
  2010-10-27 20:41 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Select count(*), the sequel
  2010-10-27 20:54 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Select count(*), the sequel
  2010-10-27 21:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select count(*), the sequel
  2010-10-28 09:33 UTC  Pierre C <lists@peufeu.com>
` Re: Select count(*), the sequel
  2010-10-28 13:34 UTC  Kenneth Marshall <ktm@rice.edu>
  [15+ messages in thread]

AIX slow buffer reads
  2010-10-25 18:21 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
` Re: AIX slow buffer reads
  2010-10-25 18:50 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: AIX slow buffer reads
  2010-10-25 19:26 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
` Re: AIX slow buffer reads
  2010-10-26 14:06 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: AIX slow buffer reads
  2010-10-26 21:04 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
` Re: AIX slow buffer reads
  2010-10-27 12:42 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: AIX slow buffer reads
  2010-10-27 17:05 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
` Re: AIX slow buffer reads
  2010-10-27 19:24 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: AIX slow buffer reads
  2010-10-27 20:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: AIX slow buffer reads
  2010-10-27 20:56 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
` Re: AIX slow buffer reads
  2010-10-27 22:37 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: AIX slow buffer reads
  2010-10-27 22:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: AIX slow buffer reads
  2010-10-28 12:33 UTC  André Volpato <andre.volpato@ecomtecnologia.com.br>
  [13+ messages in thread]

Running 9 in production? Sticking with 8.4.4 for a while?
  2010-09-28 19:22 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Running 9 in production? Sticking with 8.4.4 for a while?
  2010-09-28 19:50 UTC  Michael Gould <mgould@intermodalsoftwaresolutions.net>
` Re: Running 9 in production? Sticking with 8.4.4 for a while?
  2010-09-28 20:45 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Running 9 in production? Sticking with 8.4.4 for a while?
  2010-09-28 22:14 UTC  Guy Rouillier <guyr-ml1@burntmail.com>
` Re: Running 9 in production? Sticking with 8.4.4 for a while?
  2010-09-28 22:52 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Running 9 in production? Sticking with 8.4.4 for a while?
  2010-10-27 15:19 UTC  Francisco Reyes <lists@stringsutils.com>
  [6+ messages in thread]

odd postgresql performance (excessive lseek)
  2010-10-14 20:00 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 13:10 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 13:25 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 13:38 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 14:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 15:27 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 16:28 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: odd postgresql performance (excessive lseek)
  2010-10-19 17:41 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: odd postgresql performance (excessive lseek)
  2010-10-27 03:05 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: odd postgresql performance (excessive lseek)
  2010-10-27 03:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [10+ messages in thread]

which one is faster
  2010-10-26 10:56 UTC  AI Rumman <rummandba@gmail.com>
` Re: which one is faster
  2010-10-26 10:59 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: which one is faster
  2010-10-26 11:59 UTC  Marcin Mirosław <marcin@mejor.pl>
` Re: which one is faster
  2010-10-26 12:05 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: which one is faster
  2010-10-26 12:08 UTC  Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: which one is faster
  2010-10-26 12:16 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: which one is faster
  2010-10-26 12:20 UTC  Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: which one is faster
  2010-10-26 12:23 UTC  Szymon Guz <mabewlun@gmail.com>
` Re: which one is faster
  2010-10-26 12:32 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
  [9+ messages in thread]

Auto ANALYZE criteria
  2010-09-20 20:38 UTC  Joe Miller <joe.d.miller@gmail.com>
` Re: Auto ANALYZE criteria
  2010-09-20 22:28 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Auto ANALYZE criteria
  2010-09-21 02:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Auto ANALYZE criteria
  2010-09-21 13:33 UTC  Joe Miller <joe.d.miller@gmail.com>
` Re: Auto ANALYZE criteria
  2010-09-21 14:59 UTC  Joe Miller <joe.d.miller@gmail.com>
` Re: Auto ANALYZE criteria
  2010-09-21 20:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Auto ANALYZE criteria
  2010-10-13 21:20 UTC  Joe Miller <joe.d.miller@gmail.com>
` Re: Auto ANALYZE criteria
  2010-10-26 12:24 UTC  Robert Haas <robertmhaas@gmail.com>
  [8+ messages in thread]

Re: No hash join across partitioned tables?
  2010-02-25 23:46 UTC  Bruce Momjian <bruce@momjian.us>
` Re: No hash join across partitioned tables?
  2010-02-26 00:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No hash join across partitioned tables?
  2010-03-02 16:16 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: No hash join across partitioned tables?
  2010-03-02 16:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No hash join across partitioned tables?
  2010-03-02 16:27 UTC  Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: No hash join across partitioned tables?
  2010-06-09 19:47 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: No hash join across partitioned tables?
  2010-06-09 20:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] No hash join across partitioned tables?
  2010-06-10 13:29 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] No hash join across partitioned tables?
  2010-06-14 03:47 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] No hash join across partitioned tables?
  2010-06-15 18:44 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: No hash join across partitioned tables?
  2010-07-02 03:00 UTC  Bruce Momjian <bruce@momjian.us>
` Re: No hash join across partitioned tables?
  2010-07-02 04:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No hash join across partitioned tables?
  2010-07-02 20:53 UTC  Bruce Momjian <bruce@momjian.us>
` Re: No hash join across partitioned tables?
  2010-07-02 20:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No hash join across partitioned tables?
  2010-07-02 21:10 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: No hash join across partitioned tables?
  2010-07-02 21:12 UTC  Bruce Momjian <bruce@momjian.us>
` Re: No hash join across partitioned tables?
  2010-10-16 05:03 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: No hash join across partitioned tables?
  2010-10-16 05:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No hash join across partitioned tables?
  2010-10-16 05:35 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: No hash join across partitioned tables?
  2010-10-16 15:29 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: No hash join across partitioned tables?
  2010-10-18 06:13 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: No hash join across partitioned tables?
  2010-10-18 14:44 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: No hash join across partitioned tables?
  2010-10-26 12:23 UTC  Robert Haas <robertmhaas@gmail.com>
  [23+ messages in thread]

Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-11 23:10 UTC  Damon Snyder <damon@huddler-inc.com>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-15 19:24 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-15 21:06 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-16 01:47 UTC  Tatsuo Ishii <ishii@postgresql.org>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-16 02:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-16 19:54 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Stored procedure declared as VOLATILE => no good optimization is done
  2010-10-25 23:27 UTC  Damon Snyder <damon@huddler-inc.com>
  [7+ messages in thread]

interpret statement log duration information
  2010-10-25 22:33 UTC  Mark Rostron <mrostron@ql2.com>
` Re: interpret statement log duration information
  2010-10-25 22:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Useless sort by
  2010-09-13 09:47 UTC  Gaetano Mendola <mendola@gmail.com>
` Re: Useless sort by
  2010-09-13 14:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Useless sort by
  2010-09-13 15:55 UTC  Gaetano Mendola <mendola@gmail.com>
` Re: Useless sort by
  2010-09-13 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Useless sort by
  2010-09-13 17:09 UTC  Gaetano Mendola <mendola@gmail.com>
` Re: Useless sort by
  2010-09-13 17:24 UTC  Maciek Sakrejda <msakrejda@truviso.com>
` Re: Useless sort by
  2010-09-13 19:08 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Useless sort by
  2010-09-14 07:10 UTC  Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: Useless sort by
  2010-09-14 15:09 UTC  Maciek Sakrejda <msakrejda@truviso.com>
` Re: Useless sort by
  2010-09-14 16:15 UTC  Dave Crooke <dcrooke@gmail.com>
` Re: Useless sort by
  2010-09-14 17:06 UTC  Gaetano Mendola <mendola@gmail.com>
` Re: Useless sort by
  2010-09-23 00:54 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Useless sort by
  2010-09-23 03:05 UTC  gnuoytr@rcn.com
` Re: Useless sort by
  2010-09-23 04:01 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Useless sort by
  2010-09-23 04:18 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Useless sort by
  2010-09-23 04:46 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Useless sort by
  2010-09-23 13:51 UTC  gnuoytr@rcn.com
` Re: Useless sort by
  2010-09-23 17:11 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Useless sort by
  2010-10-25 10:09 UTC  Gaetano Mendola <mendola@gmail.com>
  [19+ messages in thread]

Periodically slow inserts
  2010-10-21 12:25 UTC  Gael Le Mignot <gael@pilotsystems.net>
` Re: Periodically slow inserts
  2010-10-21 13:03 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: Periodically slow inserts
  2010-10-21 13:15 UTC  Leonardo Francalanci <m_lists@yahoo.it>
` Re: Periodically slow inserts
  2010-10-21 14:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Periodically slow inserts
  2010-10-21 15:07 UTC  Gael Le Mignot <gael@pilotsystems.net>
` Re: Periodically slow inserts
  2010-10-21 15:11 UTC  Leonardo Francalanci <m_lists@yahoo.it>
` Re: Periodically slow inserts
  2010-10-21 15:30 UTC  Leonardo Francalanci <m_lists@yahoo.it>
` Re: Periodically slow inserts
  2010-10-21 15:40 UTC  Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Periodically slow inserts
  2010-10-21 16:03 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Periodically slow inserts
  2010-10-21 16:07 UTC  Gael Le Mignot <gael@pilotsystems.net>
` Re: Periodically slow inserts
  2010-10-21 16:15 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Periodically slow inserts
  2010-10-21 16:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Periodically slow inserts
  2010-10-22 07:45 UTC  Leonardo Francalanci <m_lists@yahoo.it>
` Re: Periodically slow inserts
  2010-10-22 15:10 UTC  Gael Le Mignot <gael@pilotsystems.net>
  [14+ messages in thread]

Clean up of archived Xlogs in postgres-9.
  2010-09-28 10:01 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Clean up of archived Xlogs in postgres-9.
  2010-09-28 12:29 UTC  Erik Rijkers <er@xs4all.nl>
` Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.
  2010-10-22 11:14 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
  [3+ messages in thread]

Index scan is not working, why??
  2010-10-21 05:25 UTC  AI Rumman <rummandba@gmail.com>
` Re: Index scan is not working, why??
  2010-10-21 07:51 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Index scan is not working, why??
  2010-10-21 07:54 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Index scan is not working, why??
  2010-10-21 13:27 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Index scan is not working, why??
  2010-10-21 20:13 UTC  Igor Neyman <ineyman@perceptron.com>
  [5+ messages in thread]

Experiences with running PostgreSQL on Blue Arc Network Storage
  2010-10-21 18:54 UTC  Tim Goodaire <tgoodair@ca.afilias.info>

New wiki page on write reliability
  2010-10-21 14:08 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: New wiki page on write reliability
  2010-10-21 14:34 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: New wiki page on write reliability
  2010-10-21 15:45 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: New wiki page on write reliability
  2010-10-21 16:09 UTC  Bruce Momjian <bruce@momjian.us>
  [4+ messages in thread]

What is postmaster doing?
  2010-10-20 18:44 UTC  Dimi Paun <dimi@lattica.com>
` Re: What is postmaster doing?
  2010-10-20 19:24 UTC  Reid Thompson <Reid.Thompson@ateb.com>
` Re: What is postmaster doing?
  2010-10-20 19:51 UTC  Dimi Paun <dimi@lattica.com>
` Re: What is postmaster doing?
  2010-10-20 19:59 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: What is postmaster doing?
  2010-10-20 20:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What is postmaster doing?
  2010-10-20 20:30 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: What is postmaster doing?
  2010-10-20 20:39 UTC  Dimi Paun <dimi@lattica.com>
` Re: What is postmaster doing?
  2010-10-20 20:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What is postmaster doing?
  2010-10-20 20:55 UTC  Dimi Paun <dimi@lattica.com>
` Re: What is postmaster doing?
  2010-10-20 20:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What is postmaster doing?
  2010-10-20 21:47 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: What is postmaster doing?
  2010-10-20 21:51 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: What is postmaster doing?
  2010-10-21 02:39 UTC  Greg Smith <greg@2ndquadrant.com>
  [13+ messages in thread]

Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-16 12:32 UTC  Eric Comeau <ecomeau@signiant.com>
` Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-18 14:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-18 14:25 UTC  Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-18 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-19 11:23 UTC  Eric Comeau <ecomeau@signiant.com>
` Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]
  2010-10-19 14:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

unexpected query failure: ERROR: GIN indexes do not support whole-index scans
  2010-10-18 20:59 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans
  2010-10-18 23:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans
  2010-10-19 02:47 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
  [3+ messages in thread]

UUID performance as primary key
  2010-10-16 01:58 UTC  Navkirat Singh <navkirats@gmail.com>
` Re: UUID performance as primary key
  2010-10-16 02:59 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: UUID performance as primary key
  2010-10-16 03:46 UTC  Andy <angelflow@yahoo.com>
` Re: UUID performance as primary key
  2010-10-16 17:28 UTC  Craig James <craig_james@emolecules.com>
` Re: UUID performance as primary key
  2010-10-16 19:35 UTC  Merlin Moncure <mmoncure@gmail.com>
  [5+ messages in thread]

help with understanding EXPLAIN
  2010-10-13 21:18 UTC  Brandon Casci <brandon@loudcaster.com>
` Re: [PERFORM] help with understanding EXPLAIN
  2010-10-16 01:17 UTC  Craig Ringer <craig@postnewspapers.com.au>
  [2+ messages in thread]

Index scan / Index cond limitation or ?
  2010-10-14 15:49 UTC  Nikolai Zhubr <n-a-zhubr@yandex.ru>
` Re: Index scan / Index cond limitation or ?
  2010-10-15 18:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index scan / Index cond limitation or ?
  2010-10-15 21:00 UTC  Nikolai Zhubr <n-a-zhubr@yandex.ru>
  [3+ 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