| From: | Randall Skelton <skelton(at)brutus(dot)uwaterloo(dot)ca> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Subject: | Re: Inner join question |
| Date: | 2004-02-19 20:19:13 |
| Message-ID: | FAA79C8B-6318-11D8-B141-000393C92230@brutus.uwaterloo.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-02-19 20:29:56 | Re: PostgreSQL on Windows |
| Previous Message | Joshua D. Drake | 2004-02-19 20:06:29 | Re: Replication options |