However, Postgres doesn't have good support for creating derived append-only logs ????
A one line trigger will give you derived append only log that is transactionally consistent.
are talking about creating a new table or materialised views or stored procedures or...?