Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: sequence query performance issues
- From: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
- To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: sequence query performance issues
- Date: Fri, 28 Sep 2007 12:33:35 -0500
> > 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
- References:
- sequence query performance issues
- From: Peter Koczan
- Re: sequence query performance issues
- From: Richard Huxton
- Re: sequence query performance issues
- From: Tom Lane
- sequence query performance issues
- Prev by Date: Re: Postgres 7.4.2 hanging when vacuum full is run
- Next by Date: OOM Errors as a result of table inheritance and a bad plan(?)
- Previous by thread: Re: sequence query performance issues
- Next by thread: Postgres 7.4.2 hanging when vacuum full is run
- Indexes: