Viewing profile — postila

Better, automated tools for optimization are needed. Postgres ecosystem right now lacks a lot of things that enterprise systems have for decades.

things like superuser should be disabled by default (only DBA needs superuser access, not anybody else).

Also: 3. Ensure that you don't use or provide anybody superuser in Postgres. (Otherwise, there is much simpler way to download&run anything that explain in the article – just `copy…

This is one of the interesting optimizations that DBMS should do automatically but it doesn't. https://github.com/NikolayS/postgres_dba -- this toolset includes a version of report…

I mean, in more recent Postgres versions, more things related to window functions are available – like CUBE, GROUPING SETS, etc. 9.3 was released back in 2013.

||'' is another way to do ::text ? :-)

select version(); PostgreSQL 9.3.20 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bi I wonder why so old version is being used. I will be n…

postgreS

Here is an example of ~$65 item merged with others https://www.amazon.com/gp/product/B076RS1WRZ/ref=oh_aui_deta... – a lot of five-star reviews (marked as verified ), but very bad …

MS Azure also provides Postgres now [1]. And also does Alibaba Cloud [2]. They even have a special version of it – something for analytics/warehousing [3]. So at least 4 big cloud …