pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
TEXT column and indexing
  2003-11-19 09:18 UTC  Ian Barwick <barwick@gmx.net>
` Re: TEXT column and indexing
  2003-11-19 16:26 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: TEXT column and indexing
  2003-11-19 16:35 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: TEXT column and indexing
  2003-11-19 19:13 UTC  Ian Barwick <barwick@gmx.net>
` Re: TEXT column and indexing
  2003-11-19 19:16 UTC  Ian Barwick <barwick@gmx.net>
  [5+ messages in thread]

constant vs function param differs in performance
  2003-11-14 15:08 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: constant vs function param differs in performance
  2003-11-14 20:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: constant vs function param differs in performance
  2003-11-19 16:04 UTC  SZŰCS Gábor <surrano@mailbox.hu>
  [3+ messages in thread]

Join on incompatible types
  2003-11-18 10:01 UTC  Laurent Martelli <laurent@bearteam.org>
` Re: Join on incompatible types
  2003-11-18 10:45 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Join on incompatible types
  2003-11-18 13:24 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Join on incompatible types
  2003-11-19 06:54 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Join on incompatible types
  2003-11-19 09:52 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Join on incompatible types
  2003-11-19 10:19 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Join on incompatible types
  2003-11-19 12:16 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Join on incompatible types
  2003-11-19 12:31 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
  [8+ messages in thread]

Top n queries and GROUP BY
  2003-11-17 16:38 UTC  Rich Cullingford <rculling@sysd.com>
` Re: Top n queries and GROUP BY
  2003-11-17 17:56 UTC  Rich Cullingford <rculling@sysd.com>
