HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Vonng

no profile record

Submissions

MinIO Is Dead, Long Live MinIO

vonng.com
2 points·by Vonng·5 miesięcy temu·1 comments

Show HN: PostgreSQL Extension Cloud

pgext.cloud
2 points·by Vonng·8 miesięcy temu·0 comments

When Postgres Falls for DuckDB

pigsty.io
3 points·by Vonng·w zeszłym roku·0 comments

Show HN: Pig – PostgreSQL Extension Manager on Linux, 340 ext on 10 distro

github.com
2 points·by Vonng·2 lata temu·0 comments

The idea way to install PostgreSQL extensions?

medium.com
1 points·by Vonng·2 lata temu·0 comments

Show HN: Self-Hosting Supabase on Your Own Postgres RDS

pigsty.io
5 points·by Vonng·2 lata temu·0 comments

PostgreSQL Extension Pedia, with 345 out-of-box RPM/DEB packages available

ext.pigsty.io
2 points·by Vonng·2 lata temu·0 comments

The 333 PostgreSQL Extensions available as out-of-box RPM/DEB packages

pigsty.io
9 points·by Vonng·2 lata temu·2 comments

Database in Kubernetes: Is that a good idea?

pigsty.io
2 points·by Vonng·2 lata temu·0 comments

Postgres is eating the database world

medium.com
281 points·by Vonng·2 lata temu·142 comments

comments

Vonng
·5 miesięcy temu·discuss
you're right, OpenTofu forked from the last MPL version of Terraform, not BSL. My mistake — I'll correct the post.
Vonng
·5 miesięcy temu·discuss
Author here.

• This is translated from my original Chinese post. I used Claude to polish the English — not a native speaker. Fair criticism on the LLM-ese; I'll tighten it.

• This fork exists because MinIO is a production dep in my PG distribution (Pigsty) and I needed working binaries + CVE patches. It's primarily for my own use; sharing it because others may have the same problem.

• We're deliberately conservative — no new features, just a drop-in replacement that behaves like the last OSS release with the console restored. Early commits will look thin.
Vonng
·5 miesięcy temu·discuss
A minio community fork with admin console back, CI/CD pipeline for Docker/RPM/DEB packages.
Vonng
·w zeszłym roku·discuss
Author here. The post here is a 3rd-party translation and may drifts from original wording in a few spots. Azure and OpenAI sent me some corrections today, so I published an updated English version myself here: https://pigsty.io/blog/db/openai-pg/
Vonng
·w zeszłym roku·discuss
BTW for anyone who interested, I've packed pg_search and vchord_bm25 extension RPM/DEBs https://pigsty.io/ext/fts/vchord_bm25 https://pigsty.io/ext/fts/pg_search In case anyone want to benchmark by themselves. ;)
Vonng
·w zeszłym roku·discuss
There are 351 available rpm/deb postgres extensions which can do really a lot of things: https://ext.pigsty.io/#/
Vonng
·2 lata temu·discuss
I fully support ParadeDB's decision. For an open-source software company, AGPLv3 + Dual License is the most sensible choice.

If you go with Apache 2.0, you're literally doing free work for cloud vendors.
Vonng
·2 lata temu·discuss
I've set up a supplementary APT/YUM repository, which builds on the official PGDG offerings. This includes 326 extensions for EL distros and 312 for Deb distros, encompassing 121 RPM packages and 133 DEB packages.

These packages support PG16 extensions across Ubuntu 22.04, Debian 12, EL8, and EL9. My efforts have been particularly focused on align OS-specific extensions across the major Linux distributions to ensure a consistent feature set.

For those who are interested, you can browse the PostgreSQL extension catalog here: (https://pigsty.io/docs/pgext/list/). Additionally, I've maintained a public Yum/Apt repository hosted on Cloudflare: https://pigsty.io/docs/pgext/usage/repo/

I'm keen to hear your thoughts and would greatly appreciate any feedback from those who have utilized these extensions.
Vonng
·2 lata temu·discuss
Why not continue to use rpm/apt for building and packaging? You can reuse these packages in the Dockerfile and the image, but not the other way around.
Vonng
·2 lata temu·discuss
RDS is like 4~13x than EC2 on AWS, 2.3x than EC2 on aliyun. https://pigsty.io/blog/cloud/rds/

But The real cost lies on EBS, which is around 60x ~ 200x than local NVMe SSD. https://pigsty.io/blog/cloud/ebs/

https://pigsty.io/blog/cloud/bonus/
Vonng
·2 lata temu·discuss
How about: PostgreSQL tuned (x47). PostgreSQL + Hydra Extension (x42) PostgreSQL + ParadeDB Extension (x10.7)
Vonng
·2 lata temu·discuss
That's true for the kernel, How about extensions such as ParadeDB BM25 https://www.paradedb.com/ + PGroonga https://pgroonga.github.io/ + PG Bigm https://github.com/pgbigm/pg_bigm ?
Vonng
·2 lata temu·discuss
Patroni has native HA support for citus horizontal cluster since v3. Which means your can create a HA citus cluster as simple as: https://pigsty.io/docs/pgsql/config/#citus-cluster
Vonng
·2 lata temu·discuss
pg_hint_plan —— Give PostgreSQL ability to manually force some decisions in execution plans. https://github.com/ossc-db/pg_hint_plan