Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGzqN-0001Lx-Ne for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 22:12:35 +0000 Received: from acidenitrix.villemain.org ([91.121.90.165]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGzqM-0002sq-86 for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 22:12:35 +0000 Received: from [92.90.17.5] (helo=idefix.localnet) by acidenitrix.villemain.org with esmtpa (Exim 4.72) (envelope-from ) id 1TGzqI-00015A-29; Thu, 27 Sep 2012 00:12:30 +0200 From: =?iso-8859-1?q?C=E9dric_Villemain?= Organization: 2ndQuadrant To: pgsql-admin@postgresql.org Subject: Re: WAL Log Processing For OLAP? Date: Thu, 27 Sep 2012 00:12:28 +0200 User-Agent: KMail/1.13.7 (Linux/3.2.0-3-686-pae; KDE/4.8.4; i686; ; ) Cc: P R References: In-Reply-To: X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_M33YQLMq3REytHy" Content-Transfer-Encoding: 7bit Message-Id: <201209270012.28886.cedric@2ndquadrant.fr> X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201210/1 X-Sequence-Number: 40117 --Boundary-01=_M33YQLMq3REytHy 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=_M33YQLMq3REytHy 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=_M33YQLMq3REytHy--