Amos Shapira wrote:
On 21/02/07, *Tzahi Fadida* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Depends. Sometimes queries takes longer. However it is not the point.
The reason for backupping once in a while is for PITR - point in
time recovery
which is a new facility in PostgreSQL 8+. I am not an expert on this
subject
but IIRC, imagine you backupped the database at 8am. At 9am the database
crashed. The data at the database is too corrupt due to various insane
reasons you can conjure in your mind. However, the transaction log
survived.
It turns out, it kept all the transactions back to 8am when you
backed up your
database. YAY!, you can basically rerun all the transactions from
that time
using the log and reconstruct the database.
Hmm, I see your point.
How about creating a RAID 1 (mirror) volume with that "disk" as one of
its sides? That way you get automatic instant backup. I assume the write
to the RAID will be as fast as the fastest side.
--Amos
what? what???? a mirror is as _slow_ as the _slower_ disk. an I/O
request to the mirror, gets a response only after its clones were
written into both legs of the mirror - not as soon as one was written.
--guy
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]