Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> writes: > I seem to get alot of these: > May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename file > "pg_xlog/archive_status/000000010000000000000001.ready" to > May 17 21:34:04 discord postgres[20573]: [5-2] > "pg_xlog/archive_status/000000010000000000000001.done": No such file or > directory That seems odd ... > Currently I'm using pgbench to generate WAL rollover, do you guys have any > other handy testing tools for this sort of job or is this the best tool? pgbench seems like an OK load for this, although it doesn't start/end any new connections while running. I *think* that that's not critical --- my guess is that your observation of new connections hanging is just because each new connection has to run one startup transaction, and transactions in general are at risk of hanging --- but that could be wrong. Also, you could increase the rate of WAL generation by decreasing the checkpoint segments/timeout parameters, if you need to. regards, tom lane
