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