pgCluu Files

2015-01-05 - Version 2.2 released

This release is a maintenance release that fix several issues. There's also a
simple report of transparent_hugepage from the system and a menu enhancement
by dividing the device menu per 10 items which is helpful when there's plenty
of disk devices.

	- Increase copyright year to 2015.
	- Fix bug in database list extraction.
	- Fix query to get missing foreign key indexes. Thanks to Ronan
	  Dunklau for the patch.
	- Add collect of transparent_hugepage information into sysinfo.txt file.
	  (read from /sys/kernel/mm/transparent_hugepage/-)
	- Fix overwriting of idle_in_xact for all database, should be idle.
	  Thanks to Guillaume Lelarge for the patch.
	- Fix query for missing indexes on FKs. The previous query reported
	  every index that SHOULD exist for FKs, but was not filtering out the
	  already existing ones. Thanks to Ronan Dunklau for the patch.
	- Do not report redundant indexes when one is partial and not the other
	  one. Thanks to Ronan Dunklau for the report.
	- Fix statement to search redundant index by not reporting index that
	  has uniqueness and not the other one. The statement now also reports
	  duplicate indexes on the same column and not only composite indexes.
	  Thanks to Ronan Dunklau for the report.
	- Divide Devices menu by part of 10 devices. Useful when there is plenty
	  of disk devices.
	- Add --from-sa-file to allow parsing of sar output coming from a sa
	  daily file.
	- Fix call to local sar command and limit test on application_name for
	  pg version >= 9.0. Thanks to Julien Rouhaud for the report.
	- Set application_name to pgcluu before collecting data and exclude
	  from pg_stat_activity queries generated by pgcluu.