cstore-fdw is an open sourced Postgres extension that uses the Optimized Row Columnar (ORC) format for its data layout. Use Protobuf-c for serializing and deserializing table metadata. It's dedicated for data analyzing purpose.
Postgres works with it through Postgres foreign data wrapper APIs, so it's transparent to user end.
You can find other articles like the introduction of cstore-fdw and how to setup/config cstore-fdw, at here I'll just give you a glance at technical layer what and how it works in details from handson experience.Write comment (0 Comments)
Here are some SQL examples to get postgres database,table index sizes, all tested for postgres 9.1, 9.2, and 9.3.Write comment (0 Comments)
Sysfs Fibre Channel Tools(updated for RHEL6)
It's a FC tool set I've been using for years, very useful, just updated to reflect RHEL6 latest kernel.
Tested on kernel2.6.32-358.14, using Emulex and Qlogic cards. Should be good for other types of HBA too, just add vendor info to ls_fc_luns
Upgraded Postgres to 9.4 recently, want to check if my handy SQLs still works for pg9.4, Here is the one to get postgres database,table index sizes, actually it these SQLs still work since postgres 9.1, 9.2, and 9.3.Write comment (0 Comments)
scsi_id examples on RHEL7,SL7,CentOS7, I have another scsi_id article for RHEL6/SL6/CentOS6
Write comment (0 Comments)
scsi_id is a tool to retrieve and generate a unique SCSI identifier, it's being widly used lots of system admin tools, primarily used by udev.