diff options
author | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
---|---|---|
committer | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
commit | 022491d9d2723ca4d7d0718cdb1fd67e7652428e (patch) | |
tree | fc1e50c0d78ecc401ef2214a6a11ee07242be0f8 /rt/UPGRADING | |
parent | 35effa1bf4ac902547615c816960bbc8db8e7256 (diff) |
This commit was manufactured by cvs2svn to create tag 'NET_WHOIS_RAW_0_31'.NET_WHOIS_RAW_0_31
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 4306eb6cb..000000000 --- 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; - - - |