The above is your problem. Make checkpoint_timeout = 1h . Also, considering turning synchronous_commit off.
JD
Thiis valid regardless of the workload? Seems that I would be storing a ton of data and writing it once an hour, so would have potential perf hits on the hour. I guess I'm not too up to date on the checkpoint configuration.