Using PostgreSQL 8.4/CentOS 6: if I set the
archive_mode parameter to
postgresql.conf, but don't actually store the generated WAL files anywhere via the
archive_command parameter, is there any performance impact?
This is for testing the potential for use of WAL archiving on a high-throughput production server: I'm hoping to set
on, and set
archive_command to something like
echo `date` %f %p >> archive_log.txt
so that I can monitor how many WAL files would get created during a given time period without actually copying them and risking disk space overruns. Will this affect my server's performance in any way?