Re: Optimizer failure on integer column?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nolan(at)celery(dot)tssi(dot)com
Cc: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Re: Optimizer failure on integer column?
Date: 2003-06-07 03:16:02
Message-ID: 7931.1054955762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

nolan(at)celery(dot)tssi(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Hikida 2003-06-07 03:34:37 Re: timestamp
Previous Message Stephan Szabo 2003-06-07 03:15:02 Re: Create Foriegn Key