Question about "<news>/db/history" file size

[Petr Novopashenniy]

Hi, Jeffrey!

On Wed, 22 Apr 2009, Jeffrey M. Vinocur wrote:

JMV> On Tue, 21 Apr 2009, Petr Novopashenniy wrote:
JMV> 
JMV> > What was the maximum size of your "<news>/db/history" file in production 
JMV> > environment? How many GBytes?
JMV> 
JMV> I'm not sure what you're asking here.
JMV> 

Maybe.. Where better place?

JMV> The history file is about 10,000 articles per MB, so you should be able to
JMV> predict how big it will get depending on your feed settings and so on.  If 
JMV> you double your retention time, it will approximately double, and so on.  
JMV> (Don't forget the /remember/ time in expire.ctl, if you have articles that 
JMV> are retained for short times.)

Yes, you are certainly right. But I am more interested in the practical 
side of the issue. With something like this success story: "my history 
file size is ~20 GBytes, daily expire process uses ~5 GBytes of memory 
(and works ~1 hour), no problem".


JMV> -- 
JMV> Jeffrey M. Vinocur
JMV> jeff at litech.org

--pety