Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: sequence query performance issues
Date
Msg-id 886.1190988979@sss.pgh.pa.us
Whole thread Raw
In response to Re: sequence query performance issues  (Richard Huxton <dev@archonet.com>)
Responses Re: sequence query performance issues  (Richard Huxton <dev@archonet.com>)
Re: sequence query performance issues  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-performance
Tree view 
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).

            regards, tom lane

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Tuning for warm standby
Next
From: "Radhika S"
Date:
Subject: Postgres 7.4.2 hanging when vacuum full is run