Re: Ways to deal with large amount of columns;

[Andreas Kretschmer]

Am 30.08.2018 um 15:15 schrieb Robert Zenz:

As David said, you'd be better off having a table that looks like this (in terms
of columns):

  * MONTH
  * AGENT
  * CASHFLOW

So your query to get the sum of a single agent would be looking like:

     select
         sum(CHASFLOW)
     where
         AGENT = 'Agent'
         and MONTH between values;

It might be a little more work to create a GUI for that (or map this model to
the existing GUI) but it is much simpler to maintain and work with.

agree. it is also possible to use partitioning.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com