pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Indexing question
  2003-08-29 06:52 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 07:03 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 07:05 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing question
  2003-08-29 07:49 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 07:59 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 08:14 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing question
  2003-08-29 08:41 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 08:57 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 09:08 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 14:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing question
  2003-08-29 15:13 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 16:58 UTC  Richard Ellis <rellis9@yahoo.com>
` Re: Indexing question
  2003-08-30 01:07 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Indexing question
  2004-06-15 21:29 UTC  Stan Bielski <bielski@ece.cmu.edu>
` Re: Indexing question
  2004-06-20 18:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [15+ messages in thread]

*very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 14:24 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:00 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 15:32 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:45 UTC  Jean-Luc Lachance <jllachan@sympatico.ca>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 16:56 UTC  Jean-Luc Lachance <jllachan@sympatico.ca>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 17:09 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 17:14 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 08:37 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 14:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 15:32 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [12+ messages in thread]

Visual Explain
  2004-06-16 14:01 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 11:10 UTC  Adam Witney <awitney@sghms.ac.uk>
` Re: [PERFORM] Visual Explain
  2004-06-17 12:16 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 12:52 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 13:37 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 16:54 UTC  Vitaly Belman <vitalyb@gmail.com>
` Re: Visual Explain
  2004-06-17 17:05 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 17:35 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 18:13 UTC  Vitaly Belman <vitalyb@gmail.com>
  [9+ messages in thread]

in-transaction insert performance in 7.5devel
  2004-06-11 18:40 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 18:55 UTC  Rod Taylor <pg@rbt.ca>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:27 UTC  Rod Taylor <pg@rbt.ca>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 21:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 21:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: in-transaction insert performance in 7.5devel
  2004-06-17 16:35 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [8+ messages in thread]

50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-07 21:47 UTC  borajetta <borajetta@hotmail.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 00:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 12:43 UTC  Jeremy Dunn <jdunn@autorevenue.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 15:16 UTC  Aaron <smokedvw@hotmail.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-17 00:33 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

Basic Postgresql Performance Question
  2004-06-16 19:15 UTC  Bill <bill@math.uchicago.edu>
` Re: Basic Postgresql Performance Question
  2004-06-16 19:35 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:08 UTC  Kevin Barnard <kbarnard@speedfc.com>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:18 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:49 UTC  Stephen Frost <sfrost@snowman.net>
  [5+ messages in thread]

why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 06:49 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 13:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 15:30 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 18:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-16 08:42 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
  [5+ messages in thread]

Re: Index oddity (still)
  2004-06-14 23:47 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity (still)
  2004-06-15 13:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Interpreting OSDB Results
  2004-06-15 06:03 UTC  Neeraj  <bunku@rediffmail.com>

Re: Failed System follow up
  2004-06-15 03:41 UTC  Marcus Whitney <marcus@coldfeetcreative.com>

Re: Failed System.  Help.
  2004-06-15 03:33 UTC  Marcus Whitney <marcus@coldfeetcreative.com>

Additional select fields in a GROUP BY
  2004-06-13 03:21 UTC  Vitaly Belman <vitalib@012.net.il>
` Re: Additional select fields in a GROUP BY
  2004-06-13 03:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Additional select fields in a GROUP BY
  2004-06-13 13:52 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Additional select fields in a GROUP BY
  2004-06-13 17:35 UTC  Vitaly Belman <vitalyb@gmail.com>
` Re: Additional select fields in a GROUP BY
  2004-06-13 17:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

ORDER BY user defined function performance issues
  2004-06-11 11:14 UTC  Nick Trainor <nick.trainor@trainorthornton.co.uk>
` Re: ORDER BY user defined function performance issues
  2004-06-11 13:41 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: ORDER BY user defined function performance issues
  2004-06-11 17:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Database Server Tuning
  2004-02-26 21:28 UTC  John Allgood <john@turbocorp.com>
` Re: Database Server Tuning
  2004-02-26 22:01 UTC  Troels Arvin <troels@arvin.dk>
` Re: Database Server Tuning
  2004-02-26 22:48 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-02-27 03:07 UTC  John Allgood <john@turbocorp.com>
` Re: Database Server Tuning
  2004-03-02 20:51 UTC  Vivek Khera <khera@kcilink.com>
` Re: Database Server Tuning
  2004-03-02 21:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-03-02 21:32 UTC  Vivek Khera <khera@kcilink.com>
` Re: Database Server Tuning
  2004-03-03 18:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-06-10 16:02 UTC  Anjan Dave <adave@vantage.com>
` Re: Database Server Tuning
  2004-06-10 16:51 UTC  Vivek Khera <khera@kcilink.com>
  [10+ messages in thread]

Index oddity
  2004-06-09 19:31 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity
  2004-06-09 20:12 UTC  Rod Taylor <pg@rbt.ca>
` Re: Index oddity
  2004-06-09 20:50 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity
  2004-06-09 20:56 UTC  Rod Taylor <pg@rbt.ca>
` Re: Index oddity
  2004-06-09 21:02 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity
  2004-06-09 21:29 UTC  Rod Taylor <pg@rbt.ca>
