Use cases for WINDOW functions

Window functions works only in non-grouped select statement. Basically they allow us to look backwards or forwards in data – from the point of view of currently processed record. With this said we can easily think about values we would like to have: row number...

Use cases for GROUP BY aggregate functions

I believe use cases for aggregate functions are clear from these functions. average sum count creation of string with list of values, array of values, min max boolean and/ or over some interval of values binary and/ or over some interval of values and of course all...

PostgreSQL and high data load application

I have heard complains that PostgreSQL is “old crap” because it cannot handle more than several millions records per day. Well people this is not truth at all. I have worked with application which was able to load and process from 1 000 000 to 3 000 000...