Changeset: c471ca9b1fd4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c471ca9b1fd4 Modified Files: sql/ChangeLog Branch: default Log Message:
Update SQL changelog for changes made to storagemodel script. diffs (53 lines): diff --git a/sql/ChangeLog b/sql/ChangeLog --- a/sql/ChangeLog +++ b/sql/ChangeLog @@ -1,6 +1,49 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Thu Nov 29 2018 Martin van Dinther <[email protected]> +- Improved and extended storagemodel functionality. Changes include: +- Added views sys."tablestorage" and sys."schemastorage" for easy and + quick assesment of aggregated storage usage per table or per schema. +- Excluded listing system tables in views sys."storage", sys."tablestorage" + and sys."schemastorage". You can still use sys."storage"() to query + storage of system tables and columns. +- In procedure sys.storagemodelinit() when populating table + sys.storagemodelinput it now excludes system tables as system tables are + not useful to be modeled for storagesize by application users. + It now also computes and populates the atomwidth column more correctly + for variable size data types (strings, blobs) when the table has + representative data in those columns. +- System function sys.columnsize() has been corrected for types: tinyint, + real, date, time, timetz, sec_interval, month_interval, decimal, uuid, + mbr, char, clob, json, url, blob, geometry and geometrya. + For variable size data types (varchar, char, clob, json, url, blob, + geometry, geometrya) it now returns the columnsize excluding the + variable heapsize. The heapsize is retrievable via sys.heapsize(). +- System function sys.heapsize() has been corrected for all variable size + data types: varchar, char, clob, json, url, blob, geometry and geometrya. +- System function sys.imprintsize() has been corrected. The imprintsize + depends on the width (1 or 2 or 4 or 8 or 16 bytes) of the data type. + Also instead of 12% it now uses 20%, which is a better estimate. +- System function sys.storagemodel() has been removed as it outputs the + same data as view sys.storagemodel. Use view sys.storagemodel instead. +- Corrected views sys.storagemodel and sys.tablestoragemodel by returning + a computed orderidxsize when the count has been changed in the + sys.storagemodelinput table. Also the views now return data ordered + by schema, table and column names. +- Extended view sys.tablestoragemodel with column: "storages". Besides + columns also keys (primary, foreign and unique keys) and indexes + (ordered, imprints) use storage, so the "storages" count can be higher + than the number of columns per table. +- Corrected the data type of columns "schema", "table", "column", "type", + "mode" and location in table sys.storagemodelinput and functions + sys."storage"(), sys."storage"(sname), sys."storage"(sname, tname) + and sys."storage"(sname, tname, cname) from string into varchar(1024). + Consequently also the views based on the table or functions will be + reporting varchar(1024) as column meta data instead of clob for those + columns. This allows faster querying and reporting by generic SQL + programs which treat clob querying different from varchar columns. + * Mon Nov 26 2018 Pedro Ferreira <[email protected]> - Extended windowing functions catalog with SQL standard semantics. Standard aggregation functions can now be used in windowing _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
