Re: WALInsertLock tuning

On Thu, Oct 13, 2011 at 9:35 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> I assume this was addressed with this commit:
>
>        commit 465883b0a2b4236ba6b31b648a9eabef3b7cdddb
>        Author: Simon Riggs <simon@2ndQuadrant.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