Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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.

print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

In response to

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group