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