| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
| Cc: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Very slow query |
| Date: | 2004-05-11 07:42:44 |
| Message-ID: | 20040511084244.A25409@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/05/2004 22:30 Rory Campbell-Lange wrote:
> Sorry for replying to my own post, but I'm anxious for an answer. Should
> I provide other information?
Look carefully at your column types. I can see several smallint columns in
there WHERE clause which are not expicitely typed as such.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Spång Arthursson | 2004-05-11 08:46:59 | ORDER BY 'DK', 'DE', DESC? |
| Previous Message | Stijn Vanroye | 2004-05-11 07:24:46 | Re: Cancel query based on a timeout |