Lamp on Nostr: advantage of using separate database servers in each docker compose: if u dump and ...
advantage of using separate database servers in each docker compose: if u dump and restore postgres database it seems it has to reindex everything which takes a really long time, when u could have just copied the raw postgres files and be done already.
disadvantage: u can't pgtune them to use the same memory space for optimal performance
Published at
2024-09-12 06:48:23Event JSON
{
"id": "6a4aecb57f67c1006a679fc4c150d5858303ea97ef443fdb9c50ba3b2f81f651",
"pubkey": "69c8971d2ad8c30a72bfc719a9941383205e7e0b274365dac90bdcccdf20ed5d",
"created_at": 1726123703,
"kind": 1,
"tags": [
[
"proxy",
"https://kitty.haus/objects/75e1838d-d915-451a-861b-5f2bfefd5746",
"activitypub"
]
],
"content": "advantage of using separate database servers in each docker compose: if u dump and restore postgres database it seems it has to reindex everything which takes a really long time, when u could have just copied the raw postgres files and be done already.\n\ndisadvantage: u can't pgtune them to use the same memory space for optimal performance",
"sig": "fb52884f53ccde9d559c7167177918a651e139c4cabf341b7fa663d0e5d3382ce5226598aa1f590524553dab0cdd6314aa112889f9fd75df37188deb5be8e389"
}