Discussion:
WAL Log Processing For OLAP?
(too old to reply)
P R
2012-09-25 17:19:52 UTC
Permalink
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?

So far all I've found is Xlogdump and Pglesslog
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Cédric Villemain
2012-09-26 22:19:11 UTC
Permalink
Post by P R
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/***@2ndquadrant.com
* http://archives.postgresql.org/message-id/***@2ndquadrant.com
--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
Loading...