"Thorne, Francis" <thornef@xxxxxxxxxxxxxx> wrote: > I plan to place the database files on one RAID 10 partition and the > logs on another partition either RAID 10 or RAID 1. At the moment > though I'm struggling to size the partition of the log file. Is > there a recommendation to how I could go about sizing this > partition? It sounds to me like you're talking about the Write Ahead Log (WAL) files, right? If so, on this page: http://www.postgresql.org/docs/8.4/interactive/wal-configuration.html The docs say: "There will always be at least one WAL segment file, and will normally not be more than (2 + checkpoint_completion_target) * checkpoint_segments + 1 files. Each segment file is normally 16 MB (though this size can be altered when building the server). You can use this to estimate space requirements for WAL." -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
