> 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?
I mean 4.6GB per day. > This is PostgreSQL 8.2 beta1. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match