Using Epoch to save timestamps in 4 bytes? - Mailing list pgsql-general

From Francisco Reyes
Subject Using Epoch to save timestamps in 4 bytes?
Date
Msg-id cone.1210305467.346740.51351.1000@zoraida.natserv.net
Whole thread Raw
Responses Re: Using Epoch to save timestamps in 4 bytes?  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: Bruce Momjian
Date:
Subject: Re: Using Epoch to save timestamps in 4 bytes?