On Jun 21, 2016, at 4:50 PM, Tom Lane wrote:
> Storage-wise, no. If you have a resolution spec on your columns now,
> I think dropping the resolution spec would save you a few nanoseconds per
> row insertion due to not having to apply the roundoff function. Adding
> one would certainly not improve speed.
On Jun 21, 2016, at 4:47 PM, Vik Fearing wrote:
> No, there are no space savings here.
>
> =# select pg_column_size('now'::timestamptz(0)),
> pg_column_size('now'::timestamptz);
Thanks. I thought that was happening, but wanted to make sure. the allure of shaving a byte or two off some rows couldn't be ignored ;)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
