<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">Le 25 nov. 2014 à 15:53, Christian Quest <<a href="mailto:cquest@openstreetmap.fr" class="">cquest@openstreetmap.fr</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><span class="Apple-converted-space"> </span>Des "trous" se créent et occupent inutilement de l'espace que l'on ne récupère qu'en faisant des manip un peu longues et bloquantes (obligé de suspendre les updates).</span></div></blockquote></div>Tu utilises VACCUUM de pgsql ?<div class=""><br class=""><div class=""><br class=""><div class=""><a href="http://www.postgresql.org/docs/8.4/static/sql-vacuum.html" class="">La doc</a> indique un mode qui n’est pas bloquant et qui est conseillé de faire régulièrement sur des tables qui grossissent trop vites :</div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><span style="font-family: verdana, sans-serif; line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);" class="">Plain </span><tt class="COMMAND" style="line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);">VACUUM</tt><span style="font-family: verdana, sans-serif; line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);" class=""> (without </span><tt class="LITERAL" style="line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);">FULL</tt><span style="font-family: verdana, sans-serif; line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);" class="">) simply reclaims space and makes it available for re-use.</span></div><div class=""><span style="font-family: verdana, sans-serif; line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);" class="">This form of the command can operate in parallel with normal reading and writing of the table, as an exclusive lock is not obtained.</span></div><div class=""><span style="font-family: verdana, sans-serif; line-height: 18.2399997711182px; background-color: rgb(255, 255, 255);" class=""><br class=""></span></div></blockquote>—<br class="">Yves</div></div></body></html>