Jonathan Vanasco <postg...@2xlp.com> writes:
> would there be any savings in storage or performance improvements from losing
> the resolution on fractional seconds,
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.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
