Best practice
Now that 7.1 has arrived, I would appreciate some feed back on the
following comments.
We use Ingres where I work and when setting up a server we always
try to ensure that the log and data files are on different spindles.
From both experience and advice from CAI, one can always recover a
database after a hardware failure or system crash, if any two of the
following are in good condition
Backup, Logfile, Datafiles.
I know that PostgreSQL isn't Ingres but there must be some useful
experiences from both experts and users alike. Is there any recommended
'placement' for the respective postgresql files.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015
Import Notes
Reply to msg id not found: 200104192210.f3JMAO358845@postgresql.org
What would the the best choice for the WAL mirroring, raid3
or 5. How big does the WAL grow? mirroring is fine as long
as the size isn't too big.
1. For each transaction that made some updates to DB
all log records must be available.
2. Server removes "old" (see 1.) 16Mb log files only at
checkpoint time (each ~300 sec by default).
So, in the system with low update rate/short update TX
there will be only 1 - 2 16Mb log files at any time.
Vadim
Import Notes
Resolved by subject fallback