| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Roman Fail <rfail(at)posportal(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, <sszabo(at)megazone23(dot)bigpanda(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 7.3.1 New install, large queries are slow |
| Date: | 2003-01-18 07:39:08 |
| Message-ID: | Pine.LNX.4.44.0301180833450.32503-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 16 Jan 2003, Roman Fail wrote:
> It sort of feels like a magic moment. I went back and looked through a
> lot of the JOIN columns and found that I was mixing int4 with int8 in a
> lot of them.
There is note about it in the docs:
http://www.postgresql.org/idocs/index.php?datatype.html#DATATYPE-INT
I don't know if this is in a faq anywhere, but it should be. I myself have
helped a number of persons with this. Every once in a while there come
someone in to the #postgresql irc channel with the exact same problem.
Usually they leave the channel very happy, when their queries take less
then a second instead of minutes.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-01-18 16:24:26 | Re: 7.3.1 New install, large queries are slow |
| Previous Message | Ron Johnson | 2003-01-18 06:55:04 | Re: x86-64 and PostgreSQL |