VisualVM is a visual tool integrating several commandline JDK tools and lightweight profiling capabilities. Designed for both production and development time use, it further enhances the capability of monitoring and performance analysis for the Java SE platform.
Currently adding a column to a table with a non-NULL default results in
a rewrite of the table. For large tables this can be both expensive and
disruptive. This patch removes the need for the rewrite as long as the
default value is not volatile. The default expression is evaluated at
the time of the ALTER TABLE and the result stored in a new column
(attmissingval) in pg_attribute, and a new column (atthasmissing) is set
to true. Any existing row when fetched will be supplied with the
attmissingval. New rows will have the supplied value or the default and
so will never need the attmissingval.
M. Willatzen, N. Pettit, и L. Ploug-Sorensen. International Journal of Refrigeration-Revue Internationale Du Froid, 21 (5):
398-403(августа 1998)Times Cited: 0 English Article 101DZ INT J REFRIG.
Q. Noorshams, A. Rentschler, S. Kounev, и R. Reussner. Proceedings of the ACM/SPEC International Conference on Performance Engineering, стр. 339--342. New York, NY, USA, ACM, (2013)
Q. Noorshams, A. Rentschler, S. Kounev, и R. Reussner. Proceedings of the ACM/SPEC International Conference on Performance Engineering, стр. 339--342. New York, NY, USA, ACM, (2013)