Comment 17 for bug 421901

The key slowdown is in bugmessage<->message establishment. The following should let us evaluate dropping a table in determining that on a staging server:

begin;
alter table bugmessage add column owner int;
update bugmessage set owner=message.owner from message where message.id=bugmessage.message;
create index bugmessage__owner__idx on bugmessage using btree(owner);
create index bugmessage__owner__index__idx on bugmessage using btree(owner, index);
create index bugmessage__commentor__idx on bugmessage using btree(owner) where index > 0;
commit;