pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOptimizing >= and <= for numbers and dates
2003-10-01 17:30 UTC Dimitri Nagiev <dnagiev@gmx.de>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 17:38 UTC Rod Taylor <rbt@rbt.ca>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 17:45 UTC Dimitri Nagiev <dnagiev@gmx.de>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 18:35 UTC Neil Conway <neilc@samurai.com>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 19:03 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 19:04 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Optimizing >= and <= for numbers and dates
2003-10-01 19:06 UTC Manfred Koizar <mkoi-pg@aon.at>
[7+ messages in thread]
What is the fastest null WHERE
2003-10-01 12:11 UTC Mindaugas Riauba <mind@bi.lt>
` Re: What is the fastest null WHERE
2003-10-01 12:32 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: What is the fastest null WHERE
2003-10-01 12:39 UTC Richard Huxton <dev@archonet.com>
` Re: What is the fastest null WHERE
2003-10-01 12:51 UTC Rod Taylor <rbt@rbt.ca>
` Re: What is the fastest null WHERE
2003-10-01 13:05 UTC Mindaugas Riauba <mind@bi.lt>
[5+ messages in thread]
advice on raid controller
2003-09-27 17:24 UTC Richard Jones <rj@last.fm>
` Re: advice on raid controller
2003-09-27 19:31 UTC Allan Wind <allanwind@lifeintegrity.com>
` Re: advice on raid controller
2003-09-27 19:53 UTC Josh Berkus <josh@agliodbs.com>
` Re: advice on raid controller
2003-09-27 19:53 UTC Ron Johnson <ron.l.johnson@cox.net>
` Re: advice on raid controller
2003-09-28 12:07 UTC Matt Clark <matt@ymogen.net>
` Re: advice on raid controller
2003-09-29 13:48 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: advice on raid controller
2003-09-29 17:20 UTC Will LaShell <will@lashell.net>
` Re: advice on raid controller
2003-09-29 19:40 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: advice on raid controller
2003-09-29 21:31 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: advice on raid controller
2003-09-29 21:35 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: advice on raid controller
2003-09-29 21:41 UTC Matt Clark <matt@ymogen.net>
` Re: advice on raid controller
2003-09-29 21:52 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: advice on raid controller
2003-09-30 20:30 UTC Vivek Khera <khera@kcilink.com>
` Re: advice on raid controller
2003-09-30 20:32 UTC Vivek Khera <khera@kcilink.com>
[14+ messages in thread]
Tuning/performance issue (part 2)
2003-09-30 20:25 UTC David Griffiths <dgriffiths@boats.com>
avoiding seqscan?
2003-09-28 20:54 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: avoiding seqscan?
2003-09-28 21:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: avoiding seqscan?
2003-09-28 22:54 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: avoiding seqscan?
2003-09-28 22:56 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: avoiding seqscan?
2003-09-29 02:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: avoiding seqscan?
2003-09-29 13:25 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: avoiding seqscan?
2003-09-29 13:31 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: avoiding seqscan?
2003-09-29 13:32 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: avoiding seqscan?
2003-09-29 13:45 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: avoiding seqscan?
2003-09-29 15:12 UTC Christopher Browne <cbbrowne@libertyrms.info>
` Re: avoiding seqscan?
2003-09-29 21:27 UTC Palle Girgensohn <girgen@pingpong.net>
[11+ messages in thread]
Performance: BigInt vs Decimal(19,0)
2003-09-27 23:54 UTC Yusuf W. <unicef2k@yahoo.com>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-28 00:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-28 02:39 UTC Yusuf W. <unicef2k@yahoo.com>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-28 03:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-29 14:59 UTC Franco Bruno Borghesi <franco@akyasociados.com.ar>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-29 17:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance: BigInt vs Decimal(19,0)
2003-09-29 17:26 UTC Andrew Rawnsley <ronz@ravensfield.com>
[7+ messages in thread]
Plan-Reading
2003-09-26 16:47 UTC Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: [PERFORM] Plan-Reading
2003-09-26 17:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Plan-Reading
2003-09-29 15:23 UTC greg@turnstep.com
[3+ messages in thread]
Tuning/performance question.
2003-09-28 03:49 UTC David Griffiths <dgriffiths@boats.com>
` Re: Tuning/performance question.
2003-09-28 10:09 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Tuning/performance question.
2003-09-28 11:13 UTC Holger Marzen <holger@marzen.de>
` Re: Tuning/performance question.
2003-09-28 16:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning/performance question.
2003-09-28 17:01 UTC David Griffiths <dgriffiths@boats.com>
` Re: Tuning/performance question.
2003-09-28 17:02 UTC David Griffiths <dgriffiths@boats.com>
` Re: Tuning/performance question.
2003-09-28 18:21 UTC Dennis Gearon <gearond@fireserve.net>
[7+ messages in thread]
Indices arent being used
2003-09-25 22:28 UTC rantunes@student.dei.uc.pt
` Re: Indices arent being used
2003-09-25 23:46 UTC Rod Taylor <rbt@rbt.ca>
` Re: Indices arent being used
2003-09-26 07:25 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Indices arent being used
2003-09-26 10:57 UTC rantunes@student.dei.uc.pt
` Re: Indices arent being used
2003-09-26 14:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indices arent being used
2003-09-27 14:48 UTC rantunes@student.dei.uc.pt
` Re: Indices arent being used
2003-09-27 17:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
populate table with large csv file
2003-09-25 16:38 UTC Dave [Hawk-Systems] <dave@hawk-systems.com>
` Re: populate table with large csv file
2003-09-25 16:43 UTC Joe Conway <mail@joeconway.com>
` Re: populate table with large csv file
2003-09-25 16:50 UTC P.J. "Josh" Rovero <rovero@sonalysts.com>
` Re: populate table with large csv file
2003-09-25 16:57 UTC Ron Johnson <ron.l.johnson@cox.net>
` Re: populate table with large csv file
2003-09-26 11:58 UTC Dave [Hawk-Systems] <dave@hawk-systems.com>
` Re: populate table with large csv file
2003-09-26 12:37 UTC Ron Johnson <ron.l.johnson@cox.net>
[6+ messages in thread]
upping checkpoints on production server
2003-09-24 21:24 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: upping checkpoints on production server
2003-09-24 21:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: upping checkpoints on production server
2003-09-25 15:23 UTC Robert Treat <xzilla@users.sourceforge.net>
[3+ messages in thread]
performance hit when joining with a view?
2003-09-25 12:36 UTC Palle Girgensohn <girgen@pingpong.net>
` Re: performance hit when joining with a view?
2003-09-25 13:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
osdl-dbt3 run results - puzzled by the execution plans
2003-09-18 22:36 UTC Jenny Zhang <jenny@osdl.org>
` Re: osdl-dbt3 run results - puzzled by the execution plans
2003-09-18 23:19 UTC Matt Clark <matt@ymogen.net>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-19 00:52 UTC Jenny Zhang <jenny@osdl.org>
` Re: osdl-dbt3 run results - puzzled by the execution plans
2003-09-19 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-19 10:41 UTC Matt Clark <matt@ymogen.net>
` Re: osdl-dbt3 run results - puzzled by the execution plans
2003-09-19 13:12 UTC Greg Stark <gsstark@mit.edu>
` Re: osdl-dbt3 run results - puzzled by the execution plans
2003-09-19 15:08 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-19 18:35 UTC Jenny Zhang <jenny@osdl.org>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-19 21:35 UTC Jenny Zhang <jenny@osdl.org>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-19 23:26 UTC Jenny Zhang <jenny@osdl.org>
` Re: osdl-dbt3 run results - puzzled by the execution
2003-09-24 09:14 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [HACKERS] osdl-dbt3 run results - puzzled by the execution
2003-09-24 14:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
[12+ messages in thread]
LIKE query running slow
2003-09-24 00:24 UTC Garrett Bladow <bbladow@sendit.nodak.edu>
` Re: LIKE query running slow
2003-09-24 00:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: LIKE query running slow
2003-09-24 00:41 UTC Garrett Bladow <bladow@rocko.cc.ndsu.nodak.edu>
` Re: LIKE query running slow
2003-09-24 00:53 UTC Rod Taylor <rbt@rbt.ca>
` Re: LIKE query running slow
2003-09-24 05:20 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: LIKE query running slow
2003-09-24 06:06 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: LIKE query running slow
2003-09-24 12:12 UTC Jeff <threshar@torgo.978.org>
[7+ messages in thread]
restore time: sort_mem vs. checkpoing_segments
2003-09-15 19:15 UTC Vivek Khera <khera@kcilink.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-15 21:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-16 05:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-16 13:59 UTC Vivek Khera <khera@kcilink.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-17 20:15 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-17 20:21 UTC Vivek Khera <khera@kcilink.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-22 20:17 UTC Vivek Khera <khera@kcilink.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-23 13:59 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-23 14:27 UTC Vivek Khera <khera@kcilink.com>
` Re: restore time: sort_mem vs. checkpoing_segments
2003-09-24 05:24 UTC Dennis Bjorklund <db@zigo.dhs.org>
[10+ messages in thread]
How to make n_distinct more accurate.
2003-09-22 20:42 UTC Nick Fankhauser <nickf@ontko.com>
` Re: How to make n_distinct more accurate.
2003-09-24 02:32 UTC Nick Fankhauser <nickf@ontko.com>
[2+ messages in thread]
Sexier, Plumper L|ps can be yours only $24.76
2003-09-20 17:21 UTC Beauty Center <delmypushaw@reciproca.flyingoff.com>
rewrite in to exists?
2003-09-18 04:59 UTC LN Cisneros <lnsea@earthlink.net>
` Re: rewrite in to exists?
2003-09-18 05:23 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: rewrite in to exists?
2003-09-18 09:16 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: rewrite in to exists?
2003-09-18 14:59 UTC LN Cisneros <lnsea@earthlink.net>
` Re: rewrite in to exists?
2003-09-18 17:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: rewrite in to exists?
2003-09-18 19:27 UTC LN Cisneros <lnsea@earthlink.net>
` Re: rewrite in to exists?
2003-09-19 08:57 UTC Manfred Koizar <mkoi-pg@aon.at>
[7+ messages in thread]
Many fields in one table or many tables?
2003-09-18 08:13 UTC Alexander Priem <ap@cict.nl>
` Re: Many fields in one table or many tables?
2003-09-18 17:27 UTC Josh Berkus <josh@agliodbs.com>
` Re: Many fields in one table or many tables?
2003-09-18 18:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
How to force an Index ?
2003-09-17 22:17 UTC Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: How to force an Index ?
2003-09-17 22:38 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] How to force an Index ?
2003-09-18 14:45 UTC Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: [PERFORM] How to force an Index ?
2003-09-18 16:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to force an Index ?
2003-09-18 17:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: How to force an Index ?
2003-09-18 18:02 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
Re: Find one record
2003-09-18 17:53 UTC Josh Berkus <josh@agliodbs.com>
` Find one record
2003-09-18 18:01 UTC Joseph Bove <jbove@vetstar.com>
[2+ messages in thread]
Is there a reason _not_ to vacuum continuously?
2003-09-17 19:40 UTC Matt Clark <matt@ymogen.net>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-17 19:54 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-17 20:13 UTC Josh Berkus <josh@agliodbs.com>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-17 20:20 UTC Matt Clark <matt@ymogen.net>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-17 20:24 UTC Matt Clark <matt@ymogen.net>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-17 22:17 UTC Josh Berkus <josh@agliodbs.com>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 01:59 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 08:18 UTC Oliver Scheit <oliver.scheit@REALGARANT.DE>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 08:24 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 08:29 UTC Oliver Scheit <oliver.scheit@REALGARANT.DE>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 08:48 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 09:29 UTC Oliver Scheit <oliver.scheit@REALGARANT.DE>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 14:47 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Is there a reason _not_ to vacuum continuously?
2003-09-18 17:30 UTC Josh Berkus <josh@agliodbs.com>
[14+ messages in thread]
Effective Cache Size
2003-07-01 13:50 UTC Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: Effective Cache Size
2003-07-01 14:02 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Effective Cache Size
2003-07-01 14:18 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Effective Cache Size
2003-07-01 18:22 UTC Manfred Koizar <mkoi-pg@aon.at>
` Effective Cache Size
2003-09-17 10:48 UTC Nick Barr <nick.barr@webbased.co.uk>
` Re: Effective Cache Size
2003-09-17 11:03 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
[6+ messages in thread]
[GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-04 17:41 UTC Mary Edie Meredith <maryedie@osdl.org>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-04 17:46 UTC Rod Taylor <rbt@rbt.ca>
` Re: [GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-04 23:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-04 23:50 UTC Neil Conway <neilc@samurai.com>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 00:01 UTC Mary Edie Meredith <maryedie@osdl.org>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 00:29 UTC Rod Taylor <rbt@rbt.ca>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 17:44 UTC Mary Edie Meredith <maryedie@osdl.org>
` Re: [GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-05 18:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 20:49 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 20:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-05 21:02 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-07 16:22 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-07 23:18 UTC Greg Stark <gsstark@mit.edu>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-08 00:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-10 19:44 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-10 22:22 UTC Christopher Browne <cbbrowne@libertyrms.info>
` Re: [GENERAL] how to get accurate values in pg_statistic (continued)
2003-09-11 04:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-11 15:55 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-11 16:32 UTC Christopher Browne <cbbrowne@libertyrms.info>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-12 15:19 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-17 00:21 UTC Mary Edie Meredith <maryedie@osdl.org>
` Re: [GENERAL] how to get accurate values in pg_statistic
2003-09-17 04:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[22+ messages in thread]
Inconsistent performance
2003-09-15 21:34 UTC Joseph Bove <jbove@vetstar.com>
` Re: Inconsistent performance
2003-09-15 21:34 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Inconsistent performance
2003-09-15 21:42 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Inconsistent performance
2003-09-15 22:15 UTC Josh Berkus <josh@agliodbs.com>
` Re: Inconsistent performance
2003-09-15 22:18 UTC Christopher Browne <cbbrowne@libertyrms.info>
` Re: Inconsistent performance
2003-09-15 22:24 UTC Joseph Bove <jbove@vetstar.com>
` Re: Inconsistent performance
2003-09-15 22:49 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Inconsistent performance
2003-09-15 23:28 UTC Joseph Bove <jbove@vetstar.com>
` Re: Inconsistent performance
2003-09-16 00:22 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Inconsistent performance
2003-09-16 00:39 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Inconsistent performance
2003-09-16 00:39 UTC Brian Hirt <bhirt@mobygames.com>
` Re: Inconsistent performance
2003-09-16 02:26 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Inconsistent performance
2003-09-16 07:09 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: Inconsistent performance
2003-09-16 08:31 UTC Matt Clark <matt@ymogen.net>
` Re: Inconsistent performance
2003-09-16 15:21 UTC Joseph Bove <jbove@vetstar.com>
` Re: Inconsistent performance
2003-09-16 15:38 UTC Jeff <threshar@torgo.978.org>
[16+ 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