Simon Riggs wrote:
> On Mon, 2008-01-28 at 14:36 +0100, Cyril SCETBON wrote:
>   
>> Simon Riggs wrote:
>>     
>>> On Thu, 2008-01-17 at 15:52 +0100, Cyril SCETBON wrote:
>>>
>>>   
>>>       
>>>> Here are the plots of several metrics taken with the original slon 
>>>> binary (25 september 2007) and with the new slon binary (including 
>>>> modifications of static variables, 16 october 2007)
>>>>     
>>>>         
>>> Cool graphs.
>>>
>>> First graph the effect you highlighted is shown very clearly.
>>>
>>> Second one may need repeating because if the performance really does get
>>> a lot worse *sometimes* then we may want to go back.
>>>
>>> Does this include Chris's latest changes to avoid VACUUM altogether?
>>>   
>>>       
>> no.
>>
>> NB: sorry I think my email was in a moderated state.
>>     
>
> Cyril,
>
> Sorry, I don't understand that.
>   
I just said that the tests were not running with the new version.
> Your earlier graphs highlight the problem very well. Chris mentions that
> the proposed solution has already been committed, based upon my
> analysis. 
>   
ok
> Re-running the tests with the latest version of the software would help
> confirm that the problem has gone away. Would you be able to repeat the
> tests to confirm that the response time no longer peaks periodically as
> it did before?
>   
not now cause other tests are already running. I'll try it as soon as I 
can. Can I try just the new slon daemon with the current configuration 
or do I have to recreate the cluster configuration ?

-- 
Cyril SCETBON - Ingénieur bases de données
AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon at jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat 
Bâtiment Marco Polo C2 
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************