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

Decreasing WAL size effects

From: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Decreasing WAL size effects
Date: 2008-10-29 02:10:25
Message-ID: (view raw or whole thread)
Lists: pgsql-generalpgsql-hackers
I am planning on setting up PITR for my application. 

It does not see much traffic and it looks like the 16 MB log files 
switch about every 4 hours or so during business hours.
I am also about to roll out functionality to store documents in a bytea 
column.  This should make the logs roll faster.

I also have to ship them off site using a T1 so setting the time to 
automatically switch files will just waste bandwidth if they are still 
going to be 16 MB anyway.

*1.  What is the effect of recompiling and reducing the default size of 
the WAL files?
2.  What is the minimum suggested size?
3.  If I reduce the size how will this work if I try to save a document 
that is larger than the WAL size?

Any other suggestions would be most welcome.

Thank you for your time,

Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
HJBug Founder and President  

In response to


pgsql-hackers by date

Next:From: SureshDate: 2008-10-29 03:16:33
Subject: Checking stack depth
Previous:From: Alvaro HerreraDate: 2008-10-29 01:37:15
Subject: Re: PostgreSQL + Replicator developer meeting 10/28

pgsql-general by date

Next:From: x asasaxaxDate: 2008-10-29 02:36:12
Subject: Problem with sql
Previous:From: Tom LaneDate: 2008-10-29 01:16:20
Subject: Re: UUID-OSSP Contrib Module Compilation Issue

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