Re: [GENERAL] TSearch2 memory usage

2007-05-21 Thread Hannes Dorbath
On 21.05.2007 11:42, Oleg Bartunov wrote: dictionary is just a program ! Are you usin custom dictionaries ? Depends on what you mean, it's a standard ispell dict, defined as: DictFile="/foo/bar/german_utf8.dict",AffFile="/foo/bar/german_utf8.aff" You can grab both files here: http://falcon.im

Re: [GENERAL] TSearch2 memory usage

2007-05-21 Thread Oleg Bartunov
On Mon, 21 May 2007, Hannes Dorbath wrote: We have a fixed amount of 16 PG backend processes. Once created they stay forever. OLTP load is distributed over them in a SQF fashion. As loading a TSearch dictionary takes a few moments, we have a script that connects to each backend on start up an

[GENERAL] TSearch2 memory usage

2007-05-21 Thread Hannes Dorbath
We have a fixed amount of 16 PG backend processes. Once created they stay forever. OLTP load is distributed over them in a SQF fashion. As loading a TSearch dictionary takes a few moments, we have a script that connects to each backend on start up and pushes the dictionary into ram by simply c