pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Views, joins and LIMIT
  2004-10-11 09:54 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: Views, joins and LIMIT
  2004-10-11 14:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

kernel 2.6 synchronous directory
  2004-10-10 09:19 UTC  Gaetano Mendola <mendola@bigfoot.com>

odd planner choice
  2004-03-26 05:52 UTC  Ara Anjargolian <ara@jargol.com>
` Re: odd planner choice
  2004-03-26 22:20 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: odd planner choice
  2004-03-26 23:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Odd planner choice?
  2004-10-08 19:32 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Odd planner choice?
  2004-10-08 19:46 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Odd planner choice?
  2004-10-08 20:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd planner choice?
  2004-10-08 20:29 UTC  Gary Doades <gpd@gpdnet.co.uk>
  [7+ messages in thread]

Data warehousing requirements
  2004-10-06 21:36 UTC  Gabriele Bartolini <angusgb@tin.it>
` Re: Data warehousing requirements
  2004-10-07 11:30 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Data warehousing requirements
  2004-10-07 17:07 UTC  Gabriele Bartolini <angusgb@tin.it>
` Re: Data warehousing requirements
  2004-10-07 22:50 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Data warehousing requirements
  2004-10-08 01:19 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Data warehousing requirements
  2004-10-08 02:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Data warehousing requirements
  2004-10-08 05:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Re:  Data warehousing requirements
  2004-10-08 12:38 UTC  simon@2ndquadrant.com
` Re: Re: Re:  Data warehousing requirements
  2004-10-08 14:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

integer[] indexing.
  2004-10-08 09:11 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: integer[] indexing.
  2004-10-08 09:29 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: integer[] indexing.
  2004-10-08 12:28 UTC  Harald Fuchs <hf0722x@protecting.net>
` Re: integer[] indexing.
  2004-10-08 14:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

stats on cursor and query execution troubleshooting
  2004-10-06 10:15 UTC  "Alban Médici (NetCentrex)" <amedici@fr.netcentrex.net>
` Re: [PERFORM] stats on cursor and query execution troubleshooting
  2004-10-06 14:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] stats on cursor and query execution troubleshooting
  2004-10-08 08:47 UTC  "Alban Médici (NetCentrex)" <amedici@fr.netcentrex.net>
` Re: [PERFORM] stats on cursor and query execution troubleshooting
  2004-10-08 13:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

sequential scan on select distinct
  2004-10-06 09:30 UTC  Ole Langbehn <ole@freiheit.com>
` Re: sequential scan on select distinct
  2004-10-06 10:19 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: sequential scan on select distinct
  2004-10-06 16:09 UTC  Ole Langbehn <ole@freiheit.com>
` Re: sequential scan on select distinct
  2004-10-06 16:41 UTC  Greg Stark <gsstark@mit.edu>
` Re: sequential scan on select distinct
  2004-10-06 17:34 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: sequential scan on select distinct
  2004-10-06 19:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequential scan on select distinct
  2004-10-07 12:01 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: sequential scan on select distinct
  2004-10-07 15:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequential scan on select distinct
  2004-10-07 17:08 UTC  Greg Stark <gsstark@mit.edu>
` Re: sequential scan on select distinct
  2004-10-07 17:21 UTC  Ole Langbehn <ole@freiheit.com>
` Re: sequential scan on select distinct
  2004-10-07 17:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequential scan on select distinct
  2004-10-07 20:00 UTC  Mischa Sandberg <ischamay.andbergsay@activestateway.com>
` Re: sequential scan on select distinct
  2004-10-08 08:54 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: sequential scan on select distinct
  2004-10-08 09:57 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
  [14+ messages in thread]

The never ending quest for clarity on shared_buffers
  2004-10-06 20:04 UTC  Doug Y <dylists@ptd.net>
` Re: The never ending quest for clarity on shared_buffers
  2004-10-06 22:26 UTC  Paul Ramsey <pramsey@refractions.net>
