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

From Tom Lane
Subject Re: Using Epoch to save timestamps in 4 bytes?
Date
Msg-id 13234.1210341779@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using Epoch to save timestamps in 4 bytes?  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
"Merlin Moncure" <mmoncure@gmail.com> writes:
> There is nothing wrong with storing int4 epoch in your tables to save a
> little space if that suits your application.

... Just make sure you're safely away from the scene of the crime
before 2038 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: statistics collector process is thrashing my cpu
Next
From: Tom Lane
Date:
Subject: Re: reproducible database crash with simple sql command on postgres 8.3.1