Venki Ramachandran <venki_ramachandran@yahoo.com> wrote:
> I have PostGres 9.0 database in a AWS server (x-large) and a
> pgplsql program that does some computation. It takes in a date
> range and for one pair of personnel (two employees in a company)
> it calculates some values over the time period. It takes about
> 40ms (milli seconds) to complete and give me the answer. All good
> so far.
Maybe; maybe not. If you wrote out *how to do it* in your code, it
probably won't scale well. The trick to scaling is to write
*declaratively*: say *what you want* rather than *how to get it*.
Aggregates, window functions, CTEs, and/or the generate_series()
function may be useful. It's hard to give more specific advice
without more detail about the problem.
-Kevin