On Sat, May 31, 2003 at 01:45:50PM -0400, Brian Tarbox wrote:
> The primary key field is an integer and I have performed vacuum analyse but
> that does not seem to change anything.
int4? int8? int2? Makes a difference. Please post the results of
EXPLAIN ANALYSE on the query you're having trouble with, and someone
may be able to help you. (You'll need to show us the table, too.)
> I've also heard that postgres will not indexes when JOINing tables. Can
> that really be true??
No.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110