Re: [GENERAL] Need advice for handling big data in postgres

2015-01-15 Thread Jim Nasby
On 1/15/15 7:42 AM, Vincent Veyron wrote: On Wed, 14 Jan 2015 11:42:45 +1100 Tobias Fielitz wrote: OPTION 1 - PARTITIONING: For each query only a few columns are interesting and I could partition the table (as it was suggested on SO) by *created* and by *code*. There is roughly 10 different co

Re: [GENERAL] Need advice for handling big data in postgres

2015-01-15 Thread Vincent Veyron
On Wed, 14 Jan 2015 11:42:45 +1100 Tobias Fielitz wrote: > > OPTION 1 - PARTITIONING: > For each query only a few columns are interesting and I could partition > the table (as it was suggested on SO) > by *created* and by *code*. > There is roughly 10 different codes and I would keep data for the