decimal(5) vs int8. Which more efficient.

From: Francisco Reyes <lists(at)natserv(dot)com>
To: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: decimal(5) vs int8. Which more efficient.
Date: 2002-03-08 18:44:02
Message-ID: 20020308134236.E26200-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2002-03-08 18:58:27 Re: Is vacuum full lock like old's vacuum's lock?
Previous Message Josh Berkus 2002-03-08 18:37:28 Re: [NOVICE] Conditional constraint?