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

Tuning suggestions wanted
  2004-11-10 16:52 UTC  Rod Taylor <rbt@sitesell.com>

Need advice on postgresql.conf settings
  2004-11-09 19:01 UTC  Shane | SkinnyCorp <shanew@skinnycorp.com>
` Re: Need advice on postgresql.conf settings
  2004-11-09 21:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Need advice on postgresql.conf settings
  2004-11-09 22:44 UTC  Sean Chittenden <sean@chittenden.org>
` Re: Need advice on postgresql.conf settings
  2004-11-10 13:04 UTC  Jeff <threshar@torgo.978.org>
  [4+ messages in thread]

simple select-statement takes more than 25 sec
  2004-11-10 09:35 UTC  Cao Duy <cao.duy@1und1.com>
` Re: simple select-statement takes more than 25 sec
  2004-11-10 10:17 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: simple select-statement takes more than 25 sec
  2004-11-10 10:31 UTC  gnari <gnari@simnet.is>
` Re: simple select-statement takes more than 25 sec
  2004-11-10 11:22 UTC  Cao Duy <cao.duy@1und1.com>
` Re: simple select-statement takes more than 25 sec
  2004-11-10 11:45 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [5+ messages in thread]

poor performance in migrated database
  2004-11-06 19:52 UTC  Carlos Lopez <chlopezl@yahoo.com>
` Re: poor performance in migrated database
  2004-11-06 20:07 UTC  Troels Arvin <troels@arvin.dk>
` Re: poor performance in migrated database
  2004-11-06 20:26 UTC  Troels Arvin <troels@arvin.dk>
` Re: [PERFORM] poor performance in migrated database
  2004-11-06 21:39 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] poor performance in migrated database
  2004-11-06 23:00 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: [PERFORM] poor performance in migrated database
  2004-11-08 21:28 UTC  Carlos Lopez <chlopezl@yahoo.com>
` Re: [PERFORM] poor performance in migrated database
  2004-11-08 23:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] poor performance in migrated database
  2004-11-09 14:56 UTC  Carlos Lopez <chlopezl@yahoo.com>
  [8+ messages in thread]

Question regarding the file system
  2004-11-05 21:00 UTC  Gabriele Bartolini <angusgb@tin.it>
` Re: Question regarding the file system
  2004-11-08 17:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Question regarding the file system
  2004-11-09 01:31 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Slow performance with Group By
  2004-11-09 00:09 UTC  Erik Norvelle <signups@norvelle.org>
` Re: Slow performance with Group By
  2004-11-09 00:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

ext3 journalling type
  2004-11-08 12:26 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: ext3 journalling type
  2004-11-08 14:04 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: ext3 journalling type
  2004-11-08 15:14 UTC  Matt Clark <matt@ymogen.net>
` Re: ext3 journalling type
  2004-11-08 16:29 UTC  Mark Wong <markw@osdl.org>
` Re: ext3 journalling type
  2004-11-08 17:38 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

postgresql amd-64
  2004-11-05 15:33 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: postgresql amd-64
  2004-11-05 18:23 UTC  Daniel Ceregatti <daniel@omnis.com>
` Re: postgresql amd-64
  2004-11-05 21:17 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: postgresql amd-64
  2004-11-06 03:01 UTC  Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
` Re: postgresql amd-64
  2004-11-08 02:13 UTC  Iain <iain@mst.co.jp>
` Re: postgresql amd-64
  2004-11-08 07:36 UTC  Iain <iain@mst.co.jp>
` Re: postgresql amd-64
  2004-11-08 11:40 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: postgresql amd-64
  2004-11-08 13:20 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [8+ messages in thread]

Postgresql is using seqscan when is should use indexes.
  2004-11-08 10:40 UTC  Andreas Åkre Solberg <Andreas.Solberg@uninett.no>
` Re: Postgresql is using seqscan when is should use indexes.
  2004-11-08 12:04 UTC  Russell Smith <mr-russ@pws.com.au>
  [2+ messages in thread]

Better Hardware, worst Results
  2004-11-04 21:06 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>
` Re: Better Hardware, worst Results
  2004-11-04 21:16 UTC  Rod Taylor <pg@rbt.ca>
` Re: Better Hardware, worst Results
  2004-11-04 21:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Better Hardware, worst Results
  2004-11-04 22:42 UTC  al_nunes@atua.com.br
` Re: Better Hardware, worst Results
  2004-11-04 22:58 UTC  Rod Taylor <pg@rbt.ca>
` Re: Better Hardware, worst Results
  2004-11-04 22:58 UTC  Matt Clark <matt@ymogen.net>
` Re: Better Hardware, worst Results
  2004-11-04 23:08 UTC  Matt Clark <matt@ymogen.net>
` Re: Better Hardware, worst Results
  2004-11-08 11:46 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>
  [8+ messages in thread]

DISTINCT and GROUP BY: possible performance enhancement?
  2004-11-07 11:04 UTC  Ang Chin Han <ang.chin.han@gmail.com>


[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