[rt-users] Performance on PostgreSQL

Vivek Khera vivek at khera.org
Fri Oct 13 10:44:57 EDT 2006


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?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061013/5449ee7e/attachment.bin>


More information about the RT-Users mailing list