X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 703D58B9B86 for ; Mon, 31 Jan 2005 15:15:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81416-08 for ; Mon, 31 Jan 2005 15:14:59 +0000 (GMT) Received: from mail.logi-track.com (burro.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id 6C6B18B9BE3 for ; Mon, 31 Jan 2005 14:54:19 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J0f7b.j.pppool.de [85.74.15.123]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id 9E126303D4; Mon, 31 Jan 2005 15:54:21 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 0B14FAB3D2; Mon, 31 Jan 2005 15:54:14 +0100 (CET) Message-ID: <41FE4692.6080104@logi-track.com> Date: Mon, 31 Jan 2005 15:54:10 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20041218) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: PostgreSQL Performance List Subject: Re: Automagic tuning References: <20040727151531.4f60b5b0@kingfisher.intern.logi-track.com> <41066485.7080502@familyhealth.com.au> In-Reply-To: <41066485.7080502@familyhealth.com.au> X-Enigmail-Version: 0.89.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigF1B13BB5E45DE17BEE30DF02" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/628 X-Sequence-Number: 10318 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigF1B13BB5E45DE17BEE30DF02 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hi, Cristopher, Christopher Kings-Lynne schrieb: >> Are there any tools that help with postgres/postgis performance tuning? >> >> So they measure the acutal tuple costs and cpu power, or suggest optimal >> values for the index sample counts? > > Have you turned on the stat_* settings in postgresql.conf and then > examined the pg_stat_* system views? As far as I examined, those views only count several things like fetched rows and pages, and cache hits. I would like something that really measures values like random_page_cost or cpu_tuple_cost that are hardware dependent. I assume such thing does not exist? Markus -- markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 zürich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com --------------enigF1B13BB5E45DE17BEE30DF02 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB/kaTOVWsnapT9i0RAgvVAJ4gtEETn89bOZyix6DBSk9ZM1kI9ACghU2n BtGZLksqRxiubzDl2FpAIrs= =7RIX -----END PGP SIGNATURE----- --------------enigF1B13BB5E45DE17BEE30DF02--