[rt-users] Performance on PostgreSQL

[Dmitri Tikhonov]

On Fri, 2006-10-13 at 08:07 -0500, Kenneth Marshall wrote:
> CREATE INDEX attachmentsoid ON attachments USING btree ( oid );
> CREATE INDEX cachedgroupmembersoid ON cachedgroupmembers USING btree ( oid );
> CREATE INDEX objectcustomfieldvaluesoid ON objectcustomfieldvalues USING btree ( oid );
> CREATE INDEX transactionsoid ON transactions USING btree ( oid );

Here's also a post from two years ago that still applies to 3.4.5:

http://lists.bestpractical.com/pipermail/rt-devel/2004-September/006273.html

  - Dmitri.