Crashing the index with #PostgreSQL custom types
https://brokenco.de/2026/08/14/custom-types-index.html
検索
An ASP.NET Core Web API of my authorship to access and manipulate project data using EF Core, and JWT on a PostgreSQL or SQL Server database.
https://github.com/rperez-rosario/XPM_Server
#programming #webapi #postgresql #sqlserver #ef #aspnetcore
One of the vendors we use switched from #mongo to #postgresql and since we're running it all on Kubernetes, it was an... interesting experience. I'm not going to say it was easier or harder, but just that the challenges and tedious points are a little different. But most importantly, I got it to work, in no small thanks to #Percona tools.
📘 Big news! My book-in-progress "PostgreSQL Mistakes and How to Avoid Them" is now available in @[email protected] Early Access Program (MEAP) — I hope it will help application developers, software architects & database administrators not only avoid mistakes but also learn the right way to do things in #Postgres.
Use code "mlangelakos" to get 45% off 💕 — valid until February 27th!
http://mng.bz/D9mR
#PostgreSQL #Manning #MEAP #Development #Databases #OpenSource #TechBooks #BookLaunch
Aurora for PostgreSQL で拡張機能管理の委任ができるようになりました
https://dev.classmethod.jp/articles/aurora-for-postgresql-extension/
#dev_classmethod #PostgreSQL #Amazon_Aurora
Docker が俺の Postgres を勝手に全世界に公開しやがって色々怒られた話
https://qiita.com/isso_719/items/c22e617986c821b2f624?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
#qiita #PostgreSQL #iptables #Docker #やらかし #AdventCalendar2023
Aurora PostgreSQL から Amazon Bedrock へ直接アクセスできるようになりました
https://dev.classmethod.jp/articles/amazon-aurora-postgresql-bedrock-ml2/
#dev_classmethod #Amazon_Aurora #PostgreSQL #Amazon_Bedrock #生成AI
Do you really need foreign keys?
https://www.shayon.dev/post/2023/355/do-you-really-need-foreign-keys/
#ycombinator #tech #database #PostgreSQL #rails #foreign_keys
Do you really need Foreign Keys?
https://www.shayon.dev/post/2023/355/do-you-really-need-foreign-keys/
#ycombinator #tech #database #PostgreSQL #rails #foreign_keys
Couldn't be prouder to announce the release of the PostgreSQL 16 Administration Cookbook! Massive thanks to my co-authors Gianni Ciolli, Boriss Mejías @[email protected], Vibhor Kumar and Simon Riggs, and Packt for a spectacular effort on a book that is bound to be a valuable resource for the #PostgreSQL community.
🌐 Amazon: https://packt.link/6PurB
🌐 Packt: https://www.packtpub.com/product/postgresql-16-administration-cookbook/9781835460580
🌐 Amazon UK: https://www.amazon.co.uk/PostgreSQL-Administration-Cookbook-real-world-challenges/dp/1835460585
#postgres #opensource #database #databases #administration #dba #book #cookbook
.dev:spi:min_wal_size WALの最低サイズ。Misskey運用時は推奨値とされるサイズよりも多めが良さそう?max_wal_size checkpoint_timeoutに限らずこの数値を超えるとチェックポイント処理が開始される。小さすぎると必要以上にチェックポイント処理が頻繫に起きるので何らかの要因で急激に増えてもスペース問題ないサイズが良さそう?
:postgresql: #PostgreSQL調整メモ :khi:返信元:
Sometimes #postgresql feels like the #emacs of #databases. It has so many crazy features and yet I've never had comfortable muscle memory in it, so it always takes me longer to do about anything vs some flavor of #mysql (or #vim, depending on which tract you followed to get here).
@[email protected]
Same for me but twisted. My brain just cannot fathom emacs while vim is completely natural, and also #PostgreSQL is second nature to me.
Sometimes #postgresql feels like the #emacs of #databases. It has so many crazy features and yet I've never had comfortable muscle memory in it, so it always takes me longer to do about anything vs some flavor of #mysql (or #vim, depending on which tract you followed to get here).