` Re: Top n queries and GROUP BY
  2003-11-18 17:01 UTC  Harald Fuchs <nospam@sap.com>
  [3+ messages in thread]

start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-16 11:58 UTC  Hannu Krosing <hannu@tm.ee>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-16 14:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: start of transaction (was: Re: [PERFORM] Help with
  2003-11-16 15:51 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-16 22:55 UTC  Neil Conway <neilc@samurai.com>
` start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-16 23:18 UTC  Neil Conway <neilc@samurai.com>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-17 00:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-17 00:31 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-17 06:11 UTC  Greg Stark <gsstark@mit.edu>
` Re: start of transaction (was: Re: [PERFORM] Help with
  2003-11-17 07:09 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: start of transaction (was: Re: [PERFORM] Help with
  2003-11-17 10:16 UTC  Hannu Krosing <hannu@tm.ee>
` Re: start of transaction (was: Re: [PERFORM] Help with
  2003-11-17 10:19 UTC  Hannu Krosing <hannu@tm.ee>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-18 00:52 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: start of transaction (was: Re: [PERFORM] Help with count(*))
  2003-11-18 07:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [13+ messages in thread]

INSERT extremely slow with large data sets (fwd)
  2003-11-14 09:38 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
` Re: INSERT extremely slow with large data sets (fwd)
  2003-11-14 13:37 UTC  Jeff <threshar@torgo.978.org>
` Re: INSERT extremely slow with large data sets (fwd)
  2003-11-14 22:02 UTC  George Essig <george_essig@yahoo.com>
` Re: INSERT extremely slow with large data sets (fwd)
  2003-11-15 01:20 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
` Re: INSERT extremely slow with large data sets (fwd)
  2003-11-15 13:13 UTC  George Essig <george_essig@yahoo.com>
` Re: INSERT extremely slow with large data sets (fwd)
  2003-11-17 14:42 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [6+ messages in thread]

Re: start of transaction
  2003-11-17 10:43 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

Help with count(*)
  2003-11-14 07:21 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Help with count(*)
  2003-11-14 07:30 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Help with count(*)
  2003-11-14 14:13 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Help with count(*)
  2003-11-14 17:43 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Help with count(*)
  2003-11-14 18:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with count(*)
  2003-11-14 19:16 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Help with count(*)
  2003-11-14 19:40 UTC  Will LaShell <will@lashell.net>
` Re: Help with count(*)
  2003-11-14 20:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with count(*)
  2003-11-14 21:30 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Help with count(*)
  2003-11-15 10:21 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Help with count(*)
  2003-11-15 20:20 UTC  Neil Conway <neilc@samurai.com>
` Re: Help with count(*)
  2003-11-16 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [12+ messages in thread]

n_distinct way off, but following a pattern.
  2003-11-14 21:27 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: n_distinct way off, but following a pattern.
  2003-11-14 22:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: n_distinct way off, but following a pattern.
  2003-11-16 13:52 UTC  Nick Fankhauser <nickf@ontko.com>
  [3+ messages in thread]

Re: Error in transaction processing
  2003-11-14 22:07 UTC  radha.manohar@ndsu.nodak.edu
` Re: Error in transaction processing
  2003-11-15 14:52 UTC  radha.manohar@ndsu.nodak.edu
  [2+ messages in thread]

Query question
  2003-11-13 04:09 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query question
  2003-11-13 05:20 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Query question
  2003-11-14 16:07 UTC  Neil Conway <neilc@samurai.com>
` Re: Query question
  2003-11-14 16:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query question
  2003-11-15 03:35 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [5+ messages in thread]

IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 07:53 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 14:56 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 15:31 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 17:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-13 17:19 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-14 16:01 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: IN surpasses NOT EXISTS in 7.4RC2 ??
  2003-11-14 19:27 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [8+ messages in thread]

Seeking help with a query that takes too long
  2003-11-12 13:34 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-12 15:04 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Seeking help with a query that takes too long
  2003-11-12 15:55 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-12 16:05 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-12 16:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seeking help with a query that takes too long
  2003-11-12 16:52 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-12 17:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seeking help with a query that takes too long
  2003-11-12 18:27 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-12 22:25 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Seeking help with a query that takes too long
  2003-11-14 16:00 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Seeking help with a query that takes too long
  2003-11-14 16:35 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [11+ messages in thread]

IDE Hardware RAID Controller
  2003-11-14 10:11 UTC  Nick Barr <nicky@chuckie.co.uk>

strange estimate for number of rows
  2003-11-13 18:14 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: strange estimate for number of rows
  2003-11-13 18:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: strange estimate for number of rows
  2003-11-13 19:35 UTC  Daniel Manley <dmanley@libertyrms.info>
` Re: strange estimate for number of rows
  2003-11-13 20:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: strange estimate for number of rows
  2003-11-13 21:37 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: strange estimate for number of rows
  2003-11-13 21:52 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [6+ messages in thread]

Storage space, RAM for NUMERIC
  2003-11-13 19:36 UTC  Josh Berkus <josh@agliodbs.com>

Union+group by planner estimates way off?
  2003-11-13 18:28 UTC  Arthur Ward <award@dominionsciences.com>
` Re: Union+group by planner estimates way off?
  2003-11-13 18:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Union+group by planner estimates way off?
  2003-11-13 19:19 UTC  Arthur Ward <award@dominionsciences.com>
  [3+ messages in thread]

Value of Quad vs. Dual Processor machine
  2003-11-11 23:32 UTC  Chris Field <cfield@affinitysolutions.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-11 23:51 UTC  Rod Taylor <pg@rbt.ca>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 00:40 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 01:02 UTC  Allan Wind <allanwind@lifeintegrity.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 01:11 UTC  fred@redhotpenguin.com
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 01:24 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 02:13 UTC  Chris Field <cfield@affinitysolutions.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 03:17 UTC  Fred Moyer <fred@redhotpenguin.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 08:42 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 14:28 UTC  Jeff <threshar@torgo.978.org>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-12 15:53 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Value of Quad vs. Dual Processor machine
  2003-11-13 15:52 UTC  Robert Treat <xzilla@users.sourceforge.net>
  [12+ messages in thread]

performance optimzations
  2003-11-12 17:34 UTC  Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
` Re: performance optimzations
  2003-11-12 18:23 UTC  Rod Taylor <pg@rbt.ca>
` Re: performance optimzations
  2003-11-12 18:51 UTC  Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
` Re: performance optimzations
  2003-11-12 22:29 UTC  Neil Conway <neilc@samurai.com>
` Re: performance optimzations
  2003-11-13 00:15 UTC  Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
` Re: performance optimzations
  2003-11-13 04:35 UTC  Rod Taylor <pg@rbt.ca>
` Re: performance optimzations
  2003-11-13 05:58 UTC  Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
` Re: performance optimzations
  2003-11-13 13:47 UTC  Rod Taylor <pg@rbt.ca>
  [8+ messages in thread]

Re: Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-11 18:08 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-11 18:25 UTC  Josh Berkus <josh@agliodbs.com>
` Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-12 14:47 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-12 15:04 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-12 20:16 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Suggestions for benchmarking 7.4RC2 against 7.3
  2003-11-12 21:25 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [6+ messages in thread]

*very* slow query to summarize data for a month ...
  2003-11-10 20:18 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 20:31 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 20:32 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 20:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 22:51 UTC  Neil Conway <neilc@samurai.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 23:15 UTC  Neil Conway <neilc@samurai.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-10 23:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 00:19 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 00:28 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 00:49 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 06:50 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 17:47 UTC  Greg Stark <gsstark@mit.edu>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 18:14 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 18:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 18:38 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 19:51 UTC  Greg Stark <gsstark@mit.edu>
` Re: *very* slow query to summarize data for a month ...
  2003-11-11 21:25 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: *very* slow query to summarize data for a month ...
  2003-11-12 05:52 UTC  Greg Stark <gsstark@mit.edu>
` Re: *very* slow query to summarize data for a month ...
  2003-11-12 16:08 UTC  Marc G. Fournier <scrappy@postgresql.org>
  [19+ messages in thread]

Superior performance in PG 7.4
  2003-11-12 15:41 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>

Re: Server Configs
  2003-11-11 22:57 UTC  Anjan Dave <adave@vantage.com>

Seeking help with a query that take too long
  2003-11-11 22:26 UTC  Nick Fankhauser - Doxpop <nickf@doxpop.com>

Re: error while executing a c program with embedded sql
  2003-11-09 15:06 UTC  radha.manohar@ndsu.nodak.edu
` Re: error while executing a c program with embedded sql
  2003-11-09 15:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: error while executing a c program with embedded sql
  2003-11-09 17:32 UTC  Oliver Elphick <olly@lfix.co.uk>
` Re: error while executing a c program with embedded sql
  2003-11-10 15:00 UTC  radha.manohar@ndsu.nodak.edu
` Re: [PERFORM] error while executing a c program with embedded sql
  2003-11-10 16:27 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [5+ 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