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 DD256537D1 for ; Tue, 12 Apr 2005 11:46:06 -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 17576-08 for ; Tue, 12 Apr 2005 14:46:02 +0000 (GMT) Received: from viper.eo.pl (viper.eo.pl [217.17.46.133]) by svr1.postgresql.org (Postfix) with ESMTP id 37C0A53789 for ; Tue, 12 Apr 2005 11:45:58 -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 1DLMeM-0006o5-Gj; Tue, 12 Apr 2005 16:46:01 +0200 Received: from depesz by localhost.localdomain with local (Exim 4.50) id 1DLMeL-0003V5-7j; Tue, 12 Apr 2005 16:45:57 +0200 Date: Tue, 12 Apr 2005 16:45:57 +0200 From: hubert lubaczewski To: Alex Turner Cc: pgsql-performance@postgresql.org Subject: Re: profiling postgresql queries? Message-ID: <20050412144557.GA13383@eo.pl> Reply-To: hubert.lubaczewski@eo.pl References: <20050412104643.GB11445@eo.pl> <15425.1113315053@sss.pgh.pa.us> <33c6269f05041207182473d08b@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="jI8keyz6grp/JLjh" Content-Disposition: inline In-Reply-To: <33c6269f05041207182473d08b@mail.gmail.com> 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/230 X-Sequence-Number: 11627 --jI8keyz6grp/JLjh Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Apr 12, 2005 at 10:18:31AM -0400, Alex Turner wrote: > Speaking of triggers... > Is there any plan to speed up plpgsql tiggers? Fairly simple > crosstable insert triggers seem to slow my inserts to a crawl. plpgsql is quite fast actually. if some triggers slow inserts too much, i guess you should be able to spped them up with some performance review of trigger code. depesz --=20 hubert lubaczewski Network Operations Center eo Networks Sp. z o.o. --jI8keyz6grp/JLjh 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) iD8DBQFCW98l5ZmPxbV4/n4RAmrCAJ9Pdrs64MJIx7YzrpBIWx9KBSu2iACfVkzv yxMENNVYXHS0gSb/6xl9swk= =JHBb -----END PGP SIGNATURE----- --jI8keyz6grp/JLjh--