does timestamp precision affect storage size?

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема does timestamp precision affect storage size?
Дата
Msg-id 0903FA82-12B9-4F5C-B021-E23AC0037233@2xlp.com
обсуждение исходный текст
Ответы Re: does timestamp precision affect storage size?  (Vik Fearing <vik@2ndquadrant.fr>)
Re: does timestamp precision affect storage size?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Re: Help with namespaces in xpath (PostgreSQL 9.5.3)
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: does timestamp precision affect storage size?