Re: The type int8 and the use of indexes

From: "Igor V(dot) Rafienko" <igorr(at)ifi(dot)uio(dot)no>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The type int8 and the use of indexes
Date: 2001-01-26 15:22:36
Message-ID: Pine.SOL.4.21.0101261621550.16405-100000@andvarefoss.ifi.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

on Jan 26, 2001, 10:20, Tom Lane std::cout'ed:

| It won't use an index unless the optimizer knows that the number of
| rows to be selected is small, which for a one-sided "<" query would
| depend on where the endpoints of the data range are. Had you done
| a VACUUM ANALYZE recently?

Yes, I believe I did run vacuum analyze just before the test.

ivr
--
"You have an internet connection on your calculator."
"You can type 70 words per minute -- on a TI-82."
"You've gotten electronic copies of text books in TI-82 format."
-- Technology in IB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 2001-01-26 15:29:59 Re: beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]
Previous Message Tom Lane 2001-01-26 15:20:17 Re: The type int8 and the use of indexes