[rt-users] Performance on PostgreSQL

[Kenneth Marshall]

On Fri, Oct 13, 2006 at 10:44:57AM -0400, Vivek Khera wrote:
> 
> On Oct 13, 2006, at 9:07 AM, Kenneth Marshall wrote:
> 
> >
> >Here are the indexes that needed to be added to the DB to enable fast
> >OID based queries. Hopefully, they can be included in 3.6.2+.
> >
> >CREATE INDEX attachmentsoid ON attachments USING btree ( oid );
> >CREATE INDEX cachedgroupmembersoid ON cachedgroupmembers USING  
> >btree ( oid );
> >CREATE INDEX objectcustomfieldvaluesoid ON objectcustomfieldvalues  
> >USING btree ( oid );
> 
> WTF is it trying to use OID's in queries?  OID's are off by default  
> on postgres 8.1 so most tables won't even have them.  RT's schema.Pg  
> file certainly doesn't request them.
> 
> I never saw RT trying to use OIDs for anything when I analyzed the  
> queries.  Is this something new in searchbuilder?
> 

Vivek,

I was as surprised as you. It may have been the result of migrations
from older versions of RT to newer versions. We started at 3.2, are
currently running 3.4.5, and are preparing to migrate to 3.6.x. If
the OIDs are not needed, I would like to drop them in our migration
to 3.6.x. This is with an older version of searchbuilder (1.36) on
the 3.4.5 system. We could not upgrade to a newer version because it
caused our DB queries to fail. Do you think that it is safe to remove
the oid column?

Ken