Re: huge price database question..

From: Jim Green <student(dot)northwestern(at)gmail(dot)com>
To: Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>
Cc: David Kerr <dmk(at)mr-paradox(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: huge price database question..
Date: 2012-03-21 02:02:57
Message-ID: CACAe89xcn85CHQS90vdQ526KFfHParLXL8zS1C1fVEJi-=cK=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 20 March 2012 21:54, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> wrote:
>
> Also look at a clustered index on timestamp

Thanks, this looks very helpful. what do you think about the thousands
table vs one table partitioned by month? I guess if I go with one
table, index would be too big to fit in ram?

Jim.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2012-03-21 02:03:20 Re: huge price database question..
Previous Message Brent Wood 2012-03-21 01:54:58 Re: huge price database question..