X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 7DB96925A01 for ; Sun, 1 Jun 2003 00:09:47 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 00783-04 for ; Sun, 1 Jun 2003 00:09:36 -0400 (EDT) Received: from simmts4-srv.bellnexxia.net (simmts4.bellnexxia.net [206.47.199.13]) by developer.postgresql.org (Postfix) with ESMTP id D1FF692592B for ; Sun, 1 Jun 2003 00:06:41 -0400 (EDT) Received: from [192.168.1.200] ([64.231.215.231]) by simmts4-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030601040630.WKIH20459.simmts4-srv.bellnexxia.net@[192.168.1.200]>; Sun, 1 Jun 2003 00:06:30 -0400 Subject: Re: are views typically any faster/slower than equivilent joins? From: Rod Taylor To: Brian Tarbox Cc: Postgresql Performance In-Reply-To: <001801c327e9$3c01a5b0$01000001@trouble> References: <001801c327e9$3c01a5b0$01000001@trouble> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-kojaQBjoR6414uAp8E7B" Organization: Message-Id: <1054440355.11968.90.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 01 Jun 2003 00:05:56 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/1 X-Sequence-Number: 2085 --=-kojaQBjoR6414uAp8E7B Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > Would my query performance be significantly faster/slower using a View as > opposed to a prepared query using join? I missed this part. Views and prepared queries are not the same time.=20 Use of a view still needs to be optimized. Prepared queries will run the optimization portion on the entire query including the view segments of it. Think of a view as a MACRO.=20 Depending on the context of what surrounds it, the view may be executed very differently. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-kojaQBjoR6414uAp8E7B Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+2Xuj6DETLow6vwwRAgXBAJ9X9ge3noEA2lwqP+kKoBca4K3ZZwCghT9A SpEiUs+oCK/rqGzqxXcufBk= =+VOH -----END PGP SIGNATURE----- --=-kojaQBjoR6414uAp8E7B--