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