Posts
49
Following
10
Followers
20
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
@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 2 years 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
I did one final tune-up for my 1GB RAM Akkoma instance earlier today โ€” I optimized the Posgres DB as per this Akkoma guide: https://docs.akkoma.dev/stable/configuration/postgresql/ and the help of PGTune: https://pgtune.leopard.in.ua/

Just adding a swap file (earlier) seemed to make things so much better and I can't say for certain that the Postgres tuning made a huge difference ... or not. But CPU load has certainly gone down a lot and the memory usage, while still substantial, is not always at a 100%. In fact, since the above changes, I don't believe memory usage has topped 90%.

So that's where it is after 24 hours of running the Akkoma server. This server incidentally has nothing else on it except for Akkoma ๐Ÿ™‚

I'm adding some charts for the 24-hour period so that you can see how it's gone so far โ€” where the lines plunge suddenly today is from around the time the swap file was added and the Postgres tuning done, one after the other with maybe 15 minutes interval in between.

#Akkoma #Ubuntu #Server #VPS
Graph showing CPU usage percentโ€ฆ
Graph showing memory usage percโ€ฆ
Graph showing disk I/O for the โ€ฆ
Graph showing server load for tโ€ฆ
1
1
2
Edited 2 years ago

A Great Gray Owl sitting pretty for a portrait, Missoula, Montana, spring 2022. Photo by Chase Miller.

0
3
0

Mastodonโ€ขART ๐ŸŽจ Curator

I'd like to spend the weekend focusing on the black, indigenous, and PoC creatives in the community here, in an effort to amplify their voices with the reach of this account.

If you'd like to share your work (this includes art, craft, writing, music, dance - anything creative), comment below; introduce yourself, say a bit about your work, and link to any of your posts that you'd like to highlight, including shop/support links! <3

artcapy4

(Fixed for increased inclusion <3)

38
1
0

Wanted: a true accent!

My daughter's undergraduate linguistics project needs a recording of a person who was born in and who has lived there throughout their life, so their vowels are unsullied by southern tones.

All that's required is a short recording of a word list.

The project is an analysis of the effect on vowel sound on people who are brought up in one part of the UK and later move elsewhere.

If you can help, please DM or reply. Otherwise pls boost Thanks!

8
4
0

Um bom dia para todos ๐Ÿ˜ƒ๐ŸŒฟ๐ŸŽ‹๐ŸŒง๏ธ๐Ÿ™

2
2
0
Show older