Postgres Pro
Downloads
Home   >   mailing lists

decimal(5) vs int8. Which more efficient. - Mailing list pgsql-general

From Francisco Reyes
Subject decimal(5) vs int8. Which more efficient.
Date
Msg-id 20020308134236.E26200-100000@zoraida.natserv.net
Whole thread Raw
List pgsql-general
Tree view 
What would be more efficient for storing a value that is 5 Bytes long?
decimal(5) or int8?

Does decimal(5) actually uses up only 5 bytes? Does that cause any
problems?

Not finding much on the archives regarding this.

pgsql-general by date:

Previous
From: Jeff Anto
Date:
Subject: a strange output from vacuum
Next
From: "Gregory Wood"
Date:
Subject: Re: Is vacuum full lock like old's vacuum's lock?