postgresql – 0x126A90C

Check for a NULL/nil YAML value stored in a database column

I was trying to google for searching a database for a nil yaml value and it took me a bit so I thought I would post my findings. Basically if you do this in the rails console: nil.to_yaml you’ll receive: — \n…\n Kind of irritating when you’re trying to write a SQL query. So to… Read More »

PostgreSQL + Chef – Automatically configure based on server RAM

I was sick of changing shared_buffers, effective_cache_size, maintenance_work_mem, work_mem, SHMMAX, SHMALL each time we’d spin up a new server. So I decided instead to have chef calculate it for me! It takes the available RAM of the server and then calculates each value based on: shared_buffers = 25% of maximum memory maintenance_work_mem = 10% of… Read More »