GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE

  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Embed Notice

HTML Code

Corresponding Notice

  1. Embed this notice
    Matt Baer (matt@writing.exchange)'s status on Friday, 11-Aug-2023 23:31:14 JSTMatt BaerMatt Baer

    I'm looking for a little help working through some database scaling issues with #WriteFreely.

    On our Write.as instance, we're up to 4.25 million rows in our `posts` table, and it's causing problems for some individual blogs with 9,000+ posts.

    I have an idea of what some bottleneck queries are. But wondering if there are easy db optimizations we might make (indexes, etc.), and if anyone can help identify what they might be.

    Boosts appreciated!

    In conversationFriday, 11-Aug-2023 23:31:14 JST from writing.exchangepermalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: cdn.writeas.net
      Write.as
      Simple writing platform built to preserve and spread your words. Start writing and publishing now — no signup required.
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.