If archive_timeout is set to non 0, it seems an archive log segment is created every time checkpoint occurs even there's no database updation. This leads to creating 16MB log segment files every 5 minutes (default checkpoint period), which will in turn produce 4.6GB log segments with bogus data. Is this normal?
This is PostgreSQL 8.2 beta1. -- Tatsuo Ishii SRA OSS, Inc. Japan ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend