On Thu, 31 Aug 2006, Kamesh Jayachandran wrote:
> Daniel Berlin wrote:
> >On 8/30/06, Kamesh Jayachandran <kamesh@collab.net> wrote:
...
> >>3. The schema+code change to avoid the 'arithmetic series' of records in
> >> 'mergeinfo' table as mentioned in point 1.
> >> (After 20 merges I could see 210 records in my
> >> 'mergeinfo' table, It goes like this n(n+1)/2. for 1000 '1 merge+1
> >>commit'
> >> on a same target lead to (1000*1001/2) 500500 records.
> >>
> >>4. The name of the table 'mergeinfo' should rather be
> >>'mergeinfo_details'
> >> and the name of the table 'mergeinfo_changed' should be 'mergeinfo'.
...
> >The mergeinfo schema has known N^2 space usage issues. I would
> >suggest you look at something like the alternative schema posted a
> >while ago if you want something to work on.
> >
> Will look in to that.
I believe Dan is referring to the schema posted by David James.
- application/pgp-signature attachment: stored
Received on Mon Sep 11 22:04:27 2006