pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Suggestions wanted for 7.2.4 query
  2003-05-04 02:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-04 04:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-04 16:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-04 17:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-04 17:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-05 17:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Suggestions wanted for 7.2.4 query
  2003-05-05 19:27 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Indices are not used by the optimizer
  2003-05-05 12:16 UTC  Reiner Dassing <dassing@wettzell.ifag.de>
` Re: Indices are not used by the optimizer
  2003-05-05 13:33 UTC  Rod Taylor <rbt@rbt.ca>
` Re: [SQL] Indices are not used by the optimizer
  2003-05-05 18:38 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [3+ messages in thread]

looking for large dataset
  2003-05-03 05:52 UTC  Antoine <asolomon15@nyc.rr.com>
` Re: looking for large dataset
  2003-05-03 10:04 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: looking for large dataset
  2003-05-03 15:13 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: looking for large dataset
  2003-05-05 16:25 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [4+ messages in thread]

Wrong index usage in 7.3.2
  2003-05-05 12:30 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>

More tablescanning fun
  2003-04-24 23:38 UTC  Jim C. Nasby <jim@nasby.net>
` Re: More tablescanning fun
  2003-04-24 23:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: More tablescanning fun
  2003-04-25 04:59 UTC  Jim C. Nasby <jim@nasby.net>
` Re: More tablescanning fun
  2003-04-25 05:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: More tablescanning fun
  2003-04-25 14:38 UTC  Jim C. Nasby <jim@nasby.net>
` Re: More tablescanning fun
  2003-04-25 16:28 UTC  Hannu Krosing <hannu@tm.ee>
` Re: More tablescanning fun
  2003-04-25 16:56 UTC  Jim C. Nasby <jim@nasby.net>
` Re: More tablescanning fun
  2003-04-25 20:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: More tablescanning fun
  2003-04-27 06:50 UTC  Hannu Krosing <hannu@tm.ee>
` Re: More tablescanning fun
  2003-04-30 14:14 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: More tablescanning fun
  2003-05-04 16:22 UTC  Jim C. Nasby <jim@nasby.net>
  [11+ messages in thread]

Re: NOT IN doesn't use index? (fwd)
  2003-05-03 17:57 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 18:34 UTC  Josh Berkus <josh@agliodbs.com>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 18:34 UTC  Joe Conway <mail@joeconway.com>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 19:08 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 19:31 UTC  Joe Conway <mail@joeconway.com>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 19:56 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 20:24 UTC  Joe Conway <mail@joeconway.com>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-03 21:16 UTC  Rod Taylor <rbt@rbt.ca>
` Re: NOT IN doesn't use index? (fwd)
  2003-05-04 04:05 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [9+ messages in thread]

why is the db so slow?
  2003-05-03 17:40 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: why is the db so slow?
  2003-05-03 18:31 UTC  Joe Conway <mail@joeconway.com>
` Re: why is the db so slow?
  2003-05-03 18:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: why is the db so slow?
  2003-05-03 20:30 UTC  brew@theMode.com
  [4+ messages in thread]

NOT IN doesn't use index?
  2003-05-03 05:56 UTC  Becky Neville <rebecca.neville@yale.edu>
` Re: NOT IN doesn't use index?
  2003-05-03 14:52 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [2+ messages in thread]

Query Priority
  2003-05-02 12:55 UTC  Peter Childs <blue.dragon@blueyonder.co.uk>
` Re: Query Priority
  2003-05-02 14:05 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Query Priority
  2003-05-02 14:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Priority
  2003-05-03 03:10 UTC  Ron Mayer <ron@intervideo.com>
  [4+ messages in thread]

Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-04-30 16:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-04-30 18:48 UTC  Josh Berkus <josh@agliodbs.com>
` 7.3 analyze & vacuum analyze problem
  2003-04-30 20:57 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-04-30 21:13 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-04-30 22:16 UTC  Ron Mayer <ron@intervideo.com>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-05-01 00:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-05-01 01:51 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-05-02 16:29 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] 7.3 analyze & vacuum analyze problem
  2003-05-02 19:03 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [9+ messages in thread]

profiling plpgsql functions..
  2003-04-29 11:25 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: profiling plpgsql functions..
  2003-04-29 14:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: profiling plpgsql functions..
  2003-04-29 15:56 UTC  mallah@trade-india.com
` Re: profiling plpgsql functions..
  2003-04-29 16:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: profiling plpgsql functions..
  2003-05-01 14:59 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [5+ messages in thread]

Like search performance.
  2003-04-30 16:34 UTC  Diehl, Jeffrey <jdiehl@sandia.gov>
` Re: Like search performance.
  2003-04-30 16:59 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: Like search performance.
  2003-04-30 17:08 UTC  Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Like search performance.
  2003-04-30 17:33 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ messages in thread]

Why LIMIT after scanning the table?
  2003-04-30 06:04 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Why LIMIT after scanning the table?
  2003-04-30 14:19 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Why LIMIT after scanning the table?
  2003-04-30 14:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why LIMIT after scanning the table?
  2003-04-30 16:23 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
  [4+ messages in thread]

Query Plan far worse in  7.3.2 than 7.2.1
  2003-04-29 13:01 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-29 14:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-29 16:03 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-29 23:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-30 11:00 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-30 14:39 UTC  Peter Darley <pdarley@kinesis-cem.com>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-30 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan far worse in 7.3.2 than 7.2.1
  2003-04-30 15:09 UTC  Peter Darley <pdarley@kinesis-cem.com>
  [8+ messages in thread]

