diff options
Diffstat (limited to 'rt/UPGRADING')
| -rw-r--r-- | rt/UPGRADING | 64 |
1 files changed, 0 insertions, 64 deletions
diff --git a/rt/UPGRADING b/rt/UPGRADING deleted file mode 100644 index 4306eb6..0000000 --- a/rt/UPGRADING +++ /dev/null @@ -1,64 +0,0 @@ -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; - - - |