| From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Hubert Fröhlich <hubert(dot)froehlich(at)bvv(dot)bayern(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: recycled transaction log file: too much? |
| Date: | 2004-08-03 10:47:21 |
| Message-ID: | Pine.LNX.4.44.0408031344430.24680-100000@emo.org.tr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yoursoft@freemail.hu | 2004-08-03 12:05:08 | User locking |
| Previous Message | Holger Klawitter | 2004-08-03 10:28:02 | Re: dropping a rule find an error |