On Mon, 2025-03-10 at 09:28 +0200, Achilleas Mantzios - cloud wrote:
> [doesn't think running PostgreSQL in containers in production
> is such a hot idea, but sees the concept going mainstream]
>
> What are your thoughts ? I am puzzled because while I used to hear many
> skeptical opinions until some years ago, now the trend seems to more on
> the "acceptance" or neutral side.
Well, lots of people think it is a great idea to host their important
database in a public cloud. Fashions are not necessarily based on wisdom.
Using Kubernetes for test and play databases that you create and destroy
regularly is a great thing.
Using Kubernetes to squish many small databases on a single machine
while managing the resource usage can be useful.
If you use Kubernetes for everything else and it makes monitoring easy
for you, it may make sense to run a production database that way.
Running your database on Kubernetes will make database administration
and troubleshooting more cumbersome and will require you to create special
containers for the purpose of upgrading. If these disadvantages are
outbalanced by the above advantages, it may make sense.
If you plan to run serious databases on Kubernetes, you better have
dedicated nodes for that purpose, so that you can tune the kernel
parameters.
Yours,
Laurenz Albe
