Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: sequence query performance issues
Date
Msg-id 46FD131D.3020901@archonet.com
Whole thread Raw
In response to Re: sequence query performance issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
>> 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).

Looked like an int2 to me (width=2, max value ~ 32k)

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: "Radhika S"
Date:
Subject: Postgres 7.4.2 hanging when vacuum full is run
Next
From: Vivek Khera
Date:
Subject: Re: Postgres 7.4.2 hanging when vacuum full is run