From: John Cavacas <oogly@rogers.com>
To: pgsql-sql@postgresql.org
Subject: Re: query help/sugestions
Date: Sat, 8 Feb 2003 12:27:34 -0500
Message-ID: <001f01c2cf97$5e774000$6401a8c0@spook> (raw)
References: <001501c2cf35$f7584a10$6401a8c0@spook>
<20030208063539.GA20208@cc.usu.edu>
<002a01c2cf44$71948600$6401a8c0@spook>
<20030208163855.GD25254@cc.usu.edu>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oogly@rogers.com
Subject: Re: query help/sugestions
In-Reply-To: <001f01c2cf97$5e774000$6401a8c0@spook>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox