Re: Will modifications to unlogged tables also be flused to disk?

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Will modifications to unlogged tables also be flused to disk?
Date: 2014-02-15 11:58:21
Message-ID: CAKoxK+7HTtMipHCPSyxHa32_M8z9wFTn1GmeufgcXY7iwV7DmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Feb 15, 2014 at 12:38 PM, Clemens Eisserer <linuxhippy(at)gmail(dot)com> wrote:
> Ok thats really bad news :/
> After reading the discussion about calling unlogged tables "in memory"
> or "cached" I actually had high hopes pgql would take advantage of the
> fact that data of unlogged tables are not preserved at recovery.

Sorry, I could be misunderstanding here, but if the final aim is to
reduce the writes, why not tweaking wal settings and checkpoints? I
mean, is it possible to find a good solution or you need a kind of in
memory storage?

Luca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Eisserer 2014-02-15 13:16:50 Re: Will modifications to unlogged tables also be flused to disk?
Previous Message Andres Freund 2014-02-15 11:47:57 Re: Will modifications to unlogged tables also be flused to disk?