That's what I did and got 8.1.2 ... do you want gcc version etc 3.3.2 powerpc aix5.2 Tim Jones Healthcare Project Manager Optio Software, Inc. (770) 576-3555 -----Original Message----- From: Matthew O'Connor [mailto:matthew@xxxxxxxx] Sent: Wednesday, December 13, 2006 5:51 PM To: Tim Jones Subject: Re: [PERFORM] strange query behavior From psql perform: select version(); and send us that output. Tim Jones wrote: > Looks like 8.1.2 > > Tim Jones > Healthcare Project Manager > Optio Software, Inc. > (770) 576-3555 > > -----Original Message----- > From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] > Sent: Wednesday, December 13, 2006 5:37 PM > To: Tim Jones > Cc: pgsql-performance@xxxxxxxxxxxxxx > Subject: Re: [PERFORM] strange query behavior > > "Tim Jones" <TJones@xxxxxxxxx> writes: >>> Which PG version is this exactly? Are you running with any >>> nondefault planner parameters? > >> Version 8.1 > > 8.1.what? > >> Here are the planner constraints I believe we changed >> effective_cache_size and random_page_cost > > Those look reasonably harmless. > > My best bet at the moment is that you've got a pretty early 8.1.x > release and are hitting one of the planner bugs that we fixed earlier > this year. Not enough info to say for sure though. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
