Re: Acclerating INSERT/UPDATE using UPS

Bruce,

Thanks for your comments, and let me answer to your question.
Sigres is *not* significantly faster than just creating a file system on
the permanent memory and putting xlog on there.
Sigres is slightly faster than the case because each backend does not
call XLogWrite while bgWriter does.

-- Hideyuki

Bruce Momjian wrote:
> Tom Lane wrote:
>
>> Gene <genekhart(at)gmail(dot)com> writes:
>>
>>> ... just my two cents. on a side note, would putting the wal on a
>>> tmpfs partition give you something similar?
>>>
>> Indeed, I'm wondering why one needs to hack the Postgres core to throw
>> away data integrity guarantees; there are plenty of ways to do that
>> already :-(. Hideyuki-san has not explained exactly what integrity
>> assumptions he wants to make or not make. I'm surely willing to listen
>> to supporting a different set of assumptions than we currently use, but
>> I'd like to see a clear explanation of what assumptions are being made
>> and why they represent a useful case.
>>
>
> I am unsure why Sigres is significantly faster than just creating a file
> system on the permanent memory and putting xlog on there.
>
>