From: Harald Fuchs <hf0217x@protecting.net>
To: pgsql-performance@postgresql.org
Subject: Re: 12 hour table vacuums
Date: Wed, 24 Oct 2007 11:04:27 +0200
Message-ID: <pumyu8zxwk.fsf@srv.protecting.net> (raw)
References: <471E18ED.3090704@shaw.ca>
<87y7dtokfu.fsf@oxford.xeocode.com>
<471E26E4.7040804@shaw.ca>
In article <471E26E4.7040804@shaw.ca>,
Ron St-Pierre <ron.pgsql@shaw.ca> writes:
>> For what it's worth NUMERIC columns take more space than you might expect.
>> Figure a minimum of 12 bytes your rows are at about 1.5k each even if the
>> non-numeric columns aren't large themselves. What are the other columns?
> The NUMERIC columns hold currency related values, with values ranging
> from a few cents to the billions, as well as a few negative numbers.
What's the required precision? If it's just cents (or maybe tenths
thereof), you could use BIGINT to store the amount in this precision.
This would give you exact values with much less space.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: hf0217x@protecting.net
Subject: Re: 12 hour table vacuums
In-Reply-To: <pumyu8zxwk.fsf@srv.protecting.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox