Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Using Epoch to ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 15492 of 16162
Post > Topic >>

Using Epoch to save timestamps in 4 bytes?

by lists@[EMAIL PROTECTED] (Francisco Reyes) May 8, 2008 at 11:57 PM

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 sup****t 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.    

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 7 Posts in Topic:
Using Epoch to save timestamps in 4 bytes?
lists@[EMAIL PROTECTED]   2008-05-08 23:57:47 
Re: Using Epoch to save timestamps in 4 bytes?
bruce@[EMAIL PROTECTED]   2008-05-09 00:00:51 
Re: Using Epoch to save timestamps in 4 bytes?
lists@[EMAIL PROTECTED]   2008-05-10 20:47:11 
Re: Using Epoch to save timestamps in 4 bytes?
tgl@[EMAIL PROTECTED] (T  2008-05-10 21:37:29 
Re: Using Epoch to save timestamps in 4 bytes?
scott.marlowe@[EMAIL PROT  2008-05-09 01:15:57 
Re: Using Epoch to save timestamps in 4 bytes?
mmoncure@[EMAIL PROTECTED  2008-05-09 08:51:26 
Re: Using Epoch to save timestamps in 4 bytes?
tgl@[EMAIL PROTECTED] (T  2008-05-09 10:02:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 6:55:19 CDT 2008.