Shari Vegas :windmill_of_friendship: :1488: on Nostr: #[0] your dataset backing postgres should already be running lz4, no need to ...
sjw (npub13ar…35hu) your dataset backing postgres should already be running lz4, no need to double-up on that work
VACUUM FULL doesn’t cause the same issue, because it’s not doing anything outside of the database like pg_repack does. Of course, the drawback is the exclusive locks required to finish the job.
Published at
2023-04-17 18:00:37Event JSON
{
"id": "c5ea7e0ede323441fef3dcbb66f626a42732a79f6cf8bfe7b5163994ceec52f9",
"pubkey": "e4769a394a68e04a6550cd793ea2f27628a4af204b3e2504ad8e09ecab8ba584",
"created_at": 1681754437,
"kind": 1,
"tags": [
[
"p",
"8f4718bd8fa877fb11cb6b01b03e9f3ed4b265850b5ba71224249ceb6e87aa61",
"wss://relay.mostr.pub"
],
[
"e",
"4105282ef6abc6bfc285f2f74c19d2ed5d8a14f178d5d820e5d34881d97bfdfd",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://pleroma.nobodyhasthe.biz/objects/721968fb-39f9-433a-8e1d-7b322327e5b5"
]
],
"content": "#[0] your dataset backing postgres should already be running lz4, no need to double-up on that work\n\nVACUUM FULL doesn’t cause the same issue, because it’s not doing anything outside of the database like pg_repack does. Of course, the drawback is the exclusive locks required to finish the job.",
"sig": "21c521303ff1ac5b2b9b56f45ee4cdeb7ab8f8d16637646ddb1308bf416fd059a60b857f273506e8e3aa26035305baa6fd9eecc4437dfd432fecc8c6ffeb2f13"
}
