pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
tablespace + RAM disk?
  2004-11-19 22:32 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 00:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tablespace + RAM disk?
  2004-11-20 01:34 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 04:18 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 09:36 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: tablespace + RAM disk?
  2004-11-20 19:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tablespace + RAM disk?
  2004-11-21 14:48 UTC  Neil Conway <neilc@samurai.com>
  [7+ messages in thread]

index use
  2004-11-19 19:18 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: index use
  2004-11-19 20:00 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: index use
  2004-11-19 20:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index use
  2004-11-19 20:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: index use
  2004-11-19 20:29 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: index use
  2004-11-19 20:39 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: index use
  2004-11-20 19:40 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

When to bump up statistics?
  2004-11-19 13:59 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: When to bump up statistics?
  2004-11-19 20:23 UTC  Chris Browne <cbbrowne@acm.org>
` Re: When to bump up statistics?
  2004-11-19 20:32 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Interaction between Free Space Map an alternate location for a database
  2004-11-18 17:09 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 18:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 18:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Interaction between Free Space Map an alternate location
  2004-11-18 18:42 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Interaction between Free Space Map an alternate location
  2004-11-18 19:46 UTC  Dave Cramer <pg@fastcrypt.com>
  [5+ messages in thread]

Timing of pgstats updates
  2004-11-18 16:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Timing of pgstats updates
  2004-11-18 19:29 UTC  Jan Wieck <JanWieck@Yahoo.com>
  [2+ messages in thread]

query plan question
  2004-11-17 03:54 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 04:35 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: query plan question
  2004-11-17 06:40 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: query plan question
  2004-11-17 12:32 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 13:08 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 14:00 UTC  Jeff <threshar@torgo.978.org>
` Re: query plan question
  2004-11-17 14:43 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 15:06 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 15:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query plan question
  2004-11-17 15:59 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 16:41 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: query plan question
  2004-11-17 19:01 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: query plan question
  2004-11-18 16:12 UTC  David Parker <dparker@tazznetworks.com>
  [13+ messages in thread]

Tsearch2 really slower than ilike ?
  2004-11-16 14:55 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 15:32 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 15:48 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:04 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:06 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:17 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:21 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:27 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 21:13 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-17 17:16 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-17 17:23 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 09:27 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 09:37 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:30 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:34 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:53 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
  [16+ messages in thread]

postgres eating CPU
  2004-11-17 22:13 UTC  silviapg@tiscali.it <silviapg@tiscali.it>
` Re: postgres eating CPU
  2004-11-17 22:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgres eating CPU
  2004-11-17 22:51 UTC  silviapg@tiscali.it <silviapg@tiscali.it>
` Re: postgres eating CPU
  2004-11-17 23:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgres eating CPU
  2004-11-17 23:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgres eating CPU
  2004-11-18 03:30 UTC  Joshua D. Drake <jd@commandprompt.com>
  [6+ messages in thread]

Re: Analyzer is clueless
  2004-11-17 19:14 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Analyzer is clueless
  2004-11-17 21:02 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Analyzer is clueless
  2004-11-17 22:32 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Analyzer is clueless
  2004-11-18 00:20 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: Analyzer is clueless
  2004-11-18 01:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Analyzer is clueless
  2004-11-18 01:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Analyzer is clueless
  2004-11-18 02:08 UTC  David Brown <time@bigpond.net.au>
  [7+ messages in thread]

mis-estimation on data-warehouse aggregate creation
  2004-11-16 09:10 UTC  Kris Jurka <books@ejurka.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 10:55 UTC  F. Senault <fred.letter@lacave.net>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 19:49 UTC  Kris Jurka <books@ejurka.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 21:29 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-17 08:19 UTC  Kris Jurka <books@ejurka.com>
  [5+ messages in thread]

nuderstanding 'explain analyse'
  2004-11-16 21:11 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: nuderstanding 'explain analyse'
  2004-11-17 06:07 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Table Partitions: To Inherit Or Not To Inherit
  2004-11-17 05:31 UTC  Don Drake <dondrake@gmail.com>
` Re: Table Partitions: To Inherit Or Not To Inherit
  2004-11-17 05:51 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Insertion puzzles
  2004-11-13 11:26 UTC  vivek singh <sing_vivek@yahoo.com>
` Re: Insertion puzzles
  2004-11-13 13:31 UTC  Andreas Åkre Solberg <Andreas.Solberg@uninett.no>
` Re: Insertion puzzles
  2004-11-13 16:54 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Insertion puzzles
  2004-11-13 17:13 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Insertion puzzles
  2004-11-14 01:36 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Insertion puzzles
  2004-11-14 02:00 UTC  dentfirst13@earthlink.net <dentfirst13@earthlink.net>
` Re: Insertion puzzles
  2004-11-15 00:45 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Insertion puzzles
  2004-11-16 19:43 UTC  J. Andrew Rogers <jrogers@neopolitan.com>
  [8+ messages in thread]

Efficient way to remove OID data
  2004-11-16 15:57 UTC  James Gunzelman <JamesGunzelman@solutionary.com>

Performance difference: SELECT from VIEW or not?
  2004-11-15 23:10 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Performance difference: SELECT from VIEW or not?
  2004-11-15 23:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Strange (?) Index behavior?
  2004-11-05 14:39 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 15:06 UTC  Matt Clark <matt@ymogen.net>
