> 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.and...@2ndquadrant.com * http://archives.postgresql.org/message-id/201209150233.25616.and...@2ndquadrant.com -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation
