9 Before making any changes to your database, always ensure that you have a
10 complete current backup. If you don't have a current backup, you could
11 accidentally damage your database and lose data or worse.
18 ----------------------------------------------------------------------
26 If you are upgrading from versions between 3.0.0 and 3.0.7, inclusive,
27 you might find improved performance by adding the following index to
30 CREATE INDEX Links4 ON Links(Type,LocalBase);
41 If you are upgrading from versions between 3.0.0 and 3.0.6, inclusive,
42 you might find improved performance by adding the following indices to
45 CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content);
46 CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket);
48 CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
55 If you have a Postgres database, the following changes to your
56 database can improve performance:
58 ALTER TABLE groups rename instance to instance1;
59 ALTER TABLE groups add instance int;
60 UPDATE groups SET instance = instance1::text::int where btrim(instance1) <> '';
61 ALTER TABLE groups drop column instance1;