Unless this is about reads exclusively I would start with putting wal on
ssd.
What you might also do, is create separate filesystems (lvm). You can then
keep track of io with iostat per filesystem and see what would benefit
most. And see storage size usage also.
And you could use lvm to move filesy
Hi D.J.,
Hope this helps.
Generally, I tend to think of it like there are three separate features
provided by connection poolers:
Connection pooling, where you are trying to save connection overhead
Offloading read-only queries to standby’s
Delivering transparent client failover, where you can f
