Re: Newbie question about pg_xlog - Mailing list pgsql-admin

From Tom Lane
Subject Re: Newbie question about pg_xlog
Date
Msg-id 18601.1035295863@sss.pgh.pa.us
Whole thread Raw
In response to Newbie question about pg_xlog  ("Stein, Jochen" <J.Stein@secunet.de>)
List pgsql-admin
"Stein, Jochen" <J.Stein@secunet.de> writes:
> I just set up a little test database and i asked myself why this
> pg_xlog-directory has already 33MBs and is still growing.

Because the xlog is allocated in units of 16Mb.  If you're talking
about a low-traffic database, the xlog probably won't get larger than a
couple of files.  (You can tweak the WAL configuration parameters to
determine this, see the Admin Guide.)

            regards, tom lane

pgsql-admin by date:

Previous
From: "Igor Georgiev"
Date:
Subject: Security question : Database access control
Next
From: dima
Date:
Subject: Re: Security question : Database access control