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

the RAID question, again
  2003-04-16 16:26 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: the RAID question, again
  2003-04-17 02:32 UTC  Nikolaus Dilger <nikolaus@dilger.cc>
` Re: the RAID question, again
  2003-04-17 03:20 UTC  Josh Berkus <josh@agliodbs.com>
` Re: the RAID question, again
  2003-04-22 12:11 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: the RAID question, again
  2003-04-22 17:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: the RAID question, again
  2003-04-22 17:29 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: the RAID question, again
  2003-04-22 17:44 UTC  Will LaShell <will@lashell.net>
  [7+ messages in thread]

choosing the right platform
  2003-04-09 03:38 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: choosing the right platform
  2003-04-09 16:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: choosing the right platform
  2003-04-09 16:51 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: choosing the right platform
  2003-04-09 17:13 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: choosing the right platform
  2003-04-09 17:20 UTC  eric soroos <eric-psql@soroos.net>
` Re: choosing the right platform
  2003-04-09 17:55 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: choosing the right platform
  2003-04-09 18:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: choosing the right platform
  2003-04-09 23:45 UTC  Jim C. Nasby <jim@nasby.net>
` Re: choosing the right platform
  2003-04-09 23:47 UTC  Jim C. Nasby <jim@nasby.net>
` Re: choosing the right platform
  2003-04-09 23:58 UTC  Jim C. Nasby <jim@nasby.net>
` Re: choosing the right platform
  2003-04-10 16:42 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: choosing the right platform
  2003-04-10 16:51 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: choosing the right platform
  2003-04-10 17:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: choosing the right platform
  2003-04-22 08:30 UTC  Jim C. Nasby <jim@nasby.net>
  [14+ messages in thread]

problems
  2003-04-20 18:09 UTC  Ian Knopke <knopke@music.mcgill.ca>
` Re: problems
  2003-04-20 18:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Query speed problems
  2003-04-17 19:17 UTC  Victor Danilchenko <danilche@cs.umass.edu>
` Re: Query speed problems
  2003-04-17 19:38 UTC  Victor Danilchenko <danilche@cs.umass.edu>
` Re: Query speed problems
  2003-04-17 19:55 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Query speed problems
  2003-04-17 19:59 UTC  Peter Darley <pdarley@kinesis-cem.com>
` Re: Query speed problems
  2003-04-17 20:24 UTC  Victor Danilchenko <danilche@cs.umass.edu>
` Re: Query speed problems
  2003-04-17 20:29 UTC  Victor Danilchenko <danilche@cs.umass.edu>
` Re: Query speed problems
  2003-04-17 21:08 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Query speed problems
  2003-04-18 01:26 UTC  Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Query speed problems
  2003-04-18 15:01 UTC  Victor Danilchenko <danilche@cs.umass.edu>
  [9+ messages in thread]

Performance of Inherits versus Views
  2003-04-17 17:48 UTC  dex <dex@bridge3.com>

dum query plan: more info.
  2003-04-16 22:02 UTC  Jonathan Moore <moore@discern.com>
` Re: dum query plan: more info.
  2003-04-17 16:24 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: dum query plan: more info.
  2003-04-17 16:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

dum query plan
  2003-04-16 06:58 UTC  Jonathan Moore <moore@discern.com>
` Re: dum query plan
  2003-04-17 01:21 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: dum query plan
  2003-04-17 03:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: dum query plan
  2003-04-17 14:12 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
  [4+ messages in thread]

for help!
  2003-04-15 09:44 UTC  linweidong <wdlin@sis.sh.cn>
` Re: for help!
  2003-04-15 09:54 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: for help!
  2003-04-15 15:40 UTC  Will LaShell <will@lashell.net>
` Re: for help!
  2003-04-15 16:34 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: for help!
  2003-04-16 15:48 UTC  Josh Berkus <josh@agliodbs.com>
` Re: for help!
  2003-04-16 15:53 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: for help!
  2003-04-16 16:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: for help!
  2003-04-16 16:11 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [8+ messages in thread]

Do Views offer any performance advantage?
  2003-04-15 15:49 UTC  Robert John Shepherd <robert@reviewer.co.uk>
` Re: Do Views offer any performance advantage?
  2003-04-15 17:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Do Views offer any performance advantage?
  2003-04-15 19:55 UTC  Andreas Pflug <Andreas.Pflug@web.de>
` Re: Do Views offer any performance advantage?
  2003-04-15 23:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Do Views offer any performance advantage?
  2003-04-16 08:45 UTC  Andreas Pflug <Andreas.Pflug@web.de>
  [5+ messages in thread]

Is there a performance between Inherits and Views?
  2003-04-16 06:10 UTC  dex <dex@bridge3.com>

Using indexes for like foo% type queries when foo isn't constant (not a locale issue)
  2003-04-15 19:04 UTC  Greg Stark <gsstark@mit.edu>


[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