Hi,
I have two questions about PostgreSQL:
1. What happens when the file system on which the pg_xlog directly resides, completely fills up? Does PostgreSQL wait until free space is available again?
2. Our PostgreSQL database (version 8.1.4.) generates almost 20 GB of WAL files per hour! What are the best practices related to administering large amounts of WAL files? Would it be wise to compress the WAL files?
Thanks in advance,
Kind regards,
Omar
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.