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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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