data storage for timestamp data type? - Mailing list pgsql-novice

From Chirag Patel
Subject data storage for timestamp data type?
Date
Msg-id 808018.20783.qm@web52810.mail.re2.yahoo.com
Whole thread Raw
Responses Re: data storage for timestamp data type?  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-novice
The timestamp data type in postgreSQL has the option for a parameter 'p' that defines the precision from 0-6. The documentation indicates 8 bytes as the default size for the column.

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

Thanks!
Chirag

PS. By the way, I think clustering question hit the list 3 times by accident last week. I apologize, I used the wrong e-mail address and assumed the first 2 didn't make it.

pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Postmaster start up problems (can't create lock file )
Next
From: Michael Glaesemann
Date:
Subject: Re: data storage for timestamp data type?