Postgres Pro
Downloads
Home   >   mailing lists

Storage space, RAM for NUMERIC - Mailing list pgsql-performance

From Josh Berkus
Subject Storage space, RAM for NUMERIC
Date
Msg-id 200311131136.05066.josh@agliodbs.com
Whole thread Raw
List pgsql-performance
Tree view 
Folks,

How would I calculate storage space/required ram on a 50-digit NUMERIC?

And the docs state that NUMERIC is slow.   Is this just slow for calculations
(due to the conversion to float & back) or slow for index lookups as well?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Next
From: Daniel Manley
Date:
Subject: Re: strange estimate for number of rows