Posts
49
Following
10
Followers
19
I'm a bit of an eclectic mess ๐Ÿ™‚ I've been a programmer, journalist, editor, TV producer, and a few other things.

Love mobile development, AR/VR/XR, and all forms of digital creativity where you use AI to generate art, text, and music.

Lived in: ๐Ÿ‡ฑ๐Ÿ‡ฐ๐Ÿ‡ธ๐Ÿ‡ฆ๐Ÿ‡บ๐Ÿ‡ธ๐Ÿ‡ณ๐Ÿ‡ฟ๐Ÿ‡ธ๐Ÿ‡ฌ๐Ÿ‡ฒ๐Ÿ‡พ๐Ÿ‡ฆ๐Ÿ‡ช๐Ÿ‡ซ๐Ÿ‡ท๐Ÿ‡ช๐Ÿ‡ธ๐Ÿ‡ต๐Ÿ‡น๐Ÿ‡ถ๐Ÿ‡ฆ๐Ÿ‡จ๐Ÿ‡ฆ

#DeepLearning #StableDiffusion #AIArt #ScienceFiction #Fantasy #Writing #Reading #Art #Gaming #Technology #Coding #Languages #FreeSoftware #Gadgets #Cartoons #Comics #AR #VR #Humour #Movies #TV #80s
re: Fediverse Question (Meta)
Show content
@snott I'm fairly sure you are bad for my sanity ... and I just met you ๐Ÿ˜› You keep saying, "Do it! Do it!" and I keep thinking, "Hey, why not?" ... ๐Ÿ˜ƒ

@jdp23 @jay
0
1
2
re: Fediverse Question (Meta)
Show content
@snott @jdp23 @jay Good luck with that ๐Ÿ™‚ It's always fun to try out these things ... when you have the time.

I'm currently looking at migrating both my servers (one 2GB and the Akkoma one at 1GB) over to a single 4GB server. I have the next week off and so that seems like the time to do it, but man, I don't know if I want the pain ๐Ÿ˜ƒ
0
0
2
re: Fediverse Question (Meta)
Show content
@jay @jdp23 Thanks! I think that's Postgres 12 .. the same version as mine. So it's not the Postgres version that affects the lower RAM ... At least, doesn't look like it. Now this'll keep bugging me till I figure it out ๐Ÿ˜›

I'm basically running everything without Docker at the moment since I didn't want to have the overhead of Docker on the machine, but I'm still curious as to why I have much higher Postgres RAM usage ... Ah, well ...
0
0
1
re: Fediverse Question (Meta)
Show content
@snott @jdp23 @jay I think I just might try Debian 11 to see if I can get better memory performance. I feel better if I wasn't so close to edge in terms of memory usage on this box ๐Ÿ™‚ Just gotta find the time I guess .,..
0
0
1
re: Fediverse Question (Meta)
Show content
@snott Well, obviously you're doing great since it's been running for over a month did you say? ๐Ÿ™‚ I'm tempted to spin up a Debian 11 VPS just to see if Postgres and/or RAM usage is less on a Debian 11 instance ... But I'm not sure I have the will to do so at this point since I've installed Akkoma like 20 times now over the last 3 days ๐Ÿ˜›

@jdp23 @jay
0
0
1
re: Fediverse Question (Meta)
Show content
@jay Cool. Thanks ๐Ÿ™‚ Just trying to figure out why my Postgres has like double the RAM usage of yours. Which version of Postgres are you running?

I don't have any relays at all I believe. And didn't even know about emoji steal ๐Ÿ˜›

@jdp23
1
0
0
re: Fediverse Question (Meta)
Show content
@snott Thank you for this โ€” it's helpful to compare with other installs to try to figure out where things might be tweaked ๐Ÿ™‚ For comparison purposes, I've attached a screenshot from btop for where my server is sitting.

It looks as if you are running Postgres 13 (while mine is on 12). Akkoma docs mentioned that there was an issue with older Postgres but they mentioned a fix and I implemented that. Didn't seem to help much there ... But I'm tempted to try upgrading Postgres to see if perhaps that helps?

If you don't mind me asking, what is the OS you're running? My box is on Ubuntu 20.04 I believe ...

