For postgres if you self host then you can create ad hoc native extension. Most of the time it's not needed, but I've seen 2-4x speed ups in critical queries
Ask HN: Do you self-host your database?
91–100 of 236 posts
Re: Ask HN: Do you self-host your database?
#92Earlier quoted context omitted.
Could you elaborate on this or point us to documentation (url, book, ...) about it ?
The postgres docs are excellent, https://www.postgresql.org/docs/13/runtime-config.html I have seen tutorials where folks go over the most essential settings, but I can't seem to find the ones I have used now, so me just doing a search for 'postgres tuning' is no better than you doing the search yourself. Maybe someone else can chime in with a good guide?
http://pgconfigurator.cybertec.at/ offers a quick way to obtain an often-acceptable tuning.
Re: Ask HN: Do you self-host your database?
#93We're currently transitioning from a multi-tenant 2TB postgres DB hosted on AWS RDS to using sqlite instead, a separate database for each client. We're doing this for multiple reasons: a) As our DB grew the service became very expensive, one of the biggest items in our AWS invoice; b) Keeping the PG servers up to date is a pain, we simply don't have time for this; c) We wanted to be able to migrate to other clouds an…
How do you deal with common sqlite lock file when using it for multiple users?
Re: Ask HN: Do you self-host your database?
#94For personal use and side projects, I always self-host. It's so much cheaper considering the tiny size. I usually start with sqlite instead of the "real" database, and in 99% of the cases it stays so. At work, I never self-host. Life is so much easier if blame for whatever unrelated reason can be outsourced to some cloud provider or internal datacenter team. Because if we self host the database, we will be responsibl…
Not to mention backups that just happen and point in time restores (awesome for testing as well as recovery)
Re: Ask HN: Do you self-host your database?
#95Yes, of course. It’s not that scary or difficult.
Re: Ask HN: Do you self-host your database?
#96For personal use and side projects, I always self-host. It's so much cheaper considering the tiny size. I usually start with sqlite instead of the "real" database, and in 99% of the cases it stays so. At work, I never self-host. Life is so much easier if blame for whatever unrelated reason can be outsourced to some cloud provider or internal datacenter team. Because if we self host the database, we will be responsibl…
If you're self hosting at work, then this is probably your low-hanging fruit for freeing up time by outsourcing that headache. And as you mention, there's risk involved. Why put yourself in a position where people will point fingers at when things go wrong? Why stake the reputation of your product on something which isn't core to the business you're working for?
My answer to the original question. One big difference between work and home is that I have more choice on what I can do with my time at home. I can't waste time at work, but I can waste time at home. So, I setup my own personal stuff.
Re: Ask HN: Do you self-host your database?
#97Where does one start when wanting to self-host a DB?
Re: Ask HN: Do you self-host your database?
#98I do it for my own projects. For work, where cash is not a constraint I use managed options (mostly AWS RDS)
Re: Ask HN: Do you self-host your database?
#99We self-host a postgres cluster in k8s (AKS). The main reason being that the Azure postgres offering was not fit for (our) purpose. We did start with the Azure offering, and our default is generally to use the cloud offering.
Could you please elaborate on what the drawbacks with the Azure postgres offering are? I am currently evaluating the same choice - Azure Postgres vs self-hosting in my k8s cluster.
Not parent, but at {work} we made a similar move, from Azure managed postgres to self-managed postgres.
I elaborated a litle on why here: https://news.ycombinator.com/item?id=24607664
but boils down to; - enormous performance difference - advanced/fine grained user roles (+default permissions, not settable without superuser) - use of extensions (productivity boosts for us come from; Oracle FDW, TDS FDS, TimescaleDB) - private network endpoints - lower cost
Re: Ask HN: Do you self-host your database?
#100For personal use and side projects, I always self-host. It's so much cheaper considering the tiny size. I usually start with sqlite instead of the "real" database, and in 99% of the cases it stays so. At work, I never self-host. Life is so much easier if blame for whatever unrelated reason can be outsourced to some cloud provider or internal datacenter team. Because if we self host the database, we will be responsibl…
I definitely have a preference to have my own database for the purpose of development so I can change the structure, data and such as I need. It is kind of a necessity for developing a good suite of functional tests. All too often I have seen companies share a development database and that is a really bad sign for testability and generally stepping on each other.
So if that is managed elsewhere but I can do all I need that is fine, if not then I tend to host a database locally for this purpose.