Re: help with query speed - Mailing list pgsql-general

From scott.marlowe
Subject Re: help with query speed
Date
Msg-id Pine.LNX.4.33.0402121700000.6465-100000@css120.ihs.com
Whole thread Raw
In response to Re: help with query speed  ("Jason Tesser" <JTesser@nbbc.edu>)
List pgsql-general
On Thu, 12 Feb 2004, Jason Tesser wrote:

> <big snip>
> > You didn't answer my question about whether they are the same types.
> Are
> > they?
>
> Yes but testclass is a view.  But the field it is referencing is of the
> same type.

OK, assuming they're the same types, what does

explain analyze <query>

have to say?


pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Join 2 aggregate queries?
Next
From: Bruno Wolff III
Date:
Subject: Re: Join 2 aggregate queries?