Index: doc/src/sgml/indices.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/indices.sgml,v retrieving revision 1.55 diff -u -r1.55 indices.sgml --- doc/src/sgml/indices.sgml 7 Nov 2005 17:36:44 -0000 1.55 +++ doc/src/sgml/indices.sgml 22 Nov 2005 00:30:55 -0000 @@ -525,6 +525,16 @@ feature, but there are several situations in which they are useful. + + + Predicate indexes on bigint () columns will + not be used unless they are casted: + +CREATE INDEX foo ON test_key (id) WHERE id >= 50000::bigint; + + + + One major reason for using a partial index is to avoid indexing common values. Since a query searching for a common value (one that