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

Commita80889a

Browse files
committed
Set procost to 10 for each of the pg_foo_is_visible() functions.
The idea here is to make sure the planner will evaluate these functionslast not first among the filter conditions in psql pattern search andtab-completion queries. We've discussed this several times, and therewas consensus to do it back in August, but we didn't want to do it justbefore a release. Now seems like a safer time.No catversion bump, since this catalog change doesn't create a backendincompatibility nor any regression test result changes.
1 parent3f88fa9 commita80889a

File tree

1 file changed

+12
-12
lines changed

1 file changed

+12
-12
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -2908,29 +2908,29 @@ DESCR("view two-phase transactions");
29082908
DATA(insertOID=3537 (pg_describe_objectPGNSPPGUID121000fffftfs3025"26 26 23"_null__null__null__null_pg_describe_object_null__null__null_ ));
29092909
DESCR("get identification of SQL object");
29102910

2911-
DATA(insertOID=2079 (pg_table_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_table_is_visible_null__null__null_ ));
2911+
DATA(insertOID=2079 (pg_table_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_table_is_visible_null__null__null_ ));
29122912
DESCR("is table visible in search path?");
2913-
DATA(insertOID=2080 (pg_type_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_type_is_visible_null__null__null_ ));
2913+
DATA(insertOID=2080 (pg_type_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_type_is_visible_null__null__null_ ));
29142914
DESCR("is type visible in search path?");
2915-
DATA(insertOID=2081 (pg_function_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_function_is_visible_null__null__null_ ));
2915+
DATA(insertOID=2081 (pg_function_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_function_is_visible_null__null__null_ ));
29162916
DESCR("is function visible in search path?");
2917-
DATA(insertOID=2082 (pg_operator_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_operator_is_visible_null__null__null_ ));
2917+
DATA(insertOID=2082 (pg_operator_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_operator_is_visible_null__null__null_ ));
29182918
DESCR("is operator visible in search path?");
2919-
DATA(insertOID=2083 (pg_opclass_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_opclass_is_visible_null__null__null_ ));
2919+
DATA(insertOID=2083 (pg_opclass_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_opclass_is_visible_null__null__null_ ));
29202920
DESCR("is opclass visible in search path?");
2921-
DATA(insertOID=3829 (pg_opfamily_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_opfamily_is_visible_null__null__null_ ));
2921+
DATA(insertOID=3829 (pg_opfamily_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_opfamily_is_visible_null__null__null_ ));
29222922
DESCR("is opfamily visible in search path?");
2923-
DATA(insertOID=2093 (pg_conversion_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_conversion_is_visible_null__null__null_ ));
2923+
DATA(insertOID=2093 (pg_conversion_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_conversion_is_visible_null__null__null_ ));
29242924
DESCR("is conversion visible in search path?");
2925-
DATA(insertOID=3756 (pg_ts_parser_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_ts_parser_is_visible_null__null__null_ ));
2925+
DATA(insertOID=3756 (pg_ts_parser_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_ts_parser_is_visible_null__null__null_ ));
29262926
DESCR("is text search parser visible in search path?");
2927-
DATA(insertOID=3757 (pg_ts_dict_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_ts_dict_is_visible_null__null__null_ ));
2927+
DATA(insertOID=3757 (pg_ts_dict_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_ts_dict_is_visible_null__null__null_ ));
29282928
DESCR("is text search dictionary visible in search path?");
2929-
DATA(insertOID=3768 (pg_ts_template_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_ts_template_is_visible_null__null__null_ ));
2929+
DATA(insertOID=3768 (pg_ts_template_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_ts_template_is_visible_null__null__null_ ));
29302930
DESCR("is text search template visible in search path?");
2931-
DATA(insertOID=3758 (pg_ts_config_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_ts_config_is_visible_null__null__null_ ));
2931+
DATA(insertOID=3758 (pg_ts_config_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_ts_config_is_visible_null__null__null_ ));
29322932
DESCR("is text search configuration visible in search path?");
2933-
DATA(insertOID=3815 (pg_collation_is_visiblePGNSPPGUID121000fffftfs1016"26"_null__null__null__null_pg_collation_is_visible_null__null__null_ ));
2933+
DATA(insertOID=3815 (pg_collation_is_visiblePGNSPPGUID1210000fffftfs1016"26"_null__null__null__null_pg_collation_is_visible_null__null__null_ ));
29342934
DESCR("is collation visible in search path?");
29352935

29362936
DATA(insertOID=2854 (pg_my_temp_schemaPGNSPPGUID121000fffftfs0026""_null__null__null__null_pg_my_temp_schema_null__null__null_ ));

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp