Re: [GENERAL] Where to configure pg_xlog file-size?

2010-04-13 Thread Tom Lane
Clemens Eisserer linuxhi...@gmail.com writes: Is there anything I can do to lower the size of those two files? Well, if you were using 8.4 you could fool with configure's --with-wal-segsize option. Since you're not, look into src/include/pg_config_manual.h. In either case, expect to do a full

Re: [GENERAL] Where to configure pg_xlog file-size?

2010-04-13 Thread Clemens Eisserer
Hello again, Well, if you were using 8.4 you could fool with configure's --with-wal-segsize option.  Since you're not, look into src/include/pg_config_manual.h.  In either case, expect to do a full recompile and initdb after changing it. Good to know - I plan to upgrade to 8.4/9.0 anyway. I

[GENERAL] Where to configure pg_xlog file-size?

2010-04-12 Thread Clemens Eisserer
Hi, I am using postgres-8.3 on an embedded ARM9 system. Works pretty well, except for stoarge consumptions. The actual table data is rather small, but postgres creates 2 16mb files in pg_xlog: r...@mesrv:/var/lib/postgresql/8.3/main# ls -la pg_xlog/ total 32820 -rw--- 1 postgres postgres

Re: [GENERAL] Where to configure pg_xlog file-size?

2010-04-12 Thread Thomas Kellerer
Clemens Eisserer wrote on 12.04.2010 23:25: Hi, I am using postgres-8.3 on an embedded ARM9 system. Works pretty well, except for stoarge consumptions. The actual table data is rather small, but postgres creates 2 16mb files in pg_xlog: r...@mesrv:/var/lib/postgresql/8.3/main# ls -la pg_xlog/