` Re: The never ending quest for clarity on shared_buffers
  2004-10-07 01:29 UTC  Neil Conway <neilc@samurai.com>
  [3+ messages in thread]

Comparing user attributes with bitwise operators
  2004-09-16 07:41 UTC  Patrick Clery <patrick@phpforhire.com>
` Re: Comparing user attributes with bitwise operators
  2004-09-16 08:11 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Comparing user attributes with bitwise operators
  2004-09-16 08:44 UTC  Greg Stark <gsstark@mit.edu>
` Re: Comparing user attributes with bitwise operators
  2004-09-16 08:53 UTC  Greg Stark <gsstark@mit.edu>
` Re: Comparing user attributes with bitwise operators
  2004-09-16 16:46 UTC  Daniel Ceregatti <daniel@omnis.com>
` Re: Comparing user attributes with bitwise operators
  2004-09-19 03:26 UTC  Patrick Clery <patrick@phpforhire.com>
` Re: Comparing user attributes with bitwise operators
  2004-09-19 05:07 UTC  Greg Stark <gsstark@mit.edu>
` Re: Comparing user attributes with bitwise operators
  2004-10-05 06:39 UTC  Patrick Clery <patrick@phpforhire.com>
` Re: Comparing user attributes with bitwise operators
  2004-10-05 16:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Comparing user attributes with bitwise operators
  2004-10-06 18:55 UTC  Patrick Clery <patrick@phpforhire.com>
` Re: Comparing user attributes with bitwise operators
  2004-10-06 19:27 UTC  Patrick Clery <patrick@phpforhire.com>
` Re: Comparing user attributes with bitwise operators
  2004-10-06 19:38 UTC  Greg Stark <gsstark@mit.edu>
  [12+ messages in thread]

Planner picks the wrong plan?
  2004-10-06 00:42 UTC  Nichlas Löfdahl <crotalus@acc.umu.se>
` Re: Planner picks the wrong plan?
  2004-10-06 03:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

test post
  2004-10-06 03:24 UTC  Max Baker <max@warped.org>

slow rule on update
  2004-10-05 22:55 UTC  Janning Vygen <vygen@gmx.de>

would number of fields in a table affect search-query time?
  2004-10-04 23:27 UTC  Miles Keaton <mileskeaton@gmail.com>
` Re: would number of fields in a table affect search-query time?
  2004-10-04 23:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: would number of fields in a table affect search-query time?
  2004-10-04 23:34 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: would number of fields in a table affect search-query time?
  2004-10-05 02:06 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ messages in thread]

Re: Performance suggestions for an update-mostly database?
  2004-10-04 17:38 UTC  Josh Berkus <josh@agliodbs.com>
` Performance suggestions for an update-mostly database?
  2004-10-04 17:40 UTC  Steve Atkins <steve@blighty.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 18:00 UTC  Steve Atkins <steve@blighty.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 19:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance suggestions for an update-mostly database?
  2004-10-04 19:22 UTC  Jim C. Nasby <decibel@decibel.org>
  [5+ messages in thread]

Slow update/insert process
  2004-10-01 18:14 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Slow update/insert process
  2004-10-01 19:48 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Slow update/insert process
  2004-10-04 17:14 UTC  Patrick Hatcher <PHatcher@macys.com>
  [3+ messages in thread]

Query planner problem
  2004-10-01 22:06 UTC  Ryan VanMiddlesworth <ryan@vanmiddlesworth.org>
` Re: Query planner problem
  2004-10-02 22:50 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Query planner problem
  2004-10-02 23:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner problem
  2004-10-03 21:56 UTC  Greg Stark <gsstark@mit.edu>
  [4+ messages in thread]

index not used when using function
  2004-09-29 19:41 UTC  Shiar <postgres@shiar.org>
