TIMESTAMP和TIMESTAMPTZ

区别

TIMESTAMP:没有时区
TIMESTAMPTZ:时区,直接加+08,中国位于东八区,所以是+08

精度

TIMESTAMP(6):表示秒后面最长有6位小数,而java代码只能接受3位小数,从而导致精度丢失如若db种带修改时间来更新则更新失败。
TIMESTAMP(3):表示秒后面最长有3位小数

numrange

numeric的范围类型

  SELECT numrange(1,4),'[1,4)'::numrange, '(1,4]'::numrange, '[1,4]'::numrange;

image.png

tomcat的maxPostSize和maxParameterCount

maxParameterCount

The maximum number of parameter and value pairs (GET plus POST) which will be automatically parsed by the container. Parameter and value pairs beyond this limit will be ignored. A value of less than 0 means no limit. If not specified, a default of 10000 is used

maxPostSize

The maximum size in bytes of the POST which will be handled by the container FORM URL parameter parsing. The limit can be disabled by setting this attribute to a value less than zero. If not specified, this attribute is set to 2097152 (2 megabytes)

修改

通过设置server.xml的节点来改变
<Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" maxPostSize="-1" maxParameterCount="-1"/>