[rt-users] new db indexes with upgrade to 2.0.8

[Ashley Gould]

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 at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users