Re: Bug #441: Index using INT8 data type is ignored

From: grant <grant(at)amadensor(dot)com>
To: <mauro-flores(at)procergs(dot)rs(dot)gov(dot)br>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #441: Index using INT8 data type is ignored
Date: 2001-09-07 19:24:45
Message-ID: Pine.LNX.4.33.0109071223060.4378-100000@c70051-a.aurora1.co.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2 questions:
1) Have you recently run an analyze?
2) Are you sure that an index scan would be more efficient than a seq
scan? (are less than 25% of the records selected) I don't know the
break-off boint in the query optimizer, but it may be more efficient on
that table to read the whole thing.

______________________________________________________________________________

Your mouse has moved.
You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-09-07 20:58:16 Re: Conditional NOTIFY is not implemented
Previous Message Bruce Momjian 2001-09-07 17:11:23 Re: [BUGS] pgsql/src/backend/utils/mb encnames.c