Re: [Monotone-devel] speed of 0.99

[Markus Wanner]

On 11/28/2010 07:55 PM, Timothy Brownawell wrote:
> Do we mind having an index-only schema change between 0.99 and 1.0? It
> sounds like we'd get a noticeably better user experience...

I'd certainly appreciate it, but maybe someone who values the 1.0 change
a bit more than I do should comment on that one.

> -CREATE INDEX revision_certs__revision_id ON revision_certs (revision_id);
> +CREATE INDEX revision_certs__revnameval ON revision_certs (revision_id,
> +       name, value, keypair_id, signature);

Hm.. with a strong Postgres background, this looks a bit overkill. Do we
really need to replicate that many attributes in the index? Doesn't
(rev_id, name) suffice? Do we ever scan for (rev_id, name, value) so
that would be an advantage?

Regards

Markus Wanner