You are reading a single comment by @Aroogah and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Aroogah
It may be time to set up another PostgreSQL server and then use replication make it a slave, and read only off of the slave whilst writing only to the master.
Right now the topology is simple: There's one big server.
I probably need to revisit that, but know that it involves re-working some of the code as permissions stuff does implicit writes to cache tables which means my reads are actually writes in some instances.