News for hackers. Stuff that matters.

A comment on Operating an Entire Company on a Minimal Two-Core PostgreSQL Instance, Part 1. Parent comment

Re:Operating an Entire Company on a Minimal Two-Core Postgre... by ako on Thursday November 16, 2023 @03:23PM (#38294951)
That is not a SQL mistake, but an implementation choice. Most modern databases can determine where indexes should be added, and add these automatically. E.g.: https://www.oracle.com/news/connect/oracle-database-automati...
[ Parent | on HN ]
Re:Operating an Entire Company on a Minimal Two-Core Postgre... by akoboldfrying on Thursday November 16, 2023 @06:38PM (#38297223)
This is news to me. Can any other DBs do this?

(I only skimmed -- far too much "Joan explains that" to signal ratio.)

[ Parent | on HN ]
Re:Operating an Entire Company on a Minimal Two-Core Postgre... by ako on Friday November 17, 2023 @01:37AM (#38300287)
SQL server: https://learn.microsoft.com/en-us/sql/relational-databases/a...

Interesting read on a project implementing this for Postgres: https://pganalyze.com/blog/automatic-indexing-system-postgre...

[ Parent | on HN ]
Re:Operating an Entire Company on a Minimal Two-Core Postgre... by sharadov on Thursday November 23, 2023 @02:44PM (#38396695)
Not for postgres or mysql.
[ Parent | on HN ]