[kronolith] performance on large systems

[Chuck Hagenbuch]

Quoting John Madden <jmadden at ivytech.edu>:

>>> For that number of calendars, with the current share drivers, you   
>>> probably want to turn off calendar sharing entirely. People will  
>>> still  be able to share events via invitations, and we're working  
>>> on a faster  sharing driver.
>>
>> Calendar sharing is a pretty critical component of what we're doing  
>> (and why we're implementing Horde to begin with).  Is there  
>> anything I can do to help?
>
> Hmm.  I disabled sharing and found that the performance issue is the  
> same and the SQL statements being executed don't appear to be any  
> different.  Is sharing a red herring?  The SQL I sent before seems  
> clunky (at best) to me -- why the CASTs and regexps?  Can those be  
> eliminated?

Possibly - I don't know enough about postgres to know if it can be  
done better.

What config var did you disable? I meant disabling the shares driver  
entirely (setting it to null).

-chuck