> 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.
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-09-30 18:44:38|
|Subject: Re: turning of pg_xlog |
|Previous:||From: Carol Walter||Date: 2008-09-30 16:31:36|
|Subject: What process clears the logs?|