recycled transaction log file: too much?

Hi list,

when doing a large Insert I get in the logfile:

2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000BD"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C2"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C3"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C4"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C5"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C6"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C7"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C8"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C1"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000BE"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000BF"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C0"
2004-08-03 07:39:08 LOG: recycled transaction log file "000001BA000000C9"


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

Greetings,

Hubert

--
-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Bezirksfinanzdirektion München
Alexandrastr. 3, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2190 - 2980
Fax :+49 (0)89 / 2190 - 2997
hubert dot froehlich at bvv dot bayern dot de


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

re: recycled transaction log file: too much?

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


Hi,

On Tue, 3 Aug 2004, [ISO-8859-1] Hubert Fröhlich wrote:
[color=blue]
> when doing a large Insert I get in the logfile:
>
> 2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000BD"[/color]

<snip>
[color=blue]
> This seems a bit much?! Should I try with different postgresql.conf wal
> settings?[/color]

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)

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)