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: 4907C611.2060008@supernovasoftware.com (view raw or flat)
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
http://www.octgsoftware.com
HJBug Founder and President
http://www.hjbug.com  


In response to

Responses

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-2014 The PostgreSQL Global Development Group