Siddharth Shah wrote: > I am not using wall based replication ? I no not have frequent & long > transaction , need of checkpoints > Just want to get what data resides in pg_xlog that it takes 16MB without > any transactions. The files are created 16MB long, it is faster to overwrite that than to keep extending a shorter file. Since the WAL is written to with every transaction it needs to be fast. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general