[aur-dev] [PATCH 1/2] Add multicolumn indexes on votes and notifications tables

[Dan McGee]

On Thu, Apr 16, 2009 at 11:37 AM, Aaron Griffin <aaronmgriffin at gmail.com> wrote:
> On Thu, Apr 16, 2009 at 11:30 AM, Loui Chang <louipc.ist at gmail.com> wrote:
>> On Wed, Apr 15, 2009 at 06:34:28PM -0500, Dan McGee wrote:
>>> Loui- I noticed you applied the patch I sent a day or two after this
>>> one but didn't do anything with this one and its pair (explicit join
>>> usage in query). Just wanted to make sure it didn't get lost.
>>
>> Yeah. I definitely still have my eye on this.
>> Actually I was wondering how to add these indexes to an existing DB,
>> but I haven't had the chance to look into it.
>
> Just running the CREATE statements should work fine, as Dan said they
> do not exist already.
>
> If they did exist, that's another story :)

Yep, just run the CREATE statement. As I told you over IM, I added
these indexes on the production DB already so that isn't an issue, but
you can of course create them locally.

If an index with that name already exists, it is just a "DROP INDEX
<name>;" away from not being a problem.

-Dan