Re: Inner join question - Mailing list pgsql-general

From Randall Skelton
Subject Re: Inner join question
Date
Msg-id FAA79C8B-6318-11D8-B141-000393C92230@brutus.uwaterloo.ca
Whole thread Raw
In response to Inner join question  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
List pgsql-general
There are indexes on all of the timestamps now.  Originally, the index
for cal_quat_1.timestamp was missing but cal_quat_2.timestamp was
created with the table.

On 19 Feb 2004, at 15:04, Martijn van Oosterhout wrote:

> 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,


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Replication options
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL on Windows