Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 703521337B3E for ; Tue, 16 Nov 2010 07:07:38 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 15812-06 for ; Tue, 16 Nov 2010 11:07:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zenon.apartia.fr (zenon.apartia.fr [82.66.93.83]) by mail.postgresql.org (Postfix) with ESMTP id 7766E1336B42 for ; Tue, 16 Nov 2010 07:07:30 -0400 (AST) Received: from sylla.apartia.fr (sylla.apartia.fr [10.0.3.3]) by zenon.apartia.fr (Postfix) with ESMTP id 3DBDF42508021 for ; Tue, 16 Nov 2010 12:07:30 +0100 (CET) Received: by sylla.apartia.fr (Postfix, from userid 1000) id 1E8E240273517; Tue, 16 Nov 2010 12:07:30 +0100 (CET) Date: Tue, 16 Nov 2010 12:07:30 +0100 From: Louis-David Mitterrand To: pgsql-performance@postgresql.org Subject: Re: best db schema for time series data? Message-ID: <20101116110729.GA30848@apartia.fr> Mail-Followup-To: pgsql-performance@postgresql.org References: <20101116105055.GA26129@apartia.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201011/259 X-Sequence-Number: 41283 On Tue, Nov 16, 2010 at 12:03:29PM +0100, Pavel Stehule wrote: > Hello > > my opinion: > > @1 can be faster for access to last items with index > @2 can be more effective about data files length allocation Hi Pavel, What is "data files length allocation" ?