Re: [GENERAL] Ever increasing pg_clog disk usage v8.4

2014-12-01 Thread Adrian Klaver
On 11/30/2014 04:34 PM, Powrie, William wrote: Hello, I have a simple database with just a few tables that runs on an embedded Linux system 2.6.31.8. The OS including postresql 8.4 is loaded directly from cf-flash media and is not saved in any way across power recycles. It is always created at s

Re: [GENERAL] Ever increasing pg_clog disk usage v8.4

2014-12-01 Thread Tom Lane
Eduardo Morras writes: > "Powrie, William" wrote: >> The files in pg_clog increase on a day to day basis until the ramdisk >> reaches 100% utilization. This takes roughly 30 days to occur and >> postgresql fails at this point. > pg_clog stores information about current commit status for open/act

Re: [GENERAL] Ever increasing pg_clog disk usage v8.4

2014-12-01 Thread Eduardo Morras
On Mon, 1 Dec 2014 01:34:14 +0100 "Powrie, William" wrote: > Hello, > > I have a simple database with just a few tables that runs on an > embedded Linux system 2.6.31.8. The OS including postresql 8.4 is > loaded directly from cf-flash media and is not saved in any way > across power recycles. It