pnorman left a comment (openstreetmap/openstreetmap-website#7111)
> In general I'm neutral on this idea. I've read the operations task and I
> haven't seen convincing evidence that this is the best way to solve the
> operational problems
We discussed splitting the DBs on the ops call and talked about moving the
traces to the old DB servers. The only other gain from splitting would be that
we could have different cluster-level settings and WAL/basebackup
It doesn't add anything new to pg_dump since that can already exclude tables.
Personally I'm not convinced this is the biggest trace problem. The API results
in ORDER BY ... OFFSET ... queries which are horrible for performance.
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/7111#issuecomment-4574447359
You are receiving this because you are subscribed to this thread.
Message ID:
<openstreetmap/openstreetmap-website/pull/7111/[email protected]>
_______________________________________________
rails-dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/rails-dev
