12

在 ZFS 上跑 PostgreSQL 的調校

 3 years ago
source link: https://blog.gslin.org/archives/2022/01/01/10486/%e5%9c%a8-zfs-%e4%b8%8a%e8%b7%91-postgresql-%e7%9a%84%e8%aa%bf%e6%a0%a1/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

在 ZFS 上跑 PostgreSQL 的調校

在「Everything I've seen on optimizing Postgres on ZFS」這邊看到如果要在 ZFS 上面跑 PostgreSQL 時的調校方式，看起來作者有一直在更新這篇，所以需要的時候可以跑去看...

主要的族群是要搞 self-hosted PostgreSQL 的人，相較於 ext4 或是 XFS，底層如果使用 ZFS 可以做許多事情，像是 compression 與 snapshot，這對於很多 DBA 相關的操作會方便不少，但也因為 ZFS 的關係，兩邊 (& PostgreSQL) 需要一起調整以確保效能...

不過短期應該還是用 RDS 就是了...

Related

PostgreSQL 14 支援的 LZ4 壓縮

在 Hacker News 上看到 PostgreSQL 14 新支援的 LZ4 壓縮：「The LZ4 introduced in PostgreSQL 14 provides faster compression (fastware.com)」，在討論裡面反而有提到可以用 ZFS 的壓縮，這樣所有的資料 (包括 index) 都可以被壓縮： If you are using ZFS, I strongly recommend using LZ4 or ZSTD compression with PostgreSQL. Performance is still awesome. On average I get 2x compressionratio with LZ4…

November 10, 2021

In "Computer"

在本機用 pip 直接安裝 PostgreSQL server

看到 PostgreSQL 官方站台上的介紹，可以直接用 Python 的 pip 指令安裝 PostgreSQL server：「Install a local, non-root PostgreSQL Server with Python "pip"」，專案在「postgresql-wheel」這邊。 照 GitHub 上面的說明跑了一下，還真的可以惡搞... 這樣如果真的要在 CI 裡面跑的話也簡單很多了？只要能 pip 裝軟體就能跟你拼 XDDD 也省掉需要設定一些權限跑 Docker-in-Docker...

September 2, 2021

In "Computer"

MySQL ALTER TABLE

《瑪莉亞的凝望》第三本看到一半，到 Twitter 上看到 Jeremy Zawodny (O'Reilly 出的 High Performance MySQL 第一版與第二版的作者之一) 在喊 MySQL ALTER TABLE 跑了八天了： I have an ALTER TABLE running for nearly 8 days now... yikes. 結果 Aaron Brazell 居然很機車的這樣問他 XDDD @jzawodn Removing South Carolina from all Craigslist tables? 如果不清楚 Craigslist 與南卡的新聞，可以參考紐約時報「Under Pressure, Craigslist to Remove ‘Erotic’ Ads」這篇的說明。…

May 27, 2009

In "Computer"

a611ee8db44c8d03a20edf0bf5a71d80?s=49&d=identicon&r=gAuthor Gea-Suan LinPosted on January 1, 2022Categories Computer, Database, Linux, Murmuring, OS, PostgreSQL, SoftwareTags database, db, filesystem, linux, performance, postgresql, rdbms, tuning, zfs

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Notify me of follow-up comments by email.

Notify me of new posts by email.

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)

Post navigation


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK