Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9A9BE9FBE69 for ; Wed, 24 Oct 2007 06:10:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 84222-03-2 for ; Wed, 24 Oct 2007 06:10:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 9019E9FBD42 for ; Wed, 24 Oct 2007 06:10:07 -0300 (ADT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1IkcFW-0000xA-DW for pgsql-performance@postgresql.org; Wed, 24 Oct 2007 09:10:02 +0000 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 24 Oct 2007 09:10:02 +0000 Received: from hf0217x by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 24 Oct 2007 09:10:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Harald Fuchs Subject: Re: 12 hour table vacuums Date: Wed, 24 Oct 2007 11:04:27 +0200 Lines: 13 Message-ID: References: <471E18ED.3090704@shaw.ca> <87y7dtokfu.fsf@oxford.xeocode.com> <471E26E4.7040804@shaw.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net X-Archive: encrypt User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) Cancel-Lock: sha1:jL+XH9Q0F7CJf2jMNeacVevXJXw= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/266 X-Sequence-Number: 27288 In article <471E26E4.7040804@shaw.ca>, Ron St-Pierre 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.