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 6CEF8534F4 for ; Tue, 12 Apr 2005 12:00:34 -0300 (ADT) 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 24467-01 for ; Tue, 12 Apr 2005 15:00:29 +0000 (GMT) Received: from viper.eo.pl (viper.eo.pl [217.17.46.133]) by svr1.postgresql.org (Postfix) with ESMTP id A749A53498 for ; Tue, 12 Apr 2005 12:00:29 -0300 (ADT) Received: from xxx.hq.eo.pl ([192.168.20.129] helo=localhost.localdomain) by viper with asmtp (TLS-1.0:RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1DLMsH-0000Hw-8o; Tue, 12 Apr 2005 17:00:27 +0200 Received: from depesz by localhost.localdomain with local (Exim 4.50) id 1DLMsF-0004i6-Ph; Tue, 12 Apr 2005 17:00:19 +0200 Date: Tue, 12 Apr 2005 17:00:19 +0200 From: hubert lubaczewski To: Michael Fuhr Cc: pgsql-performance@postgresql.org Subject: Re: profiling postgresql queries? Message-ID: <20050412150019.GA13480@eo.pl> Reply-To: hubert.lubaczewski@eo.pl References: <20050412104643.GB11445@eo.pl> <20050412144359.GA88387@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="cWoXeonUoKmBZSoM" Content-Disposition: inline In-Reply-To: <20050412144359.GA88387@winnie.fuhr.org> X-info-en-1: this message *may* reflect my personal opinion. it is *not* X-info-en-2: intended to reflect those of my employer, or anyone else. X-info-pl-1: wszelkie opinie =?iso-8859-2?Q?wyra=BFone_?= =?iso-8859-2?Q?w_tym_li=B6cie_prezentuj=B1_wy=B3=B1cznie_pogl=B1dy?= X-info-pl-2: autora listu. opinie =?iso-8859-2?Q?te_?= =?iso-8859-2?Q?w_=BFadnym__razie_nie__wyra=BFaj=B1__pogl=B1d=F3w?= X-info-pl-3: pracodawcy autora =?iso-8859-2?Q?listu_?= =?iso-8859-2?Q?_ani__innych__zwi=B1zanych__z__nim__os=F3b=2E?= User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/231 X-Sequence-Number: 11628 --cWoXeonUoKmBZSoM Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Apr 12, 2005 at 08:43:59AM -0600, Michael Fuhr wrote: > 8.1devel changes frequently (sometimes requiring initdb) and isn't > suitable for production, but if the trigger statistics would be > helpful then you could set up a test server and load a copy of your > database into it. Just beware that because it's bleeding edge, it > might destroy your data and it might behave differently than released > versions. great. this is exactly what i need. thanks for hint. depesz --=20 hubert lubaczewski Network Operations Center eo Networks Sp. z o.o. --cWoXeonUoKmBZSoM Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFCW+KD5ZmPxbV4/n4RAlsMAKCF66ayWe3eDHyepJLPJIzR8kfipwCeLfhM 43choUUXgPrdjQMdiUUrh/M= =7ny5 -----END PGP SIGNATURE----- --cWoXeonUoKmBZSoM--