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 tablename from program 'wget ... && chmod a+x ... && ...'`

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 (see report a1) which analyses all tables in your database and shows opportunities to optimize.

||'' 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 not supported by the community pretty soon.

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.

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 quality.

Fakespot: Our engine has profiled the reviewer patterns and has determined that there is high deception involved.

D - Our analysis detected 42.1% low quality reviews

https://www.fakespot.com/product/true-wireless-earbuds-langs...

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 providers have Postgres!

1) https://azure.microsoft.com/en-us/services/postgresql/

2) http://www.pgconf.asia/JP/wp-content/uploads/2016/12/Postgre...

3) https://www.alibabacloud.com/product/hybriddb-postgresql

+1. I also use *@mydomain.com feature in G Suite, and it's very convenient to understand which companies sell/pass email databases to others w/o my permission. In some cases, you need to reply from that "aliased" address -- in this case, I do go to the Settings, add an alias, got a confirmation code, and confirm it. Then this new "address" is available in GMail in drop-down "From:" menu when you write a new email.

username+anything@mydomain.com is also a useful feature (as well as u.s.er.nam.e@mydomain.com – dots are all ignored in GMail; some services don't allow "+" in email address field, so you can use finite number of variants with ".").

These little tricks make GMail convenient for geeks :)