Re: Inner join question - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Inner join question
Date
Msg-id 20040219200405.GA9750@svana.org
Whole thread Raw
In response to Re: Inner join question  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
List pgsql-general
On Thu, Feb 19, 2004 at 01:23:34PM -0500, Randall Skelton wrote:
> The main problem was that there wasn't an index on cal_qat_1.  The
> other indexes were fine so I don't know what happened to the first
> one...

How about an index on cal_quat_2.timestamp?

Hope this helps,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Attachment

pgsql-general by date:

Previous
From: Andrew Rawnsley
Date:
Subject: Re: Replication options
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Replication options