Yes it is how we run it in production and sadly it’s not great.
On my own laptop I’ve found it to be maybe 85% or so as quick as normal single mode Postgres. That said things aren’t great when the storage layer is doing consensus and replication and then the database is as well.
Comments
Pro-tip: if at all possible do not run this on top of Ceph. Bare metal SSDs or VMs with SSDs.
That's normal advice for any database or system that does it's own data replication. Having multiple distributed storage layers never works out well.
From experience I take it? Was Ceph running on any of those?
Yes it is how we run it in production and sadly it’s not great.
On my own laptop I’ve found it to be maybe 85% or so as quick as normal single mode Postgres. That said things aren’t great when the storage layer is doing consensus and replication and then the database is as well.