pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Files in pg_xlog 2+ messages / 2 participants [nested] [flat]
* Files in pg_xlog @ 2004-01-29 20:27 Daniel Henrique Debonzi <debonzi@gwyddion.com> 2004-01-31 05:27 ` Re: Files in pg_xlog Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Daniel Henrique Debonzi @ 2004-01-29 20:27 UTC (permalink / raw) To: pgsql-admin Hi everybody! Does anybody knows how can I change the size (something about 4Mb) of the files inside the pg_xlog directory and how can I have no more than one file inside it. Would be nice a quick explanation about the efects of it. Thanks for all -- Daniel Henrique Debonzi Linux user number 166903 Gwyddion Embedded Free-Software Development www.gwyddion.com São Carlos, São Paulo Brazil ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Files in pg_xlog 2004-01-29 20:27 Files in pg_xlog Daniel Henrique Debonzi <debonzi@gwyddion.com> @ 2004-01-31 05:27 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-01-31 05:27 UTC (permalink / raw) To: Daniel Henrique Debonzi <debonzi@gwyddion.com>; +Cc: pgsql-admin Daniel Henrique Debonzi <debonzi@gwyddion.com> writes: > Does anybody knows how can I change the size (something about 4Mb) of > the files inside the pg_xlog directory You can't, short of hacking the source code (and I'm not sure it's a one-line change if you do...) > and how can I have no more than one file inside it. Can't do that either. In a low-traffic database you could reasonably expect to have no more than two xlog files most of the time. Set checkpoint_segments to 1 to minimize the space usage. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-31 05:27 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-01-29 20:27 Files in pg_xlog Daniel Henrique Debonzi <debonzi@gwyddion.com> 2004-01-31 05:27 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox