Jonathan Vanasco <postgres@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general