@jdp23 @jay
btop screengrab from 1GB VPS ruโ€ฆ
0
0
1
re: Fediverse Question (Meta)
Show content
@jay Interesting. Did you do any tweaks to your Postgres install? Or is it running the default config? I did all the optimizations that Akkoma docs suggested but kept the connection count at 20 instead of lowering it. So wondering if there's anything else I could do to get the memory usage you're seeing ... @jdp23
1
0
0
@liaizon You're welcome ๐Ÿ™‚
0
0
1
re: Fediverse Question (Meta)
Show content
@jay Without sounding as if I wanted to pick a fight, I did want to say that "light" is all in your context ๐Ÿ™‚ If you have 32GB of RAM on your server, then you'll be totally fine. But if you are using 1GB RAM VPS, you'll struggle which is where I ended up ... It's not Akkoma's fault in that Akkoma itself does not take a lot of RAM. But in my case, I believe the struggles were because of Postgres, which did seem to require a fair amount of RAM.

At the moment, I have Akkoma running on a 1GB RAM VPS without issues after enabling cache. Postgres takes around 360+ MB of RAM and the overall RAM usage (when I checked yesterday) was around 85% of the total. And I'm not running anything else on that server besides Akkoma, Postgres, Nginx and anything else that comes pre-installed on a basic server.

But somebody else told me (based on their experience) that they didn't even think you could run Akkoma without 2GB of RAM. So yeah, it probably is light compared to Mastodon, but it's all relative ๐Ÿ™‚ They all run fine locally on my MacBook which does have 32GB of RAM, but when I move to a VPS, that's when I start having issues ...

@jdp23
1
0
0

This view of the Milky Way was captured at Sunset Crater National Monument near Flagstaff, AZ, USA in 2018.

My co-workers and I were taking the back way into Flagstaff from a job site at the end of the day and pulled off the road to stargaze. I forgot my tripod at the hotel, so I positioned the camera on the truck tailgate, aimed towards the Milky Way, and took a couple dozen photos. This 10-image composition was the result!

5
4
0
Edited 1 year ago

Trees reflected in a pond in heavy fog, Wharton State Forest.

17
11
1
Now that the Akkoma server is running and the memory issues seem to have been sorted out, I turned my attention to the UI ...

While I do like some of the features that the default Akkoma UI provides, it felt a bit too busy and didn't allow the content to shine, IMO. So a little bit of messing around with CSS and I managed to get the UI tweaked enough to suit my requirements ....

I like it much better now ๐Ÿ™‚
Tweaked Akkoma frontend with thโ€ฆ
0
1
0

Christmas At The Lake. As night approaches and snowflakes begin to fall, the decorated Christmas tree at the edge of the lake glows against the snow and reflects in the calm water. Also available with the words Merry Christmas in white script.

See it here -https://deborah-league.pixels.com/featured/christmas-at-the-lake-deborah-league.html

0
2
0

It is winter, so let's dream of summer on day 22 with this watercolor painting of a peaceful landscape with three trees on a meadow beside a grainfield. Everything is quiet, the sky is blue ... relax.

See the Peaceful summer landscape watercolor painting here:
https://karen-kaspar.pixels.com/featured/peaceful-summer-landscape-watercolor-painting-karen-kaspar.html

1
2
0

Elgol, Isle of Skye. A wild evening spent trying to not to get absolutely soaking, I failed for what it's worth. So so so wet

0
4
0
@deltatux Another post seems to confirm that that's in the right ballpark ... apparently running top and paying attention to the VIRT column is the way to go and that seems to indicate that PG is at at about 360MB ...

So, I guess I give it a day and see how it goes over a longer period of time without me constantly restarting the process to optimize or to check on something ๐Ÿ˜›
0
0
1
@deltatux Yeah, that's what I've been discovering ... A quick Google didn't seem to help much and while there are a few processes outlined, none of them seem to really help ๐Ÿ˜›

But as far as I can tell (with the huge caveat that I'm wrong) based on one such Google link, Postgres seems to be taking up only about 300MB. As to whether that's accurate, I have no idea!
1
0
0
@deltatux Is there a way to determine how much RAM Postgres is taking up? According to "top" and "ps" I have multiple Postgres processes and they show the % of memory used and the total of the percentage is higher than 100% ๐Ÿ˜›
1
0
0
Show older