Postgres Pro
Downloads
Home   >   mailing lists

Re: huge price database question.. - Mailing list pgsql-general

From Jim Green
Subject Re: huge price database question..
Date
Msg-id CACAe89xcn85CHQS90vdQ526KFfHParLXL8zS1C1fVEJi-=cK=A@mail.gmail.com
Whole thread Raw
In response to huge price database question..  (Jim Green <student.northwestern@gmail.com>)
List pgsql-general
Tree view 
On 20 March 2012 21:54, Brent Wood <Brent.Wood@niwa.co.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.

pgsql-general by date:

Previous
From: Jim Green
Date:
Subject: Re: huge price database question..
Next
From: David Kerr
Date:
Subject: Re: huge price database question..