#postgres
4 posts · filter on the home page
- Egres: A Postgres-compatible database for heavy, multi-tenant workloadsI love Postgres. It is an incredible database. But, its design is also 30 years old and most of what people fight in production comes from decisions made long time ago: VACUUM, transaction id wraparound, bloat, a process per connection…
- Enabling Remote Access to PostgresTo allow Postgres connections from a remote server, or from within a docker container, you'd want to allow it to listen to external traffic. This requires doing two settings, one in
- Running PostgreSQL on Ubuntu as non-Postgres User: The Definitive GuideWe're running Postgres for the production deployment of Struct, a (not-yet-launched) chat platform we're building to deal with the disorganized chaos of live communication. I'm using PostgreSQL to store the data -- which I have started to…
- Postgres 15 on Encrypted ZFS and Ubuntu 22.04 LTSI'm using Postgres for my new startup. The startup is still in stealth mode, so I can't talk about it much. But, given the focus of the startup is on communication platforms, Postgres made a lot of sense. This is the first time I've ever…