ZFS melting under postgres...

[Dag-Erling Smørgrav]

Doug Rabson <dfr at rabson.org> writes:
> Dag-Erling Smørgrav <des at des.no> writes:
> > David Duchscher <daved at tamu.edu> writes:
> > > So does anybody know of a battery backed NVRAM card that can be used
> > > with FreeBSD that the ZIL could be offloaded to?
> > Any CF card or similar will do.  You don't need battery backup for
> > flash memory.
>
> THis may also have to wait for a future version of ZFS. I remember
> reading about this kind of thing as an upcoming feature in Solaris. I
> believe the way this feature would work is that ZFS would allow creating
> the ZIL on a different pool to the filesystem - i.e. create a zpool on
> the CF card and get the ZIL to live there.

AFAIK this is already implemented in ZFS, though I'm not sure Pawel has
merged it into FreeBSD yet.

Note that you can also get disk drives with a certain amount of NAND
flash built-in, but FreeBSD doesn't support that yet.

DES
-- 
Dag-Erling Smørgrav - des at des.no