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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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