Re: [GENERAL] Optimizing data layout for reporting in postgres

2009-12-27 Thread Alban Hertroys
On 24 Dec 2009, at 21:01, Doug El wrote: > Hi, > > I have to summarize some data to be queried and there are about 5 million raw > records a day I need to summarize. In a nutshell I don't think I'm laying it > out in an optimal fashion, or not taking advantage of some postgres features > perha

Re: [GENERAL] Optimizing data layout for reporting in postgres

2009-12-24 Thread Scott Marlowe
On Thu, Dec 24, 2009 at 1:01 PM, Doug El wrote: > Hi, > > I have to summarize some data to be queried and there are about 5 million raw > records a day I need to summarize. In a nutshell I don't think I'm laying it > out in an optimal fashion, or not taking advantage of some postgres features >

[GENERAL] Optimizing data layout for reporting in postgres

2009-12-24 Thread Doug El
Hi, I have to summarize some data to be queried and there are about 5 million raw records a day I need to summarize. In a nutshell I don't think I'm laying it out in an optimal fashion, or not taking advantage of some postgres features perhaps, I'm looking for feedback. The raw incoming data i