I am genuinely curious how a ZFS "special" device[1] which absorbs all metadata for a pool would help this kind of a workload.
The "special" device is a full-blown vdev that you add to a pool (it is not a cache) - typically a 3 or 4-way mirror of SSDs.
Now all metadata read and write happen at SSD speeds.
We wrote about this in the rsync.net Technical Notes for Q3 of this year[2].
I know what this kind of SSD based vdev does to typical mixed file performance but I'm not sure how metadata-heavy a postgres implementation is ...
[1] Yes, they really are called that.
[2] https://www.rsync.net/resources/notes/2021-q3-rsync.net_tech...