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 xarope on Thursday November 16, 2023 @08:14PM (#38297993)
As a former DBA and optimization expert, the more appropriate response is NOT "add more indexes", but rather to profile and analyze your query plans first, then make decisions off those; e.g. a long running query might be causing deadlocks, another query can be optimize with different joins or ctes, etc.

Adding indexes can increase I/O time (more writes), increase DB file sizes (more stuff to store) etc, which are not inconsequential. Sometimes it's also as simple as moving indexes to a tablespace stored on an SSD.

[ Parent | on HN ]
Re:Operating an Entire Company on a Minimal Two-Core Postgre... by ndriscoll on Friday November 17, 2023 @12:48PM (#38307156)
Rounding out the end of 2023 where a 15 TB pcie gen 4 drive is $1800, it's hard for me to accept the fact that SSD storage for databases (or at least the indexes) isn't just a given.
[ Parent | on HN ]