Usage of arrays in aggregations

If you get to know them you will simply love them – I mean ARRAYs in PostgreSQL. And also in some situations you simply cannot live without them – at least in PostgreSQL. Here are some examples how to use them in real life. (still in TODO) Aggregations...

How to check PostgreSQL processes from OS

On Linux: ps-ef |greppostgres | grep-v grep shows all postgres processes works on all Linux distros second grep pipe just filters out line with “grep postgres” command   you will see something like this – of course directories can be...