Re: Disappointing test results from 9.40
Having redone the tests on a Linux server, I think I agree now that we may be hitting the bug highlighted by Jonathan Leffler and UK Tech Support.. The results on the Linux server, in contrast to those on HP, show a clear reduction in the alter fragment time when logging was enabled. The strange thing is that, although as suggested we see an increase with no logging in the amount of physlog activity, the total number of reads and writes is *lower* with logging *off*. I would point out that the workaround - enabling logging - is impractical in my client's case. Some of the tables being defragmented in this way are close to the 9.21 limit of 32Gbytes, and we can hardly add that much logical log space. So I would hope that a better solution is found. Is a "proper" fix slated for any forthcoming release? One small grumble: had we been included in the 9.40 beta test programme we would undoubtedly have spotted this. However the programme was restricted to users prepared to send staff to a week or more's training course in Kansas :-( cheers Neil
Neil Truby wrote: > One small grumble: had we been included in the 9.40 beta test programme we > would undoubtedly have spotted this. However the programme was restricted > to users prepared to send staff to a week or more's training course in > Kansas :-( Well then, dust off your trailer home and organise your hurricane insurance... -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:brlgdt$4ne8g$1@ID-64669.news.uni-berlin.de... > Neil Truby wrote: > > > One small grumble: had we been included in the 9.40 beta test programme we > > would undoubtedly have spotted this. However the programme was restricted > > to users prepared to send staff to a week or more's training course in > > Kansas :-( > > Well then, dust off your trailer home and organise your hurricane > insurance... This reminds me of one of my favourite ever poster ("billboard") campaigns, an advert for Malboro cigarettes. These posters have a consistent theme of the ruggedness and hardiness of the people of "Marlboro Country". The whole thing was just a vista of a huge Kansas landscape with a single small building in the middle. In the far, but rapidly approaching, distance you could see the most enormous tornado winding up. The caption to the poster was simply "Better get the cat in".