From: Tobias Brox <tobias@nordicbet.com>
To: Erik Jones <erik@myemma.com>
Cc: depesz@depesz.com, "Kathirvel, Jeevanandam" <Jeevanandam.Kathirvel@honeywell.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disable WAL completely
Date: Mon, 18 Feb 2008 17:49:07 +0100
Message-ID: <20080218164907.GS9596@mail.nordicbet.com> (raw)
In-Reply-To: <3C31118E-D5EB-4F3A-ACB8-50F17F195EA5@myemma.com>
References: <EB493C98A0338748AA3D997E071B0574601DA4@IE10EV813.global.ds.honeywell.com>
<20080218091940.GA7820@depesz.com>
<EB493C98A0338748AA3D997E071B0574601DED@IE10EV813.global.ds.honeywell.com>
<20080218093240.GA8568@depesz.com>
<3C31118E-D5EB-4F3A-ACB8-50F17F195EA5@myemma.com>
[Erik Jones]
> Right. Without the xlog directory you'll have very little chance of
> ever doing any kind of clean stop/start of your database. If you
> don't need the reliability offered by Postgres's use of transaction
> logs you'll probably be much better served with a different database
> or even a completely different storage scheme than trying to make
> Postgres fit that bill.
We actually have some postgres databases that are read-only, others that
can be rebuilt by a script or from some old backup, and yet others that
can be wiped completely without ill effects ... and others where we
would prefer to keep all the data, but it would be no disaster if we
lose some. Maybe we would be better off not using postgres for those
purposes, but it's oh so much easier for us to stick to one database
system ;-)
We've considered both running postgres from a ram-disk and to have the
fsync turned off for some of our databases, but right now we're running
all off one host, fsync didn't reduce the performance that much, and
after one disasterous power failure we considered that it was not worth
the effort to have fsync turned off.
That being said, postgres is probably not an optimal solution for an
embedded system running on flash memory ;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tobias@nordicbet.com, erik@myemma.com, Jeevanandam.Kathirvel@honeywell.com
Subject: Re: Disable WAL completely
In-Reply-To: <20080218164907.GS9596@mail.nordicbet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox