RE: Storage Manager (was postgres 7.2 features.)

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Chris Bitmead'" <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
Cc: pgsql-hackers(at)hub(dot)org
Subject: RE: Storage Manager (was postgres 7.2 features.)
Date: 2000-07-11 18:26:04
Message-ID: 8F4C99C66D04D4118F580090272A7A23018C51@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Also, does WAL offer instantaneous crash recovery like no-overwrite?

No, but it offers < 1 fsync per commit, instead of fsyncing every
changed table/index...
+ rollback changes of aborted transactions.

And, btw, WAL can live with non-overwriting smgr without problem -
why do you oppose them?

Also, try to power off while inserts into table with indices -
indices will be broken...

Vadim

Browse pgsql-hackers by date

  From Date Subject
Next Message Prasanth A. Kumar 2000-07-11 18:46:23 Re: Slashdot discussion
Previous Message Mikheev, Vadim 2000-07-11 18:19:05 RE: postgres 7.2 features.