> My dream would be to switch Postgres to main memory or column store mode, but I guess that's not happening very soon :)

If it can be done besides the traditional architecture, be it in a fork or without touching existing code; and if you can at least start the work, it could happen soon.