Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Michael P. <mic...@gm...>]

On Thu, May 1, 2014 at 7:45 PM, Juned Khan <jkh...@gm...> wrote:
> what will be the impact if i remove files under pg_xlog directory ?
>
> root@db02:/home/postgres/pgxc/nodes/dn_master/pg_xlog# du -sh
> 33G     .
Don't do it. This is one of the shortest way to corrupt your database
server. You have here something like 2050 WAL files, that's a lot to
replay in case of crash, you should try to reduce checkpoint_segments
first, or enforce a checkpoint to flush all the pages to disk, and be
able to recycle properly the existing WAL files.
-- 
Michael