sjw

Fucking hell! I just broke my phone. FUCK!!!! I really don't have money for this! :angry_cry:
This whole fucking weekend is fucking ruined now. God fucking damn it!
I at least have insurance on it but I don't fucking have $200 to spend for the copay. I literally only have $180 in the bank until week after next and I still have bills coming up and groceries that I need to buy so It'll be some time before I'm able to afford it. However, I also need my phone for work so I don't know what I'm going to do. God fucking damn it! I fucking finally felt like shit was starting to get on track and now this.
Fuck.
I'll keep working on getting Baest back up but I probably won't be on for a while. I just want to be alone right now. I guess I'll eventually have to figure out what to do but I can't right now. Sorry everyone.
https://i.poastcdn.org/726ddc2f99d757cff17b625d21eb5e876b158c56b588d3d512b44a04105bc2bc.jpg

2023-07-01 21:40:54

- reply

Then what flavour is her milk?

2023-07-01 21:39:30

- reply

Imagine having sex with her

2023-07-01 15:40:36

- reply

Everything should automatically restart once it's done so I'm going to go to sleep finally.
Good night fedi! Hopefully once I wake up Baest will be back.
https://i.poastcdn.org/a9207d4c2a777c551a71b76cacb130c4baddb04e489087b043d454ef547b2cf1.jpg

2023-07-01 15:38:05

Baest will be back in a few hours

2023-07-01 08:13:23

I know Baest is down.
I'm working on it.
It should be back up tomorrow.

2023-04-20 19:37:37

- reply

I'm going to have to look into better ways to dump the database.
Actually, the thing that's fucking me is restoring the data and then adding the indexes so now all of that data has to be indexed.
It'd be much more efficient if I restored all of the schema and then loaded the data that way the data could get indexed while its loaded.
Why is that not the default order postgres writes a dump?
https://i.poastcdn.org/df7bb3dc8e6babb9c3c65d0ba6e243b4a93d736e44b0be5c5e227451713ce9e8.png

2023-04-18 03:56:15

- reply

Kek

2023-04-17 18:16:26

- reply

Default toast compression is PGLZ but lz4 was added in 14
Lz4 gives around 5%~10% worse ratios but is over twice as fast.
Unless you want to use something like zstd for disk there's little reason to go through the hassle of disabling toast compression all together (IIRC can only be set at compile time) as lz4 in ZFS will quickly see the already compressed data isn't worth compressing so it won't even try.
Setting it to lz4 should work about as well as not setting it at all and using lz4 in ZFS.

2023-04-17 17:56:13

- reply

Ah so same issue then.
Even a vacuum full didn't fix it. I wonder if vacuum full would cause the same issue.
Silver lining is with this dump I can disable toast compression commands in the dump so I can easily switch everything to lz4 that was added in 14 for better performance.

2023-04-17 17:39:32

- reply

Was your postgres throwing stuff like
```
could not open file "base/200840/76617308.32" (target block 5592): previous segment is only 4339 blocks
2023-04-16 15:48:20.903 UTC [3861552] baest@baest STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
```
That's what my issue is.

2023-04-17 17:01:35

- reply

Or is the pg_repack the reason things are fucked? I don't really see how but I've seen stranger.

2023-04-17 16:58:05

- reply

I use Fran for CDN but backend is in my closet.
This all started because I accidentally unplugged the drive while postgres was running.
Any particular reason to not use pg_repack?

2023-04-17 16:49:53

- reply

I am

2023-04-17 16:03:59

Well fuck looks like I didn't fix the database
Okay, I guess I'll just have to dump the database, drop it, and then restore it.

2023-04-16 17:40:52

- reply

Yeah same issue sadly.
Hopefully this vacuum full will fix it.

2023-04-16 17:39:51

Okay currently doing a vacuum full
If that doesn't work I'm going to have to dump and re-import the database.

2023-04-15 18:30:08

Baest should be back in the next 2 hours
Sorry for the downtime

2021-12-03 21:44:24

@npub108z…dkr5 it's #FutaFriday!
https://i.poastcdn.org/e437e0727541f6a4dd2d2b064346673385201fb39f2ae76bd4b6d6cc577a53d3.png

2021-11-29 19:28:29

#ａｅｓｔｈｅｔｉｃ
https://i.poastcdn.org/2b06ef81f6c9ba7387b3cf773ea7e9317b998f177191be6514a0ae580f8e4943.gif

2021-11-16 15:57:32

bae.st