pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAdjusting fsm values was Re: [BUGS] db growing out of proportion
2003-06-13 03:49 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
new monster box CONF suggestion please
2003-06-12 16:33 UTC Patrick Hatcher <PHatcher@macys.com>
Table Relationships
2003-05-30 09:23 UTC Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
2003-05-30 10:10 UTC Victor Yegorov <viktors.jegorovs@nordlb.lv>
` Re: Table Relationships
2003-05-30 12:11 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Table Relationships
2003-05-30 13:34 UTC Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
2003-05-30 16:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
2003-05-30 16:19 UTC Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
2003-05-30 16:39 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Table Relationships
2003-05-30 17:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
2003-05-30 17:20 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Table Relationships
2003-05-30 18:18 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Table Relationships
2003-05-30 19:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
2003-06-12 09:32 UTC Andreas Kostyrka <andreas@mtg.co.at>
[12+ messages in thread]
FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-09 09:18 UTC Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 05:15 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 15:46 UTC Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 15:56 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 16:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 17:21 UTC Bruno Wolff III <bruno@wolff.to>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 18:12 UTC Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 18:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 19:08 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 19:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 23:10 UTC Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-10 23:25 UTC Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
2003-06-11 03:52 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[13+ messages in thread]
Hash or merge join instead of inner loop
2003-06-09 20:40 UTC Jim C. Nasby <jim@nasby.net>
` Re: Hash or merge join instead of inner loop
2003-06-10 06:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hash or merge join instead of inner loop
2003-06-10 08:56 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Hash or merge join instead of inner loop
2003-06-10 19:42 UTC Jim C. Nasby <jim@nasby.net>
` Re: Hash or merge join instead of inner loop
2003-06-10 20:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
[Fwd: Re: Enabling and disabling run time configuration parameters.]
2003-06-06 18:53 UTC Yusuf <yusuf0478@netscape.net>
Enabling and disabling run time configuration parameters.
2003-06-05 15:35 UTC Yusuf <yusuf0478@netscape.net>
` Re: Enabling and disabling run time configuration parameters.
2003-06-05 16:14 UTC Rod Taylor <rbt@rbt.ca>
` Re: Enabling and disabling run time configuration parameters.
2003-06-05 16:15 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Enabling and disabling run time configuration parameters.
2003-06-05 16:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Enabling and disabling run time configuration parameters.
2003-06-05 16:39 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Enabling and disabling run time configuration parameters.
2003-06-05 16:42 UTC scott.marlowe <scott.marlowe@ihs.com>
[6+ messages in thread]
Degrading performance
2003-06-02 05:33 UTC Mindaugas Riauba <mind@bi.lt>
` Re: Degrading performance
2003-06-02 13:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Degrading performance
2003-06-02 16:34 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Degrading performance
2003-06-02 17:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Degrading performance
2003-06-02 17:42 UTC scott.marlowe <scott.marlowe@ihs.com>
[5+ messages in thread]
Enabling and Disabling Sequencial Scan
2003-05-30 20:33 UTC Yusuf <yusuf0478@netscape.net>
` Re: Enabling and Disabling Sequencial Scan
2003-05-30 20:46 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Enabling and Disabling Sequencial Scan
2003-05-31 03:28 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Enabling and Disabling Sequencial Scan
2003-05-31 15:07 UTC Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Enabling and Disabling Sequencial Scan
2003-06-02 15:20 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Enabling and Disabling Sequencial Scan
2003-06-02 15:23 UTC scott.marlowe <scott.marlowe@ihs.com>
[6+ messages in thread]
Re: Index speeds up one row table (why)?
2003-05-31 22:56 UTC Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
2003-06-01 02:29 UTC Rod Taylor <rbt@rbt.ca>
` Re: Index speeds up one row table (why)?
2003-06-01 05:33 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index speeds up one row table (why)?
2003-06-01 07:20 UTC Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
2003-06-01 12:14 UTC Rod Taylor <rbt@rbt.ca>
` Re: Index speeds up one row table (why)?
2003-06-01 19:04 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index speeds up one row table (why)?
2003-06-02 07:14 UTC Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
2003-06-02 07:51 UTC Peter Childs <blue.dragon@blueyonder.co.uk>
[8+ messages in thread]
FW: Query Plan problem
2003-06-02 04:56 UTC George Papastamatopoulos <George.Papastamatopoulos@lawlex.com.au>
` Re: FW: Query Plan problem
2003-06-02 05:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: FW: Query Plan problem
2003-06-02 05:35 UTC Paul Smith <Paul.Smith@lawlex.com.au>
[3+ messages in thread]
Select Query Performance
2003-06-02 01:12 UTC Ricky Prasla <praslar@hotmail.com>
` Re: Select Query Performance
2003-06-02 01:48 UTC Rod Taylor <rbt@rbt.ca>
[2+ messages in thread]
are views typically any faster/slower than equivilent joins?
2003-06-01 02:55 UTC Brian Tarbox <btarbox@theworld.com>
` Re: are views typically any faster/slower than equivilent joins?
2003-06-01 04:02 UTC Rod Taylor <rbt@rbt.ca>
` Re: are views typically any faster/slower than equivilent joins?
2003-06-01 04:05 UTC Rod Taylor <rbt@rbt.ca>
` Re: are views typically any faster/slower than equivilent joins?
2003-06-01 05:43 UTC Bruno Wolff III <bruno@wolff.to>
` Re: are views typically any faster/slower than
2003-06-01 11:56 UTC Rod Taylor <rbt@rbt.ca>
[5+ messages in thread]
why Sequencial Scan when selecting on primary key of table?
2003-05-31 16:30 UTC Brian Tarbox <btarbox@theworld.com>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 17:02 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 17:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 17:45 UTC Brian Tarbox <btarbox@theworld.com>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 17:51 UTC Rod Taylor <rbt@rbt.ca>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 17:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 18:02 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: why Sequencial Scan when selecting on primary key of table?
2003-05-31 18:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
Yet Another (Simple) Case of Index not used
2003-04-08 19:57 UTC Denis <denis@next2me.com>
` Re: Yet Another (Simple) Case of Index not used
2003-04-08 20:25 UTC Dennis Gearon <gearond@cvc.net>
` Re: Yet Another (Simple) Case of Index not used
2003-04-08 20:26 UTC Dann Corbit <DCorbit@connx.com>
` Re: Yet Another (Simple) Case of Index not used
2003-04-08 20:43 UTC Dennis Gearon <gearond@cvc.net>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-08 21:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: Yet Another (Simple) Case of Index not used
2003-04-08 23:46 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [GENERAL] Yet Another (Simple) Case of Index not used
2003-04-09 00:10 UTC Denis @ Next2Me <denis@next2me.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-09 00:21 UTC Denis @ Next2Me <denis@next2me.com>
` Re: Yet Another (Simple) Case of Index not used
2003-04-09 00:44 UTC Brent Wood <b.wood@niwa.co.nz>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-09 01:59 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-09 02:35 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [GENERAL] Yet Another (Simple) Case of Index not used
2003-04-09 03:18 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [GENERAL] Yet Another (Simple) Case of Index not used
2003-04-09 05:54 UTC Denis @ Next2Me <denis@next2me.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-09 16:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Yet Another (Simple) Case of Index not used
2003-04-15 14:23 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] Yet Another (Simple) Case of Index not used
2003-04-15 16:29 UTC Richard Huxton <dev@archonet.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-19 13:01 UTC Kevin Brown <kevin@sysexperts.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-19 15:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-19 19:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-19 20:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 01:13 UTC Kevin Brown <kevin@sysexperts.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 03:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 06:28 UTC Kevin Brown <kevin@sysexperts.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 10:07 UTC Andreas Pflug <Andreas.Pflug@web.de>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 15:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 15:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 15:37 UTC Andreas Pflug <Andreas.Pflug@web.de>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-20 16:46 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-21 00:46 UTC Kevin Brown <kevin@sysexperts.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-21 01:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-21 16:14 UTC Josh Berkus <josh@agliodbs.com>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-22 08:23 UTC Jim C. Nasby <jim@nasby.net>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-22 08:33 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [SQL] Yet Another (Simple) Case of Index not used
2003-04-23 16:32 UTC Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] Yet Another (Simple) Case of Index not used
2003-05-31 02:31 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[35+ messages in thread]
Spam sent to addresses subscribed to psql-performance
2003-05-30 16:30 UTC pgsql-performance@sysd.com
Select query takes long to execute
2003-05-29 13:58 UTC Kevin Schroeder <mirage@mirageworks.com>
` Re: Select query takes long to execute
2003-05-29 14:24 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select query takes long to execute
2003-05-29 16:01 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Select query takes long to execute
2003-05-30 02:44 UTC Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Select query takes long to execute
2003-05-30 08:57 UTC SZUCS Gábor <surrano@mailbox.hu>
` Re: Select query takes long to execute
2003-05-30 12:13 UTC Bruno Wolff III <bruno@wolff.to>
[6+ messages in thread]
Query problem fixed
2003-05-29 14:09 UTC Kevin Schroeder <mirage@mirageworks.com>
` Re: Query problem fixed
2003-05-29 14:27 UTC SZUCS Gábor <surrano@mailbox.hu>
` Re: Query problem fixed
2003-05-29 14:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
IN list processing performance (yet again)
2003-05-28 12:51 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 13:16 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: IN list processing performance (yet again)
2003-05-28 13:19 UTC Andreas Pflug <Andreas.Pflug@web.de>
` Re: IN list processing performance (yet again)
2003-05-28 14:31 UTC Mario Weilguni <mweilguni@sime.com>
` Re: IN list processing performance (yet again)
2003-05-28 14:54 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: IN list processing performance (yet again)
2003-05-28 17:58 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 18:08 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 18:17 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 18:29 UTC Mario Weilguni <mweilguni@sime.com>
` Re: IN list processing performance (yet again)
2003-05-28 18:39 UTC Bruno Wolff III <bruno@wolff.to>
` Re: IN list processing performance (yet again)
2003-05-28 18:41 UTC Bruno Wolff III <bruno@wolff.to>
` Re: IN list processing performance (yet again)
2003-05-28 19:57 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 20:01 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 20:13 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-28 20:24 UTC Bruno Wolff III <bruno@wolff.to>
` Re: IN list processing performance (yet again)
2003-05-28 20:29 UTC Bruno Wolff III <bruno@wolff.to>
` Re: IN list processing performance (yet again)
2003-05-28 23:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: IN list processing performance (yet again)
2003-05-29 01:19 UTC Dave Tenny <tenny@attbi.com>
` Re: IN list processing performance (yet again)
2003-05-29 01:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: IN list processing performance (yet again)
2003-05-29 01:47 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: IN list processing performance (yet again)
2003-05-29 01:53 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: IN list processing performance (yet again)
2003-05-29 10:55 UTC Bruno Wolff III <bruno@wolff.to>
` Re: IN list processing performance (yet again)
2003-05-29 12:48 UTC Dave Tenny <tenny@attbi.com>
[23+ messages in thread]
>24 hour restore
2003-05-28 15:12 UTC Chad Thompson <chad@weblinkservices.com>
` Re: >24 hour restore
2003-05-28 15:55 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: >24 hour restore
2003-05-28 16:24 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: >24 hour restore
2003-05-28 17:59 UTC Chad Thompson <chad@weblinkservices.com>
` Re: >24 hour restore
2003-05-28 18:14 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: >24 hour restore
2003-05-29 06:18 UTC Victor Yegorov <viktors.jegorovs@nordlb.lv>
[6+ messages in thread]
Wildcard searches & performance question
2003-05-27 19:09 UTC Grega Bremec <grega.bremec@noviforum.si>
` Re: Wildcard searches & performance question
2003-05-27 19:37 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Wildcard searches & performance question
2003-05-27 19:48 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Wildcard searches & performance question
2003-05-27 19:55 UTC Josh Berkus <josh@agliodbs.com>
` Re: Wildcard searches & performance question
2003-05-27 20:06 UTC Rod Taylor <rbt@rbt.ca>
` Re: Wildcard searches & performance question
2003-05-28 20:52 UTC Grega Bremec <grega.bremec@noviforum.si>
` Re: Wildcard searches & performance question
2003-05-28 22:46 UTC scott.marlowe <scott.marlowe@ihs.com>
[7+ messages in thread]
recursive srf
2003-05-28 21:30 UTC Matthew Nuzum <cobalt@bearfruit.org>
(no subject)
2003-05-28 11:28 UTC Peter Lavender <plaven@bigpond.net.au>
Simplifying varchar and bpchar behavior
2003-05-23 20:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
Q: Structured index - which one runs faster?
2003-05-22 20:41 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: [GENERAL] Q: Structured index - which one runs faster?
2003-05-22 22:23 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Q: Structured index - which one runs faster?
2003-05-22 22:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-22 23:00 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-22 23:36 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: Q: Structured index - which one runs faster?
2003-05-22 23:43 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: Q: Structured index - which one runs faster?
2003-05-23 00:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 06:42 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 15:09 UTC Vivek Khera <khera@kcilink.com>
` Re: [GENERAL] Q: Structured index - which one runs faster?
2003-05-23 16:46 UTC Reece Hart <rkh@gene.COM>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 16:50 UTC Bruno Wolff III <bruno@wolff.to>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 17:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 18:04 UTC Vivek Khera <khera@kcilink.com>
` Re: [ADMIN] Q: Structured index - which one runs faster?
2003-05-23 18:30 UTC Manfred Koizar <mkoi-pg@aon.at>
[14+ 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