pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIndexing 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