Thread: WAL Log Processing For OLAP?

WAL Log Processing For OLAP?

From

P R

Date:

25 September 2012, 20:19:59

Is there any way to process WAL logs of an OLTP database for use in a writable, index heavy, OLAP database? Are there
projectsout there doing something similar with the WAL logs? 

So far all I've found is Xlogdump and Pglesslog

Re: WAL Log Processing For OLAP?

From

Cédric Villemain

Date:

27 September 2012, 01:19:17

> Is there any way to process WAL logs of an OLTP database for use in a writable, index heavy, OLAP database? Are there projects out there doing something 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@2ndquadrant.com

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

Cédric Villemain +33 (0)6 20 30 22 52

http://2ndQuadrant.fr/

PostgreSQL: Support 24x7 - Développement, Expertise et Formation

Re: WAL Log Processing For OLAP?

From

Cédric Villemain

Date:

01 October 2012, 20:52:36

> Is there any way to process WAL logs of an OLTP database for use in a writable, index heavy, OLAP database? Are there projects out there doing something 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@2ndquadrant.com

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

Cédric Villemain +33 (0)6 20 30 22 52

http://2ndQuadrant.fr/

PostgreSQL: Support 24x7 - Développement, Expertise et Formation