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
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 |
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 |