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: Pine.LNX.4.33.0109071223060.4378-100000@c70051-a.aurora1.co.home.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group