separate the Postgres WAL by schema?

605 views Asked by At

I can't seem to find anything related to what I am trying to do. Is it possible to separate the Postgres WAL files by schema?

1

There are 1 answers

1
jjanes On BEST ANSWER

No, it is not possible. Not only can't it be separated by schema, it also can't be separated by database either, within the same cluster/instance.

To get separate WAL streams, you would have to run different database instances listening on different ports, with either dblink or foreign data wrappers. And then you would have problems with atomicity of commits.