From: | Hubert Fröhlich <hubert(dot)froehlich(at)bvv(dot)bayern(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | recycled transaction log file: too much? |
Date: | 2004-08-03 08:56:21 |
Message-ID: | 410F5335.4050502@bvv.bayern.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Prabu Subroto | 2004-08-03 09:54:50 | dropping a rule find an error |
Previous Message | Gellert, Andre | 2004-08-03 08:41:56 | Are Packages for PostgreSQL 7.4.x for Solaris 9 64bit available ? |