Monthly Archives: March 2011

pg_buffercache

pg_buffercache:we can look inside the current contents of the PostgreSQL shared_buffers database cache using the pg_buffercache module.we could look at how blocks in shared memory change as we perform various activities on the database using pg_buffercache. psql -d <databasename> -U … Continue reading

Posted in PostgreSQL DBA Stuff | Leave a comment

Changing system and postgresql locale settings

To change the system locale settings as for the /etc setting is the file /etc/sysconfig/i18n 18:57 LANG=”en_US.utf8″ To set postgresql database /etc/init.d/postgresql-9.0 initdb -E UTF-8 To set in command level # create database blabla¬†WITH ENCODING ‘UTF8’   create database blabla … Continue reading

Posted in Uncategorized | Leave a comment

20 Linux System Monitoring Tools Every SysAdmin Should Know

20 Linux System Monitoring Tools Every SysAdmin Should Know Need to monitor Linux server performance? Try these built-in command and a few add-on tools. Most Linux distributions are equipped with tons of monitoring. These tools provide metrics which can be … Continue reading

Posted in Uncategorized | Leave a comment