Re: [PERFORM] Advice requested on structuring aggregation queries

2010-02-22 Thread Joe Conway
On 02/22/2010 07:01 PM, Dave Crooke wrote: > The original data is keyed by a 3-ary tuple of strings to keep the > row size down, in the new data model I'm actually storing 32-bit int's > in Postgres. The new schema for each table looks like this: > > (a integer, > b integer, > c integer, >

[PERFORM] Advice requested on structuring aggregation queries

2010-02-22 Thread Dave Crooke
Hi folks I have an application which collects performance stats at time intervals, to which I am retro-fitting a table partitioning scheme in order to improve scalability. The original data is keyed by a 3-ary tuple of strings to keep the row size down, in the new data model I'm actually sto