https://rt-wiki.bestpractical.com/index.php?action=history&feed=atom&title=DatabaseIndexes 2026-08-22T09:38:00Z Revision history for this page on the wiki MediaWiki 1.41.1 https://rt-wiki.bestpractical.com/index.php?title=DatabaseIndexes&diff=821&oldid=prev 2016-04-06T20:08:44Z

<p>2 revisions imported</p> <p><b>New page</b></p><div>This page is intended to capture notes about possible additional database indexes, which could be used to influence future updates to the official schemas.<br /> <br /> Ideally stick to the fixed format so that the details are clear (although feel free to add other relevant fields and free-form rationales, etc.)<br /> <br /> ----<br /> <br /> * Baseline: 3.8.7<br /> * Database: [[PostgreSQL]]<br /> * Database Version: 8.3<br /> * Suggested by: Dominic Hargreaves<br /> * Tested system: snapshots of rt.oucs.ox.ac.uk<br /> * Definition: CREATE INDEX groups3 on groups(lower(type::text), lower(domain::text), instance);<br /> <br /> * http://rt3.fsck.com/Ticket/Display.html?id=8568<br /> * http://rt3.fsck.com/Ticket/Display.html?id=13056<br /> <br /> ----<br /> <br /> * Baseline: 3.8.7<br /> * Database: [[PostgreSQL]]<br /> * Database Version: 8.3<br /> * Suggested by: Dominic Hargreaves<br /> * Tested system: snapshots of rt.oucs.ox.ac.uk<br /> * Definition: CREATE INDEX users5 ON users (LOWER(emailaddress));<br /> <br /> * http://lists.bestpractical.com/pipermail/rt-users/2009-November/062386.html<br /> <br /> ----<br /> <br /> * Baseline: 3.8.7<br /> * Database: [[PostgreSQL]]<br /> * Database Version: 8.3<br /> * Suggested by: Dominic Hargreaves<br /> * Tested system: snapshots of rt.oucs.ox.ac.uk<br /> * Definition: CREATE UNIQUE INDEX users6 on users(lower(name::text));<br /> <br /> ----<br /> <br /> * Baseline: 3.8.7<br /> * Database: [[PostgreSQL]]<br /> * Database Version: 8.3<br /> * Suggested by: Dominic Hargreaves<br /> * Tested system: snapshots of rt.oucs.ox.ac.uk<br /> * Definition: CREATE INDEX principals3 on principals (disabled, principaltype);<br /> <br /> ----<br /> <br /> * Baseline: 3.8.7<br /> * Database: [[PostgreSQL]]<br /> * Database Version: 8.3<br /> * Suggested by: Dominic Hargreaves<br /> * Definition: CREATE INDEX tickets6 on tickets (status, owner, type, effectiveid);</div>

Admin