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

Commit4bd5006

Browse files
committed
Add index on pg_index.indrelid for Tom Lane.
1 parent5b9d0d9 commit4bd5006

File tree

3 files changed

+9
-6
lines changed

3 files changed

+9
-6
lines changed

‎src/backend/catalog/indexing.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
*
1010
*
1111
* IDENTIFICATION
12-
* $Header: /cvsroot/pgsql/src/backend/catalog/indexing.c,v 1.62 2000/05/30 00:49:42 momjian Exp $
12+
* $Header: /cvsroot/pgsql/src/backend/catalog/indexing.c,v 1.63 2000/06/07 02:44:35 momjian Exp $
1313
*
1414
*-------------------------------------------------------------------------
1515
*/
@@ -45,7 +45,7 @@ char *Name_pg_class_indices[Num_pg_class_indices] =
4545
char*Name_pg_group_indices[Num_pg_group_indices]=
4646
{GroupNameIndex,GroupSysidIndex};
4747
char*Name_pg_index_indices[Num_pg_index_indices]=
48-
{IndexRelidIndex};
48+
{IndexRelidIndex,IndexIndrelidIndex};
4949
char*Name_pg_inherits_indices[Num_pg_inherits_indices]=
5050
{InheritsRelidSeqnoIndex};
5151
char*Name_pg_language_indices[Num_pg_language_indices]=

‎src/backend/utils/cache/syscache.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $Header: /cvsroot/pgsql/src/backend/utils/cache/syscache.c,v 1.51 2000/06/06 17:02:38 tgl Exp $
11+
* $Header: /cvsroot/pgsql/src/backend/utils/cache/syscache.c,v 1.52 2000/06/0702:44:37 momjian Exp $
1212
*
1313
* NOTES
1414
* These routines allow the parser/planner/executor to perform
@@ -71,7 +71,7 @@ typedef HeapTuple (*ScanFunc) ();
7171
In backend/catalog/indexing.c, initialize the relation array with
7272
the index names for the relation, fixed size of relation (or marking
7373
first non-fixed length field), and create the index lookup function.
74-
Pick one thattakes similar arguments and use that one, but keep the
74+
Pick one thathas similar arguments and use that one, but keep the
7575
function names in the same order as the cache list for clarity.
7676
7777
Finally, any place your relation gets heap_insert() or

‎src/include/catalog/indexing.h

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc
99
* Portions Copyright (c) 1994, Regents of the University of California
1010
*
11-
* $Id: indexing.h,v 1.37 2000/04/12 17:16:27 momjian Exp $
11+
* $Id: indexing.h,v 1.38 2000/06/07 02:44:40 momjian Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -28,7 +28,7 @@
2828
#defineNum_pg_class_indices2
2929
#defineNum_pg_description_indices1
3030
#defineNum_pg_group_indices2
31-
#defineNum_pg_index_indices1
31+
#defineNum_pg_index_indices2
3232
#defineNum_pg_inherits_indices1
3333
#defineNum_pg_language_indices2
3434
#defineNum_pg_listener_indices1
@@ -58,6 +58,7 @@
5858
#defineDescriptionObjIndex"pg_description_objoid_index"
5959
#defineGroupNameIndex"pg_group_name_index"
6060
#defineGroupSysidIndex"pg_group_sysid_index"
61+
#defineIndexIndrelidIndex"pg_index_indrelid_index"
6162
#defineIndexRelidIndex"pg_index_indexrelid_index"
6263
#defineInheritsRelidSeqnoIndex"pg_inherits_relid_seqno_index"
6364
#defineLanguageNameIndex"pg_language_name_index"
@@ -183,6 +184,8 @@ DECLARE_UNIQUE_INDEX(pg_class_relname_index on pg_class using btree(relname name
183184
DECLARE_UNIQUE_INDEX(pg_description_objoid_indexonpg_descriptionusingbtree(objoidoid_ops));
184185
DECLARE_UNIQUE_INDEX(pg_group_name_indexonpg_groupusingbtree(gronamename_ops));
185186
DECLARE_UNIQUE_INDEX(pg_group_sysid_indexonpg_groupusingbtree(grosysidint4_ops));
187+
/* This following index is not used for a cache and is not unique */
188+
DECLARE_INDEX(pg_index_indrelid_indexonpg_indexusingbtree(indrelidoid_ops));
186189
DECLARE_UNIQUE_INDEX(pg_index_indexrelid_indexonpg_indexusingbtree(indexrelidoid_ops));
187190
DECLARE_UNIQUE_INDEX(pg_inherits_relid_seqno_indexonpg_inheritsusingbtree(inhrelidoid_ops,inhseqnoint4_ops));
188191
DECLARE_UNIQUE_INDEX(pg_language_name_indexonpg_languageusingbtree(lannamename_ops));

0 commit comments

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