does timestamp precision affect storage size?

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: does timestamp precision affect storage size?
Date: 2016-06-21 20:39:59
Message-ID: 0903FA82-12B9-4F5C-B021-E23AC0037233@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i'm cleaning up some queries for performance, and noticed that we never use precision beyond the second (ie, `timestamp(0)`) in our business logic.

would there be any savings in storage or performance improvements from losing the resolution on fractional seconds, or are `timestamp(precision)` effectively the same for storage as `timestamp`? (based on docs, I assume the latter but wanted to check)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vik Fearing 2016-06-21 20:47:43 Re: does timestamp precision affect storage size?
Previous Message Allan Kamau 2016-06-21 19:45:50 Re: Help with namespaces in xpath (PostgreSQL 9.5.3)