Re: Bug #441: Index using INT8 data type is ignored - Mailing list pgsql-bugs

From grant
Subject Re: Bug #441: Index using INT8 data type is ignored
Date
Msg-id Pine.LNX.4.33.0109071223060.4378-100000@c70051-a.aurora1.co.home.com
Whole thread Raw
In response to Bug #441: Index using INT8 data type is ignored  (pgsql-bugs@postgresql.org)
List 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);

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #441: Index using INT8 data type is ignored
Next
From: Tom Lane
Date:
Subject: Re: Conditional NOTIFY is not implemented