From c6fbe6d6fb828f50b9d67627588eb5ab8bd25e47 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Tue, 21 Jul 2015 20:54:18 +0300 Subject: Add selectivity estimation functions for intarray operators. Uriy Zhuravlev and Alexander Korotkov, reviewed by Jeff Janes, some cleanup by me. --- contrib/intarray/sql/_int.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'contrib/intarray/sql/_int.sql') diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index 216c5c58d61..f6fe2de55c5 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -68,8 +68,8 @@ SELECT '1&(2&(4&(5|!6)))'::query_int; CREATE TABLE test__int( a int[] ); - \copy test__int from 'data/test__int.data' +ANALYZE test__int; SELECT count(*) from test__int WHERE a && '{23,50}'; SELECT count(*) from test__int WHERE a @@ '23|50'; -- cgit v1.2.3