does anyone run postgresql on 1 GB RAM VPS? any gotchas, things to note?
how do I find out how much ram I have?
dmesg isn't showing
oh... top, yeah.  I'm on a 1GB machine
but the load here is really light.
I run stock Postgresql, no tuning, extremely busily used (large tables, many rows, but not "big" - high query volume) on physical machines with 1GB of RAM, no issues whatsoever.
just watch out for number of connections
I've been using pgpool to manage that.  Works great.
Can't say as I've had issues staying under limit, but mine are primarily daemons written in C (libpq) and Ruby (Sequel) so they all behave pretty well.
well, I'm using it for me and the captain with persistent connections from apache processes
so as web hits ramp up, more connections are wanted
1GB of ram is actually quite a lot
Try telling that to some of my hosted ecommerce customers. I'm in the process of provisioning a physical server with 96GB RAM to run Magento for a single customer
plett: do they have a large data set?
96gb ram for physical servers doesn't seem quite as crazy... but going 32gb seems pretty sensible for busy web sites, and the cost difference is that much to increase?  so if you can keep everything you ever read from in ram allg ood :)
thanks all
plett: you're not doiong nested virtualization with all that RAM are you? :-)
"whatcha gonna do with all that ram... all that ram inside your can..."
https://500px.com/mnathani
constructive criticism appreciated
i was reading a while ago how tmpfs isn't as fast as it could be..
having a huge ramdisk does seem like one possible use for lots of ram
my openvpn config for ipmi is ancient, 2014
guessing a lot has changed since then
Not to my knowledge... My early 2015 ARP openvpn config still works fine, no apparent changes.
weird, i get TLS key negotiation errors
(just tested, my ARP VPN still works)
are you connecting over v6 or v4?
openvpn is choosing af_inet (v4)