Re: WALInsertLock tuning

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WALInsertLock tuning
Date: 2011-10-14 12:34:44
Message-ID: CA+Tgmoas-EUSjfNusHapgJRg8oyqTvh52TeLrVcNn5=Mp8tUaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 13, 2011 at 9:35 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> I assume this was addressed with this commit:
>
>        commit 465883b0a2b4236ba6b31b648a9eabef3b7cdddb
>        Author: Simon Riggs <simon(at)2ndQuadrant(dot)com>
>        Date:   Tue Jun 28 22:58:17 2011 +0100
>
>            Introduce compact WAL record for the common case of commit (non-DDL).
>            XLOG_XACT_COMMIT_COMPACT leaves out invalidation messages and relfilenodes,
>            saving considerable space for the vast majority of transaction commits.
>            XLOG_XACT_COMMIT keeps same definition as XLOG_PAGE_MAGIC 0xD067 and earlier.
>
>            Leonardo Francalanci and Simon Riggs

No, that's completely unrelated. I think it just never quite made it
to prime time - it was analyzed theoretically but some of the testing
discussed on the thread doesn't seem to have been done.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-10-14 12:36:47 Re: about EDITOR_LINENUMBER_SWITCH
Previous Message Fujii Masao 2011-10-14 12:28:29 Re: Online base backup from the hot-standby