` Re: index not used when using function
  2004-10-03 15:29 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
  [2+ messages in thread]

inconsistent/weird index usage
  2004-10-01 06:30 UTC  Dustin Sallings <dustin@spy.net>
` Re: inconsistent/weird index usage
  2004-10-01 13:53 UTC  John Meinel <john@johnmeinel.com>
` Re: inconsistent/weird index usage
  2004-10-01 14:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: inconsistent/weird index usage
  2004-10-01 14:43 UTC  Richard Huxton <dev@archonet.com>
` Re: inconsistent/weird index usage
  2004-10-01 16:29 UTC  Josh Berkus <josh@agliodbs.com>
` Re: inconsistent/weird index usage
  2004-10-01 16:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: inconsistent/weird index usage
  2004-10-02 23:20 UTC  Hannu Krosing <hannu@tm.ee>
` Re: inconsistent/weird index usage
  2004-10-02 23:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

Web server to Database Taking forever
  2004-09-30 14:46 UTC  Scott Dunn <sdunn@tsh.net>
` Re: Web server to Database Taking forever
  2004-09-30 16:39 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Web server to Database Taking forever
  2004-09-30 18:58 UTC  Scott Dunn <sdunn@tsh.net>
` Re: Web server to Database Taking forever
  2004-09-30 19:17 UTC  Edwin Eyan Moragas <haaktu@gmail.com>
` Re: Web server to Database Taking forever
  2004-09-30 20:19 UTC  Scott Marlowe <smarlowe@qwest.net>
  [5+ messages in thread]

O_DIRECT setting
  2004-09-20 07:57 UTC  Guy Thornley <guy@esphion.com>
` Re: O_DIRECT setting
  2004-09-23 03:58 UTC  Neil Conway <neilc@samurai.com>
` Re: O_DIRECT setting
  2004-09-23 13:35 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: O_DIRECT setting
  2004-09-23 14:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: O_DIRECT setting
  2004-09-24 15:07 UTC  Mark Wong <markw@osdl.org>
` Re: O_DIRECT setting
  2004-09-30 01:45 UTC  Mark Wong <markw@osdl.org>
` Re: O_DIRECT setting
  2004-09-30 03:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: O_DIRECT setting
  2004-09-30 07:02 UTC  Guy Thornley <guy@esphion.com>
` Re: O_DIRECT setting
  2004-09-30 16:33 UTC  Mark Wong <markw@osdl.org>
  [9+ messages in thread]

spurious function execution in prepared statements.
  2004-09-30 13:45 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:13 UTC  Michael Adler <adler@pobox.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:19 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: spurious function execution in prepared statements.
  2004-09-30 14:45 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: [HACKERS] spurious function execution in prepared statements.
  2004-09-30 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: spurious function execution in prepared statements.
  2004-09-30 14:58 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: spurious function execution in prepared statements.
  2004-09-30 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Interest in perf testing?
  2004-09-28 17:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Interest in perf testing?
  2004-09-29 14:44 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Interest in perf testing?
  2004-09-29 22:00 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [3+ messages in thread]

stubborn query confuses two different servers
  2004-09-29 17:44 UTC  SZŰCS Gábor <surrano@mailbox.hu>

Re: [PERFORM] Poor Performance for large queries
  2004-09-29 08:40 UTC  Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Poor Performance for large queries
  2004-09-29 14:56 UTC  John Meinel <john@johnmeinel.com>
` Re: [pgsql-hackers-win32] Poor Performance for large queries
  2004-09-29 16:44 UTC  John Meinel <john@johnmeinel.com>
  [3+ messages in thread]

Poor Performance for large queries in functions
  2004-09-29 03:14 UTC  John Meinel <john@johnmeinel.com>
` Re: Poor Performance for large queries in functions
  2004-09-29 05:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance for large queries in functions
  2004-09-29 06:34 UTC  John Meinel <john@johnmeinel.com>
` Re: Poor Performance for large queries in functions
  2004-09-29 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [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