does timestamp precision affect storage size? - Mailing list pgsql-general

From Jonathan Vanasco
Subject does timestamp precision affect storage size?
Date
Msg-id 0903FA82-12B9-4F5C-B021-E23AC0037233@2xlp.com
Whole thread Raw
Responses Re: does timestamp precision affect storage size?
Re: does timestamp precision affect storage size?
List 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
wantedto check) 

pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Re: Help with namespaces in xpath (PostgreSQL 9.5.3)
Next
From: Vik Fearing
Date:
Subject: Re: does timestamp precision affect storage size?