diff options
| author | Tom Lane | 2001-08-21 16:36:06 +0000 |
|---|---|---|
| committer | Tom Lane | 2001-08-21 16:36:06 +0000 |
| commit | f933766ba7c5446a28d714904ae0c46d8b21b86a (patch) | |
| tree | 81c8ecd2a2f8161d91670f5325331ba1704c2ab7 /contrib/intarray/expected | |
| parent | c2d156691292d7be998eacf5b99dce3ea3c29ab2 (diff) | |
Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in
pgsql-hackers. pg_opclass now has a row for each opclass supported by each
index AM, not a row for each opclass name. This allows pg_opclass to show
directly whether an AM supports an opclass, and furthermore makes it possible
to store additional information about an opclass that might be AM-dependent.
pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we
previously expected the user to remember to provide in CREATE INDEX commands.
Lossiness is no longer an index-level property, but is associated with the
use of a particular operator in a particular index opclass.
Along the way, IndexSupportInitialize now uses the syscaches to retrieve
pg_amop and pg_amproc entries. I find this reduces backend launch time by
about ten percent, at the cost of a couple more special cases in catcache.c's
IndexScanOK.
Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane.
initdb forced.
Diffstat (limited to 'contrib/intarray/expected')
| -rw-r--r-- | contrib/intarray/expected/_int.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/intarray/expected/_int.out b/contrib/intarray/expected/_int.out index 4cde92ce56..edcccf54bb 100644 --- a/contrib/intarray/expected/_int.out +++ b/contrib/intarray/expected/_int.out @@ -17,7 +17,7 @@ SELECT count(*) from test__int WHERE a @ '{23,50}'; 12 (1 row) -CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ) with ( islossy ); +CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ); SELECT count(*) from test__int WHERE a && '{23,50}'; count ------- @@ -31,7 +31,7 @@ SELECT count(*) from test__int WHERE a @ '{23,50}'; (1 row) drop index text_idx; -CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ) with ( islossy ); +CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ); SELECT count(*) from test__int WHERE a && '{23,50}'; count ------- |