Thread: WAL Log Processing For OLAP?
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
> 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
> 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