blob: 4306eb6cbbbabfad39c67956ccbddea92844f0d7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
UPGRADING
*******
WARNING
*******
Before making any changes to your database, always ensure that you have a
complete current backup. If you don't have a current backup, you could
accidentally damage your database and lose data or worse.
Look for the
----------------------------------------------------------------------
3.0.7
=====
All Databases
-------------
If you are upgrading from versions between 3.0.0 and 3.0.7, inclusive,
you might find improved performance by adding the following index to
your database:
CREATE INDEX Links4 ON Links(Type,LocalBase);
3.0.6
=====
All Databases
-------------
If you are upgrading from versions between 3.0.0 and 3.0.6, inclusive,
you might find improved performance by adding the following indices to
your database:
CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content);
CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket);
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
Postgres
--------
If you have a Postgres database, the following changes to your
database can improve performance:
ALTER TABLE groups rename instance to instance1;
ALTER TABLE groups add instance int;
UPDATE groups SET instance = instance1::text::int where btrim(instance1) <> '';
ALTER TABLE groups drop column instance1;
|
