[Pgpool-general] replication stability under heavy loads, many connections?
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Dec 22 04:05:46 UTC 2010
Thanks for the info.
Just for record, what kind of error messages or phenomenon you
observed when you say "instability"?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Hello,
> We spotted the cause of instability:
> The pool machines had been previously tuned at their tcp kernel
> parameters for high speed networks.
> One of the tcp parameters tuned caused the problem with pgpool and
> postgresql under heavy loads (backends at 100%):
> tcp_fin_timeout was at only 10 seconds.
> After configuring it to the default linux 60 seconds, the connection
> instability under heavy load disapeared. At least for some days now.
> Regards.
> Andre Felipe Machado
More information about the Pgpool-general
mailing list