Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit816e10d

Browse files
committed
Fix BRIN operator family definitions
The original definitions were leaving no room for cross-type operators,so queries that compared a column of one type against something of adifferent type were not taking advantage of the index. Fix by makingthe opfamilies more like the ones for Btree, and include a fewcross-type operator classes.Catalog version bumped.Per complaints from Hubert Lubaczewski, Mark Wong, Heikki Linnakangas.
1 parentae04bf5 commit816e10d

File tree

5 files changed

+275
-95
lines changed

5 files changed

+275
-95
lines changed

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201411271
56+
#defineCATALOG_VERSION_NO201411281
5757

5858
#endif

‎src/include/catalog/pg_amop.h

Lines changed: 100 additions & 32 deletions
Original file line numberDiff line numberDiff line change
@@ -864,24 +864,53 @@ DATA(insert ( 4065 19 19 2 s 661 3580 0 ));
864864
DATA(insert (406519193s9335800 ));
865865
DATA(insert (406519194s66335800 ));
866866
DATA(insert (406519195s66235800 ));
867-
/* minmax bigint */
868-
DATA(insert (406320201s41235800 ));
869-
DATA(insert (406320202s41435800 ));
870-
DATA(insert (406320203s41035800 ));
871-
DATA(insert (406320204s41535800 ));
872-
DATA(insert (406320205s41335800 ));
873-
/* minmax smallint */
874-
DATA(insert (406721211s9535800 ));
875-
DATA(insert (406721212s52235800 ));
876-
DATA(insert (406721213s9435800 ));
877-
DATA(insert (406721214s52435800 ));
878-
DATA(insert (406721215s52035800 ));
879867
/* minmax integer */
868+
DATA(insert (405420201s41235800 ));
869+
DATA(insert (405420202s41435800 ));
870+
DATA(insert (405420203s41035800 ));
871+
DATA(insert (405420204s41535800 ));
872+
DATA(insert (405420205s41335800 ));
873+
DATA(insert (405420211s187035800 ));
874+
DATA(insert (405420212s187235800 ));
875+
DATA(insert (405420213s186835800 ));
876+
DATA(insert (405420214s187335800 ));
877+
DATA(insert (405420215s187135800 ));
878+
DATA(insert (405420231s41835800 ));
879+
DATA(insert (405420232s42035800 ));
880+
DATA(insert (405420233s41635800 ));
881+
DATA(insert (405420234s43035800 ));
882+
DATA(insert (405420235s41935800 ));
883+
DATA(insert (405421211s9535800 ));
884+
DATA(insert (405421212s52235800 ));
885+
DATA(insert (405421213s9435800 ));
886+
DATA(insert (405421214s52435800 ));
887+
DATA(insert (405421215s52035800 ));
888+
DATA(insert (405421201s186435800 ));
889+
DATA(insert (405421202s186635800 ));
890+
DATA(insert (405421203s186235800 ));
891+
DATA(insert (405421204s186735800 ));
892+
DATA(insert (405421205s186535800 ));
893+
DATA(insert (405421231s53435800 ));
894+
DATA(insert (405421232s54035800 ));
895+
DATA(insert (405421233s53235800 ));
896+
DATA(insert (405421234s54235800 ));
897+
DATA(insert (405421235s53635800 ));
880898
DATA(insert (405423231s9735800 ));
881899
DATA(insert (405423232s52335800 ));
882900
DATA(insert (405423233s9635800 ));
883901
DATA(insert (405423234s52535800 ));
884902
DATA(insert (405423235s52135800 ));
903+
DATA(insert (405423211s53535800 ));
904+
DATA(insert (405423212s54135800 ));
905+
DATA(insert (405423213s53335800 ));
906+
DATA(insert (405423214s54335800 ));
907+
DATA(insert (405423215s53735800 ));
908+
DATA(insert (405423201s3735800 ));
909+
DATA(insert (405423202s8035800 ));
910+
DATA(insert (405423203s1535800 ));
911+
DATA(insert (405423204s8235800 ));
912+
DATA(insert (405423205s7635800 ));
913+
885914
/* minmax text */
886915
DATA(insert (405625251s66435800 ));
887916
DATA(insert (405625252s66535800 ));
@@ -900,18 +929,28 @@ DATA(insert ( 4069 27 27 2 s 2801 3580 0 ));
900929
DATA(insert (406927273s38735800 ));
901930
DATA(insert (406927274s280235800 ));
902931
DATA(insert (406927275s280035800 ));
903-
/* minmaxreal */
932+
/* minmaxfloat (float4, float8) */
904933
DATA(insert (40707007001s62235800 ));
905934
DATA(insert (40707007002s62435800 ));
906935
DATA(insert (40707007003s62035800 ));
907936
DATA(insert (40707007004s62535800 ));
908937
DATA(insert (40707007005s62335800 ));
909-
/* minmax double precision */
910-
DATA(insert (40717017011s67235800 ));
911-
DATA(insert (40717017012s67335800 ));
912-
DATA(insert (40717017013s67035800 ));
913-
DATA(insert (40717017014s67535800 ));
914-
DATA(insert (40717017015s67435800 ));
938+
DATA(insert (40707007011s112235800 ));
939+
DATA(insert (40707007012s112435800 ));
940+
DATA(insert (40707007013s112035800 ));
941+
DATA(insert (40707007014s112535800 ));
942+
DATA(insert (40707007015s112335800 ));
943+
DATA(insert (40707017001s113235800 ));
944+
DATA(insert (40707017002s113435800 ));
945+
DATA(insert (40707017003s113035800 ));
946+
DATA(insert (40707017004s113535800 ));
947+
DATA(insert (40707017005s113335800 ));
948+
DATA(insert (40707017011s67235800 ));
949+
DATA(insert (40707017012s67335800 ));
950+
DATA(insert (40707017013s67035800 ));
951+
DATA(insert (40707017014s67535800 ));
952+
DATA(insert (40707017015s67435800 ));
953+
915954
/* minmax abstime */
916955
DATA(insert (40727027021s56235800 ));
917956
DATA(insert (40727027022s56435800 ));
@@ -942,30 +981,59 @@ DATA(insert ( 4076 1042 1042 2 s 1059 3580 0 ));
942981
DATA(insert (4076104210423s105435800 ));
943982
DATA(insert (4076104210424s106135800 ));
944983
DATA(insert (4076104210425s106035800 ));
945-
/* minmax date */
946-
DATA(insert (4061108210821s109535800 ));
947-
DATA(insert (4061108210822s109635800 ));
948-
DATA(insert (4061108210823s109335800 ));
949-
DATA(insert (4061108210824s109835800 ));
950-
DATA(insert (4061108210825s109735800 ));
951984
/* minmax time without time zone */
952985
DATA(insert (4077108310831s111035800 ));
953986
DATA(insert (4077108310832s111135800 ));
954987
DATA(insert (4077108310833s110835800 ));
955988
DATA(insert (4077108310834s111335800 ));
956989
DATA(insert (4077108310835s111235800 ));
957-
/* minmaxtimestamp without time zone */
990+
/* minmaxdatetime (date, timestamp, timestamptz) */
958991
DATA(insert (4059111411141s206235800 ));
959992
DATA(insert (4059111411142s206335800 ));
960993
DATA(insert (4059111411143s206035800 ));
961994
DATA(insert (4059111411144s206535800 ));
962995
DATA(insert (4059111411145s206435800 ));
963-
/* minmax timestamp with time zone */
964-
DATA(insert (4060118411841s132235800 ));
965-
DATA(insert (4060118411842s132335800 ));
966-
DATA(insert (4060118411843s132035800 ));
967-
DATA(insert (4060118411844s132535800 ));
968-
DATA(insert (4060118411845s132435800 ));
996+
DATA(insert (4059111410821s237135800 ));
997+
DATA(insert (4059111410822s237235800 ));
998+
DATA(insert (4059111410823s237335800 ));
999+
DATA(insert (4059111410824s237435800 ));
1000+
DATA(insert (4059111410825s237535800 ));
1001+
DATA(insert (4059111411841s253435800 ));
1002+
DATA(insert (4059111411842s253535800 ));
1003+
DATA(insert (4059111411843s253635800 ));
1004+
DATA(insert (4059111411844s253735800 ));
1005+
DATA(insert (4059111411845s253835800 ));
1006+
DATA(insert (4059108210821s109535800 ));
1007+
DATA(insert (4059108210822s109635800 ));
1008+
DATA(insert (4059108210823s109335800 ));
1009+
DATA(insert (4059108210824s109835800 ));
1010+
DATA(insert (4059108210825s109735800 ));
1011+
DATA(insert (4059108211141s234535800 ));
1012+
DATA(insert (4059108211142s234635800 ));
1013+
DATA(insert (4059108211143s234735800 ));
1014+
DATA(insert (4059108211144s234835800 ));
1015+
DATA(insert (4059108211145s234935800 ));
1016+
DATA(insert (4059108211841s235835800 ));
1017+
DATA(insert (4059108211842s235935800 ));
1018+
DATA(insert (4059108211843s236035800 ));
1019+
DATA(insert (4059108211844s236135800 ));
1020+
DATA(insert (4059108211845s236235800 ));
1021+
DATA(insert (4059118410821s238435800 ));
1022+
DATA(insert (4059118410822s238535800 ));
1023+
DATA(insert (4059118410823s238635800 ));
1024+
DATA(insert (4059118410824s238735800 ));
1025+
DATA(insert (4059118410825s238835800 ));
1026+
DATA(insert (4059118411141s254035800 ));
1027+
DATA(insert (4059118411142s254135800 ));
1028+
DATA(insert (4059118411143s254235800 ));
1029+
DATA(insert (4059118411144s254335800 ));
1030+
DATA(insert (4059118411145s254435800 ));
1031+
DATA(insert (4059118411841s132235800 ));
1032+
DATA(insert (4059118411842s132335800 ));
1033+
DATA(insert (4059118411843s132035800 ));
1034+
DATA(insert (4059118411844s132535800 ));
1035+
DATA(insert (4059118411845s132435800 ));
1036+
9691037
/* minmax interval */
9701038
DATA(insert (4078118611861s133235800 ));
9711039
DATA(insert (4078118611862s133335800 ));

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp