Re: Ways to deal with large amount of columns; - Mailing list pgsql-general

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