Renaud Chaput on Nostr: npub1lyds7…6ykej I would advise against removing postgres indices, even if you ...
npub1lyds7k86y9k6n6fae54wwplp7karas3ckj04jynhcsr350sg46asa6ykej (npub1lyd…ykej) I would advise against removing postgres indices, even if you think they are unused.
If you are convinced they are not used, please open a Github issue with the details and we will look at it.
Some indices are not often used, but exist for a reason and you might get in trouble if they are not there when the code requiring them runs.
Also it is not advised to desync the database structure from what the Rails app expects.
Published at
2024-01-12 23:26:45Event JSON
{
"id": "c04c5e7e06e9805ff783ff79d5240d0d335733b1a178b943610d18c6890f9afa",
"pubkey": "03829910f8ef101978eac32b45ecca43653afa5626b6fdd823e12221d7ffe565",
"created_at": 1705102005,
"kind": 1,
"tags": [
[
"p",
"f91b0f58fa216da9e93dcd2ae707e1f5ba3ec238b49f591277c4071a3e08aebb",
"wss://relay.mostr.pub"
],
[
"p",
"6fd738b561409c3c3ef5f0b47da691a34bfdfa09aac90f548804a83672250adc",
"wss://relay.mostr.pub"
],
[
"e",
"2355d514307adc08a6d01d4fa6e8d1d5917b9e16a5a0b061901a032f3da80467",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://oisaur.com/users/renchap/statuses/111745565020789130",
"activitypub"
]
],
"content": "nostr:npub1lyds7k86y9k6n6fae54wwplp7karas3ckj04jynhcsr350sg46asa6ykej I would advise against removing postgres indices, even if you think they are unused.\nIf you are convinced they are not used, please open a Github issue with the details and we will look at it.\nSome indices are not often used, but exist for a reason and you might get in trouble if they are not there when the code requiring them runs.\nAlso it is not advised to desync the database structure from what the Rails app expects.",
"sig": "26857b24ea4ec1e1b8afefb47f29ecb0cf7da74e56148102ec797026b4c2498c8b948844dcb6820ba7142a8cbd90b36a6e79c72d5402383067374313634bd043"
}