Is 292 inserts/sec acceptable performance ?
  2003-04-29 07:01 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Is 292 inserts/sec acceptable performance ?
  2003-04-29 07:25 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Is 292 inserts/sec acceptable performance ?
  2003-04-29 11:12 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Is 292 inserts/sec acceptable performance ?
  2003-04-29 14:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Is 292 inserts/sec acceptable performance ?
  2003-04-29 15:48 UTC  mallah@trade-india.com
` Re: Is 292 inserts/sec acceptable performance ?
  2003-04-30 07:39 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [6+ messages in thread]

Best ODBC cursor and lock types for fastest reading?
  2003-04-29 13:53 UTC  Robert John Shepherd <robert@reviewer.co.uk>
` Re: Best ODBC cursor and lock types for fastest reading?
  2003-04-29 15:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Best ODBC cursor and lock types for fastest reading?
  2003-04-29 15:43 UTC  Robert John Shepherd <robert@reviewer.co.uk>
  [3+ messages in thread]

Optimizer not using index when it should
  2003-04-29 09:03 UTC  Rob Messer <rrmesser@yahoo.com>
` Re: Optimizer not using index when it should
  2003-04-29 13:04 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Optimizer not using index when it should
  2003-04-29 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Re: [HACKERS] Changing the default configuration
  2003-02-12 01:10 UTC  Tatsuo Ishii <t-ishii@sra.co.jp>
` Re: Changing the default configuration
  2003-02-12 01:10 UTC  Tatsuo Ishii <t-ishii@sra.co.jp>
` Re: Changing the default configuration
  2003-02-12 01:10 UTC  Tatsuo Ishii <t-ishii@sra.co.jp>
` Re: Changing the default configuration
  2003-02-12 01:23 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Changing the default configuration
  2003-02-12 02:00 UTC  Tatsuo Ishii <t-ishii@sra.co.jp>
` Re: Changing the default configuration
  2003-02-12 16:36 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Changing the default configuration
  2003-02-12 16:43 UTC  Greg Copeland <greg@CopelandConsulting.Net>
` Re: Changing the default configuration
  2003-02-12 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Changing the default configuration
  2003-02-12 18:30 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Changing the default configuration
  2003-02-13 01:43 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [HACKERS] Changing the default configuration
  2003-02-14 04:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [HACKERS] Changing the default configuration
  2003-04-29 04:41 UTC  Matthew T. O'Connor <matthew@zeut.net>
  [12+ messages in thread]

How to get the optimizer to use an index with multiple fields
  2003-04-28 18:21 UTC  Jim C. Nasby <jim@nasby.net>
` Re: How to get the optimizer to use an index with multiple fields
  2003-04-28 18:32 UTC  Jim C. Nasby <jim@nasby.net>
` Re: How to get the optimizer to use an index with multiple
  2003-04-28 19:52 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: How to get the optimizer to use an index with multiple
  2003-04-28 22:54 UTC  Jim C. Nasby <jim@nasby.net>
  [4+ messages in thread]

Diferent execution plan for similar query
  2003-04-28 10:26 UTC  jgimenez@sipec_quitaesto_.es
` Re: Diferent execution plan for similar query
  2003-04-28 10:41 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Diferent execution plan for similar query
  2003-04-28 10:59 UTC  Magnus Naeslund(w) <mag@fbab.net>
` Re: Diferent execution plan for similar query
  2003-04-28 11:00 UTC  Magnus Naeslund(w) <mag@fbab.net>
` Re: [PERFORM] Diferent execution plan for similar query
  2003-04-28 11:00 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Diferent execution plan for similar query
  2003-04-28 11:12 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [6+ messages in thread]

pgsql BLOB issues
  2003-04-28 02:30 UTC  Jeremy Andrus <jeremy@jeremya.com>
` Re: pgsql BLOB issues
  2003-04-28 05:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql BLOB issues
  2003-04-28 05:33 UTC  Jeremy Andrus <jeremy@jeremya.com>
` Re: pgsql BLOB issues
  2003-04-28 08:19 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [4+ messages in thread]

Automatic analyze on select into
  2003-04-26 15:15 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Automatic analyze on select into
  2003-04-26 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Automatic analyze on select into
  2003-04-26 18:16 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Automatic analyze on select into
  2003-04-26 18:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Indexes with different datatypes:Correction
  2003-04-25 22:36 UTC  Cecilia Alvarez <cecilia_ag@hotmail.com>
` Re: Indexes with different datatypes:Correction
  2003-04-25 22:40 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [2+ messages in thread]

Indexes with different datatypes
  2003-04-25 22:33 UTC  Cecilia Alvarez <cecilia_ag@hotmail.com>

Important speed difference between a query and a function with the same query
  2003-04-23 17:53 UTC  Frederic Jolliton <fred-pg@jolliton.com>
` Re: Important speed difference between a query and a
  2003-04-24 15:47 UTC  Frederic Jolliton <fred-pg@jolliton.com>
` Re: Important speed difference between a query and a
  2003-04-24 15:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Important speed difference between a query and a
  2003-04-24 15:57 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Important speed difference between a query and a
  2003-04-24 16:33 UTC  Frederic Jolliton <fred-pg@jolliton.com>
` Re: Important speed difference between a query and a
  2003-04-24 16:41 UTC  Frederic Jolliton <fred-pg@jolliton.com>
` Re: Important speed difference between a query and a
  2003-04-24 17:28 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Important speed difference between a query and a
  2003-04-24 17:40 UTC  Frederic Jolliton <fred-pg@jolliton.com>
` Re: Important speed difference between a query and a
  2003-04-25 07:01 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Important speed difference between a query and a function with the same query
  2003-04-25 15:09 UTC  Jim C. Nasby <jim@nasby.net>
  [10+ 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