Skip site navigation (1) Skip section navigation (2)

pg_xlog and the WAL files

From: "Achakzai, Omar" <omar(dot)achakzai(at)logicacmg(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_xlog and the WAL files
Date: 2007-02-16 11:10:11
Message-ID: FCE7AD9975BC4B4E89E2F4EF6049F69201148FBF@nl-ex020.groupinfra.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

Responses

pgsql-admin by date

Next:From: Chad WagnerDate: 2007-02-16 11:34:12
Subject: Re: WAL files backup
Previous:From: Eduardo J. OrtegaDate: 2007-02-16 03:35:55
Subject: Re: WAL files backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group