Grokbase
x

[NOVICE] data storage for timestamp data type?

View PostFlat  Thread  Threaded | Next >
Chirag Patel [NOVICE] data storage for timestamp data type?
| +1 vote
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
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.

Thread : [NOVICE] data storage for timestamp data type?
1)
Chirag Patel The timestamp data type in postgreSQL has the option for a parameter 'p' that defines the precision...
2)
Michael Glaesemann 8 bytes will still be allocated. Internally it's an 8-byte int or an 8-byte float depending on...
3)
Michael Glaesemann follow, and please reply to the list so that others may benefit from and participate in the...
spacer
View PostFlat  Thread  Threaded | Next >