Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGzwr-0004Nv-8m for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 22:19:17 +0000 Received: from moutng.kundenserver.de ([212.227.126.186]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGzwq-0001AZ-6V for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 22:19:16 +0000 Received: from idefix.localnet ([92.90.17.5]) by mrelayeu.kundenserver.de (node=mreu4) with ESMTP (Nemesis) id 0MK8bx-1THolI2jkz-001PFM; Thu, 27 Sep 2012 00:19:14 +0200 To: pgsql-admin@postgresql.org Subject: Re: WAL Log Processing For OLAP? Cc: P R From: =?iso-8859-1?q?C=E9dric_Villemain?= Reply-To: cedric@2ndquadrant.com Organization: 2ndQuadrant Date: Thu, 27 Sep 2012 00:19:11 +0200 X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_f93YQfWImppYsWH" Content-Transfer-Encoding: 7bit Message-Id: <201209270019.11422.cedric@2ndquadrant.com> X-Provags-ID: V02:K0:seIZolCOWhmfQOPbmkhqjHniVRgoaz2SwUpRldlE/e8 ZdAKeVN441SwPL4ibbhrdbhz5s6SQ9vhGfDwuYQto6CYFP8VIi h3RUeiAH0yykFOvApYEmLpCE3wXr/zEBvqismm7XBKy495s6aT kQHngy9VjlZWGiqfmPkgNZt0LU9P2A47JcgfbOc7CGtrlkWgYH f7IUwUFiV74iJ+28tc+u+lQ2EYP9u/bPbSNYfyvYhlDHKZfIBd 80U31ybmtDBsgiCCfRdcxmIuxQzifcmEiKJMXWsNXNz0TRjUEZ ejchb+IQxlMwjmii8Aba8Cl8jOENo+2KesTqj3VxybFGwNNHgf 3XCmCt5efOXY6zIl0cirWK2e8dFuvAHxXSXB2ixX+ X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201209/155 X-Sequence-Number: 40096 --Boundary-01=_f93YQfWImppYsWH Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable > Is there any way to process WAL logs of an OLTP database for use in a wri= table, index heavy, OLAP database? Are there projects out there doing somet= hing similar with the WAL logs? You may be interested by the following 2 posts on pgsql-hacker. Design and = patch about WAL decoding: * http://archives.postgresql.org/message-id/201209221857.44568.andres@2ndqu= adrant.com * http://archives.postgresql.org/message-id/201209150233.25616.andres@2ndqu= adrant.com=20 =2D-=20 C=E9dric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - D=E9veloppement, Expertise et Formation --Boundary-01=_f93YQfWImppYsWH Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

> Is the= re any way to process WAL logs of an OLTP database for use in a writable, i= ndex heavy, OLAP database? Are there projects out there doing something sim= ilar with the WAL logs?

&nb= sp;

You may be = interested by the following 2 posts on pgsql-hacker. Design and patch about= WAL decoding:

* http://ar= chives.postgresql.org/message-id/201209221857.44568.andres@2ndquadrant.com<= /p>

* http://ar= chives.postgresql.org/message-id/201209150233.25616.andres@2ndquadrant.com =

&nb= sp;

--

C=E9dric Vi= llemain +33 (0)6 20 30 22 52

http://2ndQ= uadrant.fr/

PostgreSQL:= Support 24x7 - D=E9veloppement, Expertise et Formation

--Boundary-01=_f93YQfWImppYsWH--