` Re: Index oddity
  2004-06-09 23:11 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity
  2004-06-10 01:45 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Index oddity
  2004-06-10 02:17 UTC  Rod Taylor <pg@rbt.ca>
` Re: Index oddity
  2004-06-10 03:08 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Index oddity
  2004-06-10 03:32 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Index oddity
  2004-06-10 05:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [12+ messages in thread]

Use of Functional Indexs and Planner estimates
  2004-06-08 07:24 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Use of Functional Indexs and Planner estimates
  2004-06-08 08:57 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Use of Functional Indexs and Planner estimates
  2004-06-08 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Use of Functional Indexs and Planner estimates
  2004-06-08 14:54 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Use of Functional Indexs and Planner estimates
  2004-06-09 15:59 UTC  Greg Stark <gsstark@mit.edu>
  [5+ messages in thread]

RamDisk
  2004-06-08 18:45 UTC  jason.servetar@ccgenesis.com

Join slow on "large" tables
  2004-06-07 22:19 UTC  Josué Maldonado <josue@lamundial.hn>
` Re: Join slow on "large" tables
  2004-06-07 22:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Join slow on "large" tables
  2004-06-07 22:47 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Join slow on "large" tables
  2004-06-07 23:12 UTC  Josué Maldonado <josue@lamundial.hn>
` Re: Join slow on "large" tables
  2004-06-07 23:21 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Join slow on "large" tables
  2004-06-07 23:30 UTC  Josué Maldonado <josue@lamundial.hn>
` Re: Join slow on "large" tables
  2004-06-08 05:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join slow on "large" tables
  2004-06-08 14:36 UTC  Josué Maldonado <josue@lamundial.hn>
` Re: Join slow on "large" tables
  2004-06-08 15:27 UTC  Scott Marlowe <smarlowe@qwest.net>
  [9+ messages in thread]

pl/pgsql and Transaction Isolation
  2004-06-07 16:31 UTC  Marcus Whitney <marcus@coldfeetcreative.com>
` Re: pl/pgsql and Transaction Isolation
  2004-06-08 04:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pl/pgsql and Transaction Isolation
  2004-06-08 14:19 UTC  Marcus Whitney <marcus@coldfeetcreative.com>
  [3+ messages in thread]

is it possible to for the planner to optimize this form?
  2004-06-07 17:30 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: is it possible to for the planner to optimize this form?
  2004-06-07 20:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: is it possible to for the planner to optimize this
  2004-06-07 23:31 UTC  Duane Lee - EGOVX <DLee@mail.maricopa.gov>
  [3+ messages in thread]

seq scan woes
  2004-06-07 19:45 UTC  Dan Langille <dan@langille.org>
` Re: seq scan woes
  2004-06-07 20:00 UTC  Rod Taylor <ports@rbt.ca>
` Re: seq scan woes
  2004-06-07 20:12 UTC  Dan Langille <dan@langille.org>
` Re: seq scan woes
  2004-06-07 20:38 UTC  Rod Taylor <ports@rbt.ca>
` Re: seq scan woes
  2004-06-07 21:02 UTC  Dan Langille <dan@langille.org>
` Re: seq scan woes
  2004-06-07 22:49 UTC  Dan Langille <dan@langille.org>
` Re: seq scan woes
  2004-06-07 22:55 UTC  Dan Langille <dan@langille.org>
  [7+ messages in thread]

Using a COPY...FROM through JDBC?
  2004-06-05 20:12 UTC  Steve Wampler <swampler@noao.edu>
` Re: Using a COPY...FROM through JDBC?
  2004-06-06 22:08 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Using a COPY...FROM through JDBC?
  2004-06-07 07:47 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Using a COPY...FROM through JDBC?
  2004-06-07 09:26 UTC  Kris Jurka <books@ejurka.com>
` Re: [PERFORM] Using a COPY...FROM through JDBC?
  2004-06-07 17:40 UTC  Steve Wampler <swampler@noao.edu>
` Re: [PERFORM] Using a COPY...FROM through JDBC?
  2004-06-07 17:59 UTC  Steve Wampler <swampler@noao.edu>
` Re: [PERFORM] Using a COPY...FROM through JDBC?
  2004-06-07 21:38 UTC  Kris Jurka <books@ejurka.com>
  [7+ messages in thread]

Relation of cpu_*_costs?
  2004-06-07 07:36 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: Relation of cpu_*_costs?
  2004-06-07 13:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Relation of cpu_*_costs?
  2004-06-07 17:19 UTC  SZŰCS Gábor <surrano@mailbox.hu>
  [3+ messages in thread]

PREPAREing statements versus compiling PLPGSQL
  2004-06-07 15:52 UTC  Mark Aufflick <mark@pumptheory.com>

Postgres function use makes machine crash.
  2004-06-07 11:34 UTC  Stef <svb@ucs.co.za>
` Re: Postgres function use makes machine crash.
  2004-06-07 15:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres function use makes machine crash.
  2004-06-07 15:34 UTC  Stef <svb@ucs.co.za>
  [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