About Jay Jay

Hi there. My name is John Elliot V. My friends call me Jay Jay. I talk about technology on my blog at blog.jj5.net and make videos about electronics on my YouTube channel @InTheLabWithJayJay.

Administering PostgreSQL

So I found this article which said:

 $ sudo -u postgres psql
 postgres=> alter user postgres password 'apassword';
 postgres=> create user your-user createdb createuser password 'passwd';
 postgres=> create database your-db-name owner your-user;
 postgres=> \q

Note: to enable password logins for the ‘postgres’ admin account, edit: /etc/postgresql/9.4/main/pg_hba.conf and after this line:

local   all             postgres                                peer

Add this line:

local   all             postgres                                md5

What every programmer should know about memory

Just stumbled upon What every programmer should know about memory:

  1. Part 1 (Introduction)
  2. Part 2 (CPU Caches)
  3. Part 3 (Virtual memory)
  4. Part 4 (NUMA systems)
  5. Part 5 (Cache optimization)
  6. Part 6 (Threaded optimizations)
  7. Part 7 (Memory performance tools)
  8. Part 8 (Future technologies)
  9. Part 9 (Appendices and bibliography)