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 wpow...@indracompany.com 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

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

2014-12-01 Thread Tom Lane
Eduardo Morras emorr...@yahoo.es writes: Powrie, William wpow...@indracompany.com 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

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

[GENERAL] Ever increasing pg_clog disk usage v8.4

2014-11-30 Thread Powrie, William
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 startup from the /inittab/rc script and nearly