From: Dimitri Fontaine <dfontaine@hi-media.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dave Page <dpage@pgadmin.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL as a local in-memory cache
Date: Thu, 24 Jun 2010 10:25:23 +0200
Message-ID: <87sk4cu9ak.fsf@hi-media-techno.com> (raw)
In-Reply-To: <27712.1277325786@sss.pgh.pa.us>
References: <24597.1276803510@sss.pgh.pa.us>
<201006231937.o5NJbKp05127@momjian.us>
<AANLkTikTFG8-4sfJsQ16Fdu1TzZOh_zUtb-QuBPuo9jF@mail.gmail.com>
<AANLkTimxDE1PRSaIhLFqRfaXoG7zxbDNH9mQO4aK4Kkt@mail.gmail.com>
<27712.1277325786@sss.pgh.pa.us>
Tom Lane <tgl@sss.pgh.pa.us> writes:
> The problem with a system-wide no-WAL setting is it means you can't
> trust the system catalogs after a crash. Which means you are forced to
> use initdb to recover from any crash, in return for not a lot of savings
> (for typical usages where there's not really much churn in the
> catalogs).
What about having a "catalog only" WAL setting, userset ?
I'm not yet clear on the point but it well seems that the per
transaction WAL setting is impossible because of catalogs (meaning
mainly DDL support), but I can see us enforcing durability and crash
safety there.
That would probably mean that setting WAL level this low yet doing any
kind of DDL would need to be either an ERROR, or better yet, a WARNING
telling that the WAL level can not be that low so has been raised by the
system.
Regards,
--
dim
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: dfontaine@hi-media.com, tgl@sss.pgh.pa.us, dpage@pgadmin.org, robertmhaas@gmail.com, bruce@momjian.us, josh@agliodbs.com
Subject: Re: PostgreSQL as a local in-memory cache
In-Reply-To: <87sk4cu9ak.fsf@hi-media-techno.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