~hackernews | Bookmarks (9)

clear filters

postgres ×

Building a Managed Postgres Service in Rust

tembo.io

engineering postgres rust
2
Postgres vs. File Systems: A Performance Comparison (2022)

enterprisedb.com

One of the guiding Postgres design principles is heavy reliance on features provided by the environment...
One of the guiding Postgres design principles is heavy reliance on features provided by the environment (particularly operating system) and file systems are a prime example of this. Unlike other databases Postgres never supported raw devices, i.e. the ability to store data on block devices without creating a regular...

file systems i5 postgres postgresql throughput
1
Why Has Figma Reinvented the Wheel with PostgreSQL?

medium.com

A few weeks ago, Figma published an article introducing their own sharding solution for PostgreSQL. The...
A few weeks ago, Figma published an article introducing their own sharding solution for PostgreSQL. The Figma engineering team was aware of, and evaluated, several existing options that could have made their database layer horizontally scalable. But still, they decided to build their own sharding solution from scrat...

database distributed systems postgres postgresql yugabytedb
2
Researchers, please replace SQLite with DuckDB now

medium.com

You are a researcher, potentially in the life or social sciences, and your organization offers you...
You are a researcher, potentially in the life or social sciences, and your organization offers you access to a fast machine with many CPUs and lots of memory, potentially as part of a CPU cluster. You are familiar with Linux and use Python/Pandas and/or R to manipulate and analyze your data. You sometimes use SQLite...

duckdb postgres researchers sql sqlite
1
Postgres is eating the database world

medium.com

PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to...
PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a mainstream best practice.In a 2016 database meetup, I argued that a sig...

database extension infrastructure pigsty v2.6 postgres
1
Benchmarking PostgreSQL Connection Poolers: PgBouncer, PgCat and Supavisor

tembo.io

Creating a connection to your Postgres database to execute a short-lived query is expensive. Several people...
Creating a connection to your Postgres database to execute a short-lived query is expensive. Several people have measured the overhead of Postgres connections and some locate them in the range of 1.3MB of memory per connection and others in the range of 2MB. In addition, there is also the overhead of having to fork ...

connection pool pgbench pgbouncer pgcat postgres
1
The Jobs to Be Done by the Ideal Postgres Extension Ecosystem

tembo.io

The past year has seen a surge in interest in Postgres extension distribution. A number of...
The past year has seen a surge in interest in Postgres extension distribution. A number of people have noted in particular the challenges in finding and installing extensions. PGXN, released way back in 2011, aimed to be the canonical registry for the community, but currently indexes only the 350 distributions that ...

architecture distribution ecosystem extensions packaging
1
Why Postgres RDS didn't work for us

medium.com

We were building a startup that measured marketing effectivness via a statistical attribution model. For this...
We were building a startup that measured marketing effectivness via a statistical attribution model. For this to work we had to collect a ton of online user behavior. Every click, every field input, every action. Data was stored in postgres and end users, via our UI, ran dashboards and reports that crunched the abov...

aws aws rds big data postgres postgresql
1
Multitenant SaaS with Postgres and Prisma made easy

thenile.dev

multi tenant database postgres serverless tenant aware
1

~hackernews | Bookmarks (9)

Tags

Domains

Building a Managed Postgres Service in Rust

Postgres vs. File Systems: A Performance Comparison (2022)

Why Has Figma Reinvented the Wheel with PostgreSQL?

Researchers, please replace SQLite with DuckDB now

Postgres is eating the database world

Benchmarking PostgreSQL Connection Poolers: PgBouncer, PgCat and Supavisor

The Jobs to Be Done by the Ideal Postgres Extension Ecosystem

Why Postgres RDS didn't work for us

Multitenant SaaS with Postgres and Prisma made easy