Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBICwkm78346 for ; Tue, 18 Dec 2001 07:58:46 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD90557FE.dip.t-dialin.net [217.5.87.254]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fBID0ow13497; Tue, 18 Dec 2001 14:00:50 +0100 Subject: Re: Performance problem, what to do? From: Markus Bertheau To: Archibald Zimonyi Cc: postgres sql list In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Ygx7NxYo7zkhR0CgpFA1" X-Mailer: Evolution/1.0 (Preview Release) Date: 18 Dec 2001 13:58:37 +0100 Message-Id: <1008680318.1659.10.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200112/197 X-Sequence-Number: 6020 --=-Ygx7NxYo7zkhR0CgpFA1 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2001-12-18 at 13:34, Archibald Zimonyi wrote: > How come my query takes almost a minute execute? Could you post your table structure and the query for the explain? Markus Bertheau --=-Ygx7NxYo7zkhR0CgpFA1 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA8Hz19KNEjAb345r4RAiOzAJwNNC8V3uMs94THtIWg1Fl2qzVObgCfVlRD 12dAB8W1TkEZXu2M2AVAQds= =eGC6 -----END PGP SIGNATURE----- --=-Ygx7NxYo7zkhR0CgpFA1--