<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style>
</head>
<body><div>Hi Egon,<br></div>
<div><br></div>
<div>Yes, the slave should index in conversations.db automatically AFAIK. <br></div>
<div><br></div>
<div>You should run squatter in rolling mode on the master, too. <br></div>
<div><br></div>
<div>BTW: in 2014, Bron wrote a blog post about the search setup at FastMail: <a href="https://fastmail.blog/2014/12/01/email-search-system/" class="">https://fastmail.blog/2014/12/01/email-search-system/</a><br></div>
<div>It’s quite technical, but should give you a good idea at how it’s set up for fast indexing and search <br></div>
<div><br></div>
<div>Cheers, Robert </div>
<div><br></div>
<div><br></div>
<div>On Mon, Jan 7, 2019, at 5:54 PM, Egoitz Aurrekoetxea wrote:<br></div>
<blockquote type="cite"><p>Hi Robert!<br></p><p><br></p><p>Thank you so much for helping us (mainly which is the one boring the list with questions :) although I promise I've checked the doc before asking :) :) ).<br></p><p><br></p><p>When you have a master/slave config... in the slave one, when running Squatter in rolling mode... does it update the conversations db too?. By the way, Squatter in rolling mode only makes sense in slave machines isn't it?.<br></p><p><br></p><p>Many thanks!<br></p><p><br></p><div><div>---<br></div>
<div> <br></div>
<div style="clear:both;text-align:left;"><div style="margin-top:0px;margin-right:0px;margin-bottom:10px;margin-left:0px;"><img src="https://www.fastmailusercontent.com/proxy/a5d9804681aecc18b32a831c35a8175e04d4299aad69fa43dc45f6a4d4a2bb40/8647470737a3f2f2777777e237162756e65647e25637f256374716479636f637f2c4f676f635162756e6564754d61696c637e207e676f3e65677c6f676f6/LogoSarenetEmails.png" alt="sarenet"><br></div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:bold;font-size:14px;color:rgb(51, 51, 51);"><b>Egoitz Aurrekoetxea</b><br></div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(51, 51, 51);">Departamento de sistemas<br></div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(51, 51, 51);"><div>944 209 470<br></div>
<div>Parque Tecnológico. Edificio 103<br></div>
<div>48170 Zamudio (Bizkaia)<br></div>
</div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(0, 122, 196);line-height:1.2;"><label>egoitz@sarenet.es<br></label></div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(0, 122, 196);line-height:1.2;"><a style="font-size:12px;color:rgb(0, 122, 196);text-decoration:underline;" href="http://www.sarenet.es">www.sarenet.es</a><br></div>
<div><br></div>
<div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:10px;color:rgb(160, 195, 97);">Antes de imprimir este correo electrónico piense si es necesario hacerlo.<br></div>
</div>
</div>
<p><br></p><p>El 07-01-2019 16:42, Robert Stepanek escribió:<br></p><blockquote type="cite" style="padding-top:0px;padding-right:0.4em;padding-bottom:0px;padding-left:0.4em;border-left-width:2px;border-left-style:solid;border-left-color:rgb(16, 16, 255);margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;"><div>Hi,<br></div>
<div> <br></div>
<div>Sebastian is right:<br></div>
<div> <br></div>
<div>On Mon, Jan 7, 2019, at 3:57 PM, Sebastian Hagedorn wrote:<br></div>
<blockquote type="cite" style="padding-top:0px;padding-right:0.4em;padding-bottom:0px;padding-left:0.4em;border-left-width:2px;border-left-style:solid;border-left-color:rgb(16, 16, 255);margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;"><div> <br></div>
<div>squatter is nowadays a bit of a misnomer, because it uses whatever index<br></div>
<div>you have configured. In cyrus 2.4, squatter would always create a SQUAT<br></div>
<div>index. When you run squatter with Xapian, it will build the index, but for<br></div>
<div>the index to actually work, you also need the conversationsdb.<br></div>
</blockquote><div> <br></div>
<div>conversations.db is indeed a misnomer now. The database was only used to keep track of mail threads (hence the name), but its role expanded. One of the indexes it stores is the SHA1 hashes of every message, and separate hashes for each of that message MIME parts. Such a hash is named the GUID, and for each GUID we store a list of all mailbox:UID[bodypart] pairs where this content occurs in.<br></div>
<div> <br></div>
<div>For search, we keep track of the indexed messages by GUID, so we can avoid reindexing duplicate mails. To return a search result, we can now map that GUID back to its mailbox:message pairs. That's why we need conversations.db for search.<br></div>
<div> <br></div>
<div>I can't help with upgrading from 2.4, unfortunately, but if you re-index your mailboxes once in conversations.db, you should be all set.<br></div>
<div> <br></div>
<div>Cheers,<br></div>
<div>Robert<br></div>
<div><br></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font-family:monospace;"><div>----<br></div>
<div> Cyrus Home Page: <a href="http://www.cyrusimap.org/">http://www.cyrusimap.org/</a><br></div>
<div> List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a><br></div>
<div> To Unsubscribe:<br></div>
<div> <a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a><br></div>
</div>
</blockquote></blockquote><div><br></div>
</body>
</html>