@@ -51,7 +51,7 @@ Like many "specialized databases," the strength of dedicated OLAP systems often
|
51 | 51 | |
52 | 52 | However, as the saying goes, "What goes around comes around". With [hardware improving over thirty years following Moore's Law](/blog/cloud/bonus), performance has increased exponentially while costs have plummeted. In 2024, a single x86 machine can have hundreds of cores (512 vCPU [EPYC 9754](https://www.amd.com/zh-hans/products/cpu/amd-epyc-9754)x2), several TBs of RAM, a single NVMe SSD can hold up to 64TB, and a single all-flash rack can reach 2PB; object storage like S3 offers virtually unlimited storage. |
53 | 53 | |
54 | | -[](/blog/cloud/bonus) |
| 54 | +[](/blog/cloud/bonus) |
55 | 55 | |
56 | 56 | Hardware advancements have solved the data volume and performance issue, while database software developments (PostgreSQL, ParadeDB, DuckDB) have addressed access method challenges. This puts the fundamental assumptions of the analytics sector — the so-called “big data” industry — under scrutiny. |
57 | 57 | |
@@ -77,7 +77,7 @@ This isn’t the first time; we’re witnessing it again in the oldest and large
|
77 | 77 | |
78 | 78 | What makes PostgreSQL so capable? Sure, it's advanced, but so is Oracle; it's open-source, as is MySQL. PostgreSQL's edge comes from being **both advanced and open-source**, allowing it to compete with Oracle/MySQL. But its true uniqueness lies in its **extreme extensibility and thriving extension ecosystem**. |
79 | 79 | |
80 | | -[](https://www.timescale.com/state-of-postgres/2022/) |
| 80 | +[](https://www.timescale.com/state-of-postgres/2022/) |
81 | 81 | |
82 | 82 | > TimescaleDB survey: [what is the main reason you choose to use PostgreSQL](https://www.timescale.com/state-of-postgres/2022/) |
83 | 83 | |
@@ -124,7 +124,7 @@ A niche database product might carve out a space for itself if it can outperform
|
124 | 124 | |
125 | 125 | Following this logic, the PostgreSQL ecosystem is poised to snowball, accruing advantages and inevitably moving towards a monopoly, mirroring the Linux kernel’s status in server OS within a few years. Developer surveys and database trend reports confirm this trajectory. |
126 | 126 | |
127 | | -[](https://survey.stackoverflow.co/2023/#section-most-popular-technologies-databases) |
| 127 | +[](https://survey.stackoverflow.co/2023/#section-most-popular-technologies-databases) |
128 | 128 | |
129 | 129 | > [**StackOverflow 2023 Survey: PostgreSQL, the Decathlete**](https://survey.stackoverflow.co/2023/#section-most-popular-technologies-databases) |
130 | 130 | |
|