To apply this fix, you must run the SQL script, 500-006.sql, which will create a set of indexes to improve database performance. The script file is located in the files/sql sub-directory of the hotfix directory. The script should be applied manually against "mapleta" database. To run the script, follow these instructions.
- Start pgAdmin.
- Double-click the "PostgreSQL Server" node to open it. You will need to supply your Postgres password.
- Click on the "mapleta" database node to select it.
- Select [Tools][Query tool] menu.
- Paste the content of the "files/sql/500-006.sql" script into the query pane (upper left)
- Press F5 to execute the command. You should see a response similar to the following, in the "Output pane", underneath the query pane.
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_class_pkey" for table "assignment_class"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_advanced_policy_pkey" for table "assignment_advanced_policy"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_mastery_penalty_pkey" for table "assignment_mastery_penalty"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_mastery_policy_pkey" for table "assignment_mastery_policy"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_policy_pkey" for table "assignment_policy"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_question_group_pkey" for table "assignment_question_group"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question" for table "question"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_question_group_map_pkey" for table "assignment_question_group_map"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question_group" for table "question_group"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question_group_map" for table "question_group_map"
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "unique_question_group_map" for table "question_group_map"
Query returned successfully with no result in 2107 ms.
The execution time will be different for different systems.
- Exit the query tool, and exit pgAdmin III. You are finished
Return to Maple T.A. 5.0 Hotfixes
