| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Randall Skelton <skelton(at)brutus(dot)uwaterloo(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inner join question |
| Date: | 2004-02-19 20:04:05 |
| Message-ID: | 20040219200405.GA9750@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-02-19 20:06:29 | Re: Replication options |
| Previous Message | Andrew Rawnsley | 2004-02-19 19:43:04 | Re: Replication options |