Re: Best way to handle multi-billion row read-only table?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Asher <asher(at)piceur(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to handle multi-billion row read-only table?
Date: 2010-02-10 15:09:26
Message-ID: 407d949e1002100709p492168f4qad4be890f7f6f1dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 10, 2010 at 2:32 PM, Asher <asher(at)piceur(dot)co(dot)uk> wrote:
> The data will initially be accessed via a simple GUI which will allow
> browsing over a subset of the data (subsampled down to 1 sample/minute/hour,
> etc.

It sounds like you could use a tool like rrd that keeps various levels
of aggregation and intelligently chooses the right level for the given
query. I think there are such tools though I'm not sure there are any
free ones.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-02-10 15:24:56 Re: Memory Usage and OpenBSD
Previous Message Ben Campbell 2010-02-10 14:49:23 Re: problems maintaining boolean columns in a large table