` Re: Strange (?) Index behavior?
  2004-11-05 15:07 UTC  Rod Taylor <pg@rbt.ca>
` Re: Strange (?) Index behavior?
  2004-11-05 15:32 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 16:54 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 17:51 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Strange (?) Index behavior?
  2004-11-05 17:56 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 18:34 UTC  Matt Clark <matt@ymogen.net>
` Re: Strange (?) Index behavior?
  2004-11-05 19:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange (?) Index behavior?
  2004-11-05 20:36 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 21:02 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-05 21:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange (?) Index behavior?
  2004-11-05 22:40 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-06 00:14 UTC  Matt Clark <matt@ymogen.net>
` Re: Strange (?) Index behavior?
  2004-11-06 04:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange (?) Index behavior?
  2004-11-06 07:27 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-11 16:21 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-11 18:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Strange (?) Index behavior?
  2004-11-11 19:30 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-11 20:49 UTC  Greg Stark <gsstark@mit.edu>
` Re: Strange (?) Index behavior?
  2004-11-11 21:12 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-11 21:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange (?) Index behavior?
  2004-11-11 21:48 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Strange (?) Index behavior?
  2004-11-12 20:12 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-12 22:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange (?) Index behavior?
  2004-11-13 00:26 UTC  Allen Landsidel <alandsidel@gmail.com>
` Re: Strange (?) Index behavior?
  2004-11-15 22:22 UTC  Allen Landsidel <alandsidel@gmail.com>
  [27+ messages in thread]

Why distinct so slow ?
  2004-11-15 21:22 UTC  Hervé Piedvache <footcow@noos.fr>

Question on pgsql optimisation of SQL and structure (index, etc)
  2004-11-15 17:48 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Question on pgsql optimisation of SQL and structure (index, etc)
  2004-11-15 21:03 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Large Database Performance suggestions
  2004-10-22 03:14 UTC  Joshua Marsh <icub3d@gmail.com>
` Re: Large Database Performance suggestions
  2004-10-22 03:29 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: Large Database Performance suggestions
  2004-10-22 03:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large Database Performance suggestions
  2004-10-22 05:03 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Large Database Performance suggestions
  2004-10-22 11:38 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Large Database Performance suggestions
  2004-10-26 15:24 UTC  Joshua Marsh <icub3d@gmail.com>
` Re: Large Database Performance suggestions
  2004-10-26 16:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large Database Performance suggestions
  2004-11-15 15:22 UTC  Andrew Hammond <ahammond@ca.afilias.info>
  [8+ messages in thread]

Clarification on two bits on VACUUM FULL VERBOSE output
  2004-11-12 18:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Clarification on two bits on VACUUM FULL VERBOSE output
  2004-11-12 19:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Clarification on two bits on VACUUM FULL VERBOSE output
  2004-11-12 21:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Clarification on two bits on VACUUM FULL VERBOSE output
  2004-11-12 21:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

How to speed-up inserts with jdbc
  2004-11-10 13:51 UTC  Michael Kleiser <mkl@webde-ag.de>
` Re: How to speed-up inserts with jdbc
  2004-11-10 13:55 UTC  Jeff <threshar@torgo.978.org>
` Re: How to speed-up inserts with jdbc
  2004-11-10 14:05 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: How to speed-up inserts with jdbc
  2004-11-10 14:26 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: How to speed-up inserts with jdbc
  2004-11-11 08:04 UTC  Edwin Eyan Moragas <haaktu@gmail.com>
` Re: How to speed-up inserts with jdbc
  2004-11-11 10:04 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: How to speed-up inserts with jdbc
  2004-11-11 21:10 UTC  Edwin Eyan Moragas <haaktu@gmail.com>
  [7+ messages in thread]

vacuum analyze slows sql query
  2004-11-03 18:56 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-03 19:17 UTC  Doug Y <dylists@ptd.net>
` Re: vacuum analyze slows sql query
  2004-11-03 20:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuum analyze slows sql query
  2004-11-03 22:22 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-05 18:26 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-06 00:26 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-06 04:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuum analyze slows sql query
  2004-11-06 06:18 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-06 06:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuum analyze slows sql query
  2004-11-08 18:57 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-08 19:29 UTC  John Meinel <john@johnmeinel.com>
` Re: vacuum analyze slows sql query
  2004-11-08 23:19 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-09 00:01 UTC  John Meinel <john@johnmeinel.com>
` Re: vacuum analyze slows sql query
  2004-11-09 00:04 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: vacuum analyze slows sql query
  2004-11-09 00:31 UTC  John Meinel <john@johnmeinel.com>
` Re: vacuum analyze slows sql query
  2004-11-09 19:26 UTC  patrick ~ <sidsrr@yahoo.com>
` Re: vacuum analyze slows sql query
  2004-11-11 08:03 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [17+ messages in thread]

seqscan strikes again
  2004-11-09 22:23 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: seqscan strikes again
  2004-11-09 23:14 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: seqscan strikes again
  2004-11-09 23:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: seqscan strikes again
  2004-11-10 17:00 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: seqscan strikes again
  2004-11-11 07:58 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [5+ messages in thread]

int4 in a GiST index
  2004-11-10 21:51 UTC  Mike Rylander <mrylander@gmail.com>
` Re: int4 in a GiST index
  2004-11-11 02:50 UTC  George Essig <george_essig@yahoo.com>
` Re: int4 in a GiST index
  2004-11-11 05:53 UTC  Mike Rylander <mrylander@gmail.com>
  [3+ messages in thread]

Solaris 9 Tuning Tips requested
  2004-11-10 17:04 UTC  Rod Taylor <pg@rbt.ca>


[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