Re: sequence query performance issues - Mailing list pgsql-performance

From Peter Koczan
Subject Re: sequence query performance issues
Date
Msg-id 4544e0330709281033s5a8c72ccj979f1c02a43188a0@mail.gmail.com
Whole thread Raw
In response to Re: sequence query performance issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: sequence query performance issues
List pgsql-performance
> > Hmm - why is it doing that?
>
> I'm betting that the OP's people.uid column is not an integer.  Existing
> PG releases can't use hashed subplans for cross-data-type comparisons
> (8.3 will be a bit smarter).

*light bulb* Ahhhhhhh, that's it. So, I guess the solution is either
to cast the column or wait for 8.3 (which isn't a problem since the
port won't be done until 8.3 is released anyway).

Thanks again.

Peter

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Postgres 7.4.2 hanging when vacuum full is run
Next
From: Arctic Toucan
Date:
Subject: OOM Errors as a result of table inheritance and a bad plan(?)