#postgresql
Greg Cocks I guess I need to rewrite this query 
#postgresql #pgadmin #testing
Jepsen：亞馬遜 RDS PostgreSQL 17.4 版本分析
➤ 亞馬遜 RDS PostgreSQL 的一致性問題：Jepsen 的詳細分析
✤ https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4
Jepsen 的測試揭示了亞馬遜 RDS for PostgreSQL 多可用區 (Multi-AZ) 叢集的資料一致性問題。儘管 PostgreSQL 支援快照隔離 (Snapshot Isolation) 作為最強的一致性模型，但測試顯示 RDS 多可用區叢集偶爾會出現長分叉 (Long Fork) 和其他非相鄰循環 (G-nonadjacent cycles) 等異常現象。這表明 RDS 可能僅提供平行快照隔離 (Parallel Snapshot Isolation)，這是一種較弱的一致性模型。此問題在 PostgreSQL 13.15 到 17.4 各版本中均存在。
+ 「這對依賴 RDS PostgreSQL 的應用程式來說是一個重要
#雲端資料庫 #PostgreSQL #一致性 #Jepsen
Hello FLOSS community!
Happy to share my first Medium post on deploying Stackgres on OCI with Tofu, along with other management tools like Traefik, external-dns and cert-manager!
The advantage of this is that we can have a Stackgres instance up&running in less than 20 minutes :)
All code is GPLv2, available on Codeberg - https://codeberg.org/yaroze/oci-k8s
Feedback welcome! :)
#kubernetes
#stackgres
#helm #oracle #oci #PostgreSQL #traefik #terraform #OpenTofu
Some issues/tips with #AWS io1/io2 and #PostgreSQL replicas.
For io1/2 volumes on AWS you get provisioned IOPS and burst IOPS. If you read the fine print, MBpS throughput is computed based on provisioned IOPS, and works out to something like 1MBpS/80iops.
Think is, the walreceiver actually does relatively few IOPS but high MBpS because it's writing 16mb WAL segments and block flushes on tables. So you have to overprovision a lot. You've been warned!
對 Amazon RDS for PostgreSQL 的 Jepsen 測試報告
Tired of writing complex SQL queries?
This video course section shows how to connect Vanna.AI to PostgreSQL, enabling natural language queries through Retrieval-Augmented Generation.
Ask your database questions in plain English and get instant insights - complete with visualizations. The future of database interaction is here!
https://link.illustris.org/connectingpgtovannaai
#PostgreSQL #VannaAI #RAG #DataEngineering http://vanna.ai/
Behold! Amazon's RDS for #PostgreSQL 17.4 brings you the exciting world of inconsistent databases, complete with bonus Long Forks and "Gnonadjacent" cycles! Who knew cloud-hosted chaos could be so much fun?
https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4 #AmazonRDS #InconsistentDatabases #CloudChaos #DatabaseFun #HackerNews #ngated
Русский след в истории логотипа PostgreSQL
Каждый, кто работает с PostgreSQL, знает его символ — синего слона. Но задумывались ли вы, откуда он взялся? Его история — это не результат работы дорогого брендингового агентства, а захватывающее повествование о зарождении IT-сообщества, питерских энтузиастах, случайных файлах и том, как «маленький презент» стал мировым символом. Узнать историю slonik.gif
VACUUM FULL in #PostgreSQL - What you need to be mindful of | Stormatics https://stormatics.tech/blogs/vacuum-full-in-postgresql
Русский след в истории логотипа PostgreSQL
Каждый, кто работает с PostgreSQL, знает его символ — синего слона. Но задумывались ли вы, откуда он взялся? Его история — это не результат работы дорогого брендингового агентства, а захватывающее повествование о зарождении IT-сообщества, питерских энтузиастах, случайных файлах и том, как «маленький презент» стал мировым символом. Узнать историю slonik.gif
PandaDoc is hiring Senior Python Engineer (Growth)
#python #django #aws #docker #kafka #kubernetes #postgresql #redis #seniorengineer
Remote; Poland
Full-time
PandaDoc
Job details https://jobsfordevelopers.com/jobs/senior-python-engineer-growth-at-pandadoc-com-feb-13-2025-1a7eca?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
How to ALTER tables without breaking application? #postgresql – select * from depesz; https://www.depesz.com/2024/12/12/how-to-alter-tables-without-breaking-application/
@remi
re:
> I'm querying records in batches. The tash processes each batch, and I do an `update_all(foo: [])` on all records in the current batch.
Is it possible to wrap all the into a single transaction? I don't know the details, but I'm assuming that `update_all` is against an ActiveRecord collection.
Its kind of documented as a known issue in #PostgreSQL
https://www.postgresql.org/docs/current/populate.html
(Under 14.4.1 Disable Autocommit)
Education and advocacy are top priorities for our Diversity Committee. Click the link below to find out more!
Planning to come to PGConf.DE next week in #Berlin for a day of #PostgreSQL networking & education? Don't forget to stop by and see @ehstanton from our team.
Learn about #Postgres application in the life sciences, along with typical research problems & key considerations such as #climate, COVID-19, #hydrology, and #neuroscience.
> if you update an indexed array-based column for 2M records, #PostgreSQL will recreate the 2M-record btree index 2M times.
Can you elaborate what or how are you doing that update? Is this a loop or a single DDL command?