pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTuning 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>
ia64 results with dbt2 and 8.0beta4
2004-11-05 23:13 UTC Mark Wong <markw@osdl.org>
What is the difference between these?
2004-11-05 18:09 UTC Matt Nuzum <matt.followers@gmail.com>
` Re: What is the difference between these?
2004-11-05 19:44 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: What is the difference between these?
2004-11-05 20:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Checking = with timestamp field is slow
2004-11-05 07:16 UTC Antony Paul <antonypaul24@gmail.com>
` Re: Checking = with timestamp field is slow
2004-11-05 08:14 UTC Michael Glaesemann <grzm@myrealbox.com>
` Re: Checking = with timestamp field is slow
2004-11-05 08:32 UTC Michael Glaesemann <grzm@myrealbox.com>
` Re: Checking = with timestamp field is slow
2004-11-05 08:34 UTC Michael Fuhr <mike@fuhr.org>
` Re: Checking = with timestamp field is slow
2004-11-05 08:48 UTC Andrew McMillan <andrew@catalyst.net.nz>
` Re: Checking = with timestamp field is slow
2004-11-05 09:13 UTC Michael Fuhr <mike@fuhr.org>
` Re: Checking = with timestamp field is slow
2004-11-05 12:47 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Checking = with timestamp field is slow
2004-11-05 17:45 UTC Michael Fuhr <mike@fuhr.org>
[8+ messages in thread]
Restricting Postgres
2004-11-02 23:52 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-03 14:17 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Restricting Postgres
2004-11-03 19:21 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Restricting Postgres
2004-11-03 21:25 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-03 23:25 UTC John A Meinel <john@johnmeinel.com>
` Re: Restricting Postgres
2004-11-03 23:35 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 08:29 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 12:19 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Restricting Postgres
2004-11-04 13:10 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 13:17 UTC Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Restricting Postgres
2004-11-04 16:00 UTC Kevin Barnard <kevin.barnard@gmail.com>
` Re: Restricting Postgres
2004-11-04 16:15 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 16:33 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 16:37 UTC Matthew Nuzum <newz@bearfruit.org>
` Re: Restricting Postgres
2004-11-04 16:46 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 17:25 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Restricting Postgres
2004-11-04 17:59 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 18:04 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 18:20 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 20:30 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-04 20:30 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Restricting Postgres
2004-11-04 20:46 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Restricting Postgres
2004-11-04 21:00 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 21:01 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 22:00 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Restricting Postgres
2004-11-04 22:37 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 23:14 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Restricting Postgres
2004-11-04 23:21 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Restricting Postgres
2004-11-04 23:22 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 23:32 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-04 23:35 UTC Matt Clark <matt@ymogen.net>
` Re: Restricting Postgres
2004-11-05 02:49 UTC Martin Foster <martin@ethereal-realms.org>
` Re: Restricting Postgres
2004-11-05 05:16 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Restricting Postgres
2004-11-05 08:48 UTC Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
[34+ messages in thread]
appropriate indexing
2004-11-04 22:32 UTC T E Schmitz <mailreg@numerixtechnology.de>
` Re: appropriate indexing
2004-11-04 22:38 UTC Matt Clark <matt@ymogen.net>
[2+ messages in thread]
index not used if using IN or OR
2004-11-04 07:55 UTC Mario Ivankovits <mario@ops.co.at>
` Re: index not used if using IN or OR
2004-11-04 08:32 UTC Richard Huxton <dev@archonet.com>
` Re: index not used if using IN or OR
2004-11-04 14:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
preloading indexes
2004-11-03 17:30 UTC stuff@opensourceonline.com
` Re: preloading indexes
2004-11-03 17:59 UTC Matt Clark <matt@ymogen.net>
` Re: preloading indexes
2004-11-03 19:12 UTC stuff@opensourceonline.com
` Re: preloading indexes
2004-11-03 19:35 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: preloading indexes
2004-11-03 19:50 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: preloading indexes
2004-11-03 19:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: preloading indexes
2004-11-03 20:19 UTC stuff@opensourceonline.com
` Re: preloading indexes
2004-11-03 20:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: preloading indexes
2004-11-03 20:53 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: preloading indexes
2004-11-03 20:56 UTC stuff@opensourceonline.com
` Re: preloading indexes
2004-11-04 00:50 UTC Mike Benoit <ipso@snappymail.ca>
` Re: preloading indexes
2004-11-04 14:02 UTC Andrew Sullivan <ajs@crankycanuck.ca>
[12+ messages in thread]
Speeding up Gist Index creations
2004-10-31 21:03 UTC mallah@trade-india.com
` Re: Speeding up Gist Index creations
2004-11-01 00:01 UTC Josh Berkus <josh@agliodbs.com>
` Re: Speeding up Gist Index creations
2004-11-02 01:35 UTC Neil Conway <neilc@samurai.com>
` Re: Speeding up Gist Index creations
2004-11-02 05:58 UTC Josh Berkus <josh@agliodbs.com>
[4+ messages in thread]
Performance difference when using views
2004-11-01 21:40 UTC Alvaro Nunes Melo <al_nunes@atua.com.br>
` Re: Performance difference when using views
2004-11-01 22:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance difference when using views
2004-11-01 22:28 UTC Simon Riggs <simon@2ndquadrant.com>
[3+ messages in thread]
ARC Memory Usage analysis
2004-10-22 18:50 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: ARC Memory Usage analysis
2004-10-22 19:35 UTC Jan Wieck <JanWieck@Yahoo.com>
` Re: ARC Memory Usage analysis
2004-10-22 20:09 UTC Kenneth Marshall <ktm@it.is.rice.edu>
` Re: ARC Memory Usage analysis
2004-10-22 20:21 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: ARC Memory Usage analysis
2004-10-22 20:29 UTC Jan Wieck <JanWieck@Yahoo.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-22 20:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-22 22:01 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: ARC Memory Usage analysis
2004-10-25 15:34 UTC Jan Wieck <JanWieck@Yahoo.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 16:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 17:14 UTC Greg Stark <gsstark@mit.edu>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 21:30 UTC Greg Stark <gsstark@mit.edu>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 21:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 22:48 UTC Kenneth Marshall <ktm@it.is.rice.edu>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-25 23:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 05:17 UTC Greg Stark <gsstark@mit.edu>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 05:27 UTC Greg Stark <gsstark@mit.edu>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 05:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 06:04 UTC Curt Sampson <cjs@cynic.net>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 08:49 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 09:50 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 12:18 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-26 15:30 UTC Greg Stark <gsstark@mit.edu>
` Re: [PATCHES] [HACKERS] ARC Memory Usage analysis
2004-10-27 00:09 UTC Thomas F.O'Connell <tfo@sitening.com>
` Re: [PERFORM] [PATCHES] ARC Memory Usage analysis
2004-10-27 00:39 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-27 01:32 UTC Curt Sampson <cjs@cynic.net>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-27 02:30 UTC Scott Marlowe <smarlowe@qwest.net>
` Re: ARC Memory Usage analysis
2004-10-27 21:34 UTC Mark Wong <markw@osdl.org>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-28 03:20 UTC Kevin Brown <kevin@sysexperts.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-30 13:40 UTC Jan Wieck <JanWieck@Yahoo.com>
` Re: [PATCHES] ARC Memory Usage analysis
2004-10-30 16:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PATCHES] [HACKERS] ARC Memory Usage analysis
2004-11-01 01:11 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: [PERFORM] [PATCHES] ARC Memory Usage analysis
2004-11-01 22:03 UTC Simon Riggs <simon@2ndquadrant.com>
[32+ messages in thread]
psql large RSS (1.6GB)
2004-10-27 07:57 UTC TTK Ciar <ttk2@hardpoint.ciar.org>
` Re: psql large RSS (1.6GB)
2004-10-31 06:02 UTC Dustin Sallings <dustin@spy.net>
` Re: psql large RSS (1.6GB)
2004-10-31 10:27 UTC Markus Bertheau <twanger@bluetwanger.de>
` Re: psql large RSS (1.6GB)
2004-11-01 13:45 UTC Gavin Sherry <swm@alcove.com.au>
` Re: psql large RSS (1.6GB)
2004-11-01 14:04 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: psql large RSS (1.6GB)
2004-11-01 16:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: psql large RSS (1.6GB)
2004-11-01 18:49 UTC Josh Berkus <josh@agliodbs.com>
[7+ messages in thread]
shared_buffers and Shared Memory Segments
2004-11-01 17:37 UTC Anjan Dave <adave@vantage.com>
Thanks Chariot Solutions
2004-10-31 18:38 UTC brew@theMode.com
` Re: Thanks Chariot Solutions
2004-11-01 12:59 UTC D'Arcy J.M. Cain <darcy@druid.net>
[2+ messages in thread]
can't handle large number of INSERT/UPDATEs
2004-10-25 20:53 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-25 21:19 UTC Rod Taylor <pg@rbt.ca>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 02:29 UTC Dustin Sallings <dustin@spy.net>
` FW: can't handle large number of INSERT/UPDATEs
2004-10-26 08:19 UTC Rod Dutton <rod@e-rm.co.uk>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 17:42 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 17:48 UTC Rod Taylor <pg@rbt.ca>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 17:56 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 18:27 UTC Josh Berkus <josh@agliodbs.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 18:28 UTC Matt Clark <matt@ymogen.net>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 20:50 UTC Andrew McMillan <andrew@catalyst.net.nz>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 21:13 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 21:15 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 21:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 22:14 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 22:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 22:45 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-26 23:04 UTC Curtis Zinzilieta <curtisz@norchemlab.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 00:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 03:12 UTC Anjan Dave <adave@vantage.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 03:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 04:18 UTC John Meinel <john@johnmeinel.com>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 05:02 UTC Iain <iain@mst.co.jp>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-27 06:09 UTC Matt Clark <matt@ymogen.net>
` Re: can't handle large number of INSERT/UPDATEs
2004-10-30 21:12 UTC Markus Bertheau <twanger@bluetwanger.de>
[24+ 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