Skip site navigation (1) Skip section navigation (2)

Re: data storage for timestamp data type?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Chirag Patel <patelc75(at)yahoo(dot)com>
Cc: PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: data storage for timestamp data type?
Date: 2007-08-14 19:16:26
Message-ID: FF6C5089-51FA-4869-B6F8-1E558517315F@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-novice
On Aug 14, 2007, at 13:52 , Chirag Patel wrote:

> If I use timestamp(3) as an example, will postgres still allocate  
> the entire 8 bytes for the column or reduce it?

8 bytes will still be allocated. Internally it's an 8-byte int or an  
8-byte float depending on whether or not you compiled with enable- 
integer-datetimes.

Michael Glaesemann
grzm seespotcode net



In response to

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2007-08-14 19:56:06
Subject: Re: data storage for timestamp data type?
Previous:From: Chirag PatelDate: 2007-08-14 18:52:47
Subject: data storage for timestamp data type?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group