X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3A6B8475425
	for <pgsql-sql@postgresql.org>; Sat,  8 Feb 2003 12:27:46 -0500 (EST)
Received: from fep04-mail.bloor.is.net.cable.rogers.com
	(fep04-mail.bloor.is.net.cable.rogers.com [66.185.86.74])
	by postgresql.org (Postfix) with ESMTP id 7BCCE4753A1
	for <pgsql-sql@postgresql.org>; Sat,  8 Feb 2003 12:27:45 -0500 (EST)
Received: from spook ([65.48.10.226])
	by fep04-mail.bloor.is.net.cable.rogers.com
	(InterMail vM.5.01.05.06 201-253-122-126-106-20020509) with ESMTP id
	<20030208172743.SQLV120822.fep04-mail.bloor.is.net.cable.rogers.com@spook>
	for <pgsql-sql@postgresql.org>; Sat, 8 Feb 2003 12:27:43 -0500
Message-ID: <001f01c2cf97$5e774000$6401a8c0@spook>
From: "John Cavacas" <oogly@rogers.com>
To: <pgsql-sql@postgresql.org>
References: <001501c2cf35$f7584a10$6401a8c0@spook>
	<20030208063539.GA20208@cc.usu.edu>
	<002a01c2cf44$71948600$6401a8c0@spook>
	<20030208163855.GD25254@cc.usu.edu>
Subject: Re: query help/sugestions
Date: Sat, 8 Feb 2003 12:27:34 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Authentication-Info: Submitted using SMTP AUTH LOGIN at
	fep04-mail.bloor.is.net.cable.rogers.com from [65.48.10.226]
	using ID <oogly@rogers.com> at Sat, 8 Feb 2003 12:27:43 -0500
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/172
X-Sequence-Number: 11570

> Have you run the query above under EXPLAIN to see what kind of
execution
> plan you're getting?
>
> > Is creating the view a good idea in terms of performance? This is a
> > general query, I would for example not include the main body of the
text
> > needed for the front page listing.
>
> The performance will be as good as your underlying query is. The VIEW
is
> just an "alias" if you will, and they are generally a good idea.

I just started using PostgreSQL recently, and as such I am not sure how
to properlly evaluate the results of EXPLAIN on that query. I started
looking at the documentation last night regarding EXPLAIN but I haven't
gotten my head around it. Any sugestions in that area?

Thanks again,
John