Re: turning of pg_xlog - Mailing list pgsql-admin

From Chander Ganesan
Subject Re: turning of pg_xlog
Date
Msg-id 48E26C60.3060307@otg-nc.com
Whole thread Raw
In response to turning of pg_xlog  (Jonny <blubb@terminalschmiede.de>)
Responses Re: turning of pg_xlog  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Jonny wrote:
> Hi,
>
> I have installes Postgres 8.0.15 on a embedded Linux and have only 130
> MB for Postgres.
> Is it possible to turn off the comlete (Wal) pg_xlog? Because this is
> the biggest part.
> I found an Entry how to minimize the count of stored xlogs.
> Is it possible to store it  to /dev/null or something else?
> Something like ln -s /dev/null  pg_xlog/ (I know this does not work
> :-) ....
You should also understand that if you set checkpoint_segments to a
small number, its still possible that PostgreSQL might use more than
that number for a large transaction.  As such, be careful about limiting
the space available to your xlogs, lest it cause transactions to fail
due to insufficient space for the xlogs.

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
http://www.otg-nc.com


pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: What process clears the logs?
Next
From: Tom Lane
Date:
Subject: Re: turning of pg_xlog