New db indexes with upgrade to 2.0.8

RT Users
1

I’ve just upgraded from rt-2.0.6 to 2.0.8. I am using the most recent
perl mods I could find. back end is postgres 7.1.3. perl is 5.6.1

I recall from this list the addition of various data base indexes to
help speed up searches. Looking through the Makefile, it is apparent no
new indexes are added by ‘make upgrade’.

Should I try to add these by hand? Is there a list of them I can use?

ashley

2

I’ve translated David Troy’s ADD INDEX list to postgres. It looks like
this:

CREATE INDEX TicketIndex ON Transactions (Ticket);
CREATE INDEX EffectiveTicketIndex ON Transactions (EffectiveTicket);
CREATE INDEX CreatorIndexTransactions ON Transactions (Creator);
CREATE INDEX CreatorIndexAttachments ON Attachments (Creator);
CREATE INDEX ParentIndex ON Attachments (Parent);
CREATE INDEX TransactionId ON Attachments (TransactionId);
CREATE INDEX EffectiveIdIndex ON Tickets (EffectiveId);
CREATE INDEX OwnerIndex ON Tickets (Owner);
CREATE INDEX CreatorIndexTickets ON Tickets (Creator);

I haven’t notices any difference, but my db is small. It is also highly
posible I don’t know what I’m doing.

comments?On Wed, Oct 31, 2001 at 06:47:27PM -0800, Ashley Gould wrote:

I’ve just upgraded from rt-2.0.6 to 2.0.8. I am using the most recent
perl mods I could find. back end is postgres 7.1.3. perl is 5.6.1

I recall from this list the addition of various data base indexes to
help speed up searches. Looking through the Makefile, it is apparent no
new indexes are added by ‘make upgrade’.

Should I try to add these by hand? Is there a list of them I can use?

ashley

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users