Re: recycled transaction log file: too much? - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Tue, 3 Aug 2004, [ISO-8859-1] Hubert Fröhlich wrote:

> when doing a large Insert I get in the logfile:
>
> 2004-08-03 07:23:46 LOG:  recycled transaction log file "000001BA000000BD"

<snip>

> This seems a bit much?! Should I try with different postgresql.conf wal
> settings?

Consider increasing wal_files in postgresql.conf, but anything beyond 5 or
10 may be painful, since each WAL file is 16MB in size.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
            http://www.tdmsoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBD207tl86P3SPfQ4RAhQJAJ0YOBAruxjzvmaxBmgbBmjPE9/zAQCfcY6T
6g58kD+artd1FG7eF9BKZFM=
=DpIw
-----END PGP SIGNATURE-----