Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer failure on integer column? - Mailing list pgsql-general

From Tom Lane
Subject Re: Optimizer failure on integer column?
Date
Msg-id 7931.1054955762@sss.pgh.pa.us
Whole thread Raw
In response to Optimizer failure on integer column?  (nolan@celery.tssi.com)
Responses Re: Optimizer failure on integer column?  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
Tree view 
nolan@celery.tssi.com writes:
> Is there a documented problem with optimizing integer key fields
> in 7.3.3?

No.  How about providing some more details, like EXPLAIN ANALYZE
output?  The given query plan looks reasonable if the planner's
estimates are right ... but since you're complaining, I'd imagine
they are not.  (Also, I assume you've done an ANALYZE lately?)

            regards, tom lane

pgsql-general by date:

Previous
From: "Vincent Hikida"
Date:
Subject: Re: timestamp
Next
From: Stephan Szabo
Date:
Subject: Re: Create Foriegn Key