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