Using Epoch to save timestamps in 4 bytes?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Using Epoch to save timestamps in 4 bytes?
Дата
Msg-id cone.1210305467.346740.51351.1000@zoraida.natserv.net
обсуждение исходный текст
Ответы Re: Using Epoch to save timestamps in 4 bytes?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
While looking at a database I inheritted I noticed the database has tables
with integers used to store epoch.

I noticed that timestamp is 8 bytes and was wondering how come timestamp is
8 bytes and not 4. Is it to be able to support precission beyond a second?

I am looking at tens of millions of rows, which is why my predecessor may
have used integer to store epoch to save space.

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Fragments in tsearch2 headline
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Using Epoch to save timestamps in 4 bytes?