Top Tweets for #Postgresql
Cut Citus shard disk IO: convert distributed heap tables to columnar with zstd. Column chunks default 10000 rows, compressed per column, vectorized scans on workers. https://t.co/R3mNyLLORs
#citus #snippet #postgresql #python #devops #infra #redis #sharding #ValtersIT #infosec #SysAdmin #cybersecurity #Linux #devsecops #developer #100daysofcode #git #github #gitlab #redteam #blueteam #ethicalhacker #cybersecurityawareness #cybersecuritynews #cybersecuritytips #hacker #kali #ubuntu #debian #docker
Today's Postgres minors (18.7 down to 14.25) come with homework: reindex pg_trgm GiST and bpchar B-tree indexes, reindex GIN if suspect, new full backup if you use incrementals. The bpchar bug could give wrong results, not errors. That's the kind nobody notices.
#PostgreSQL #DBA
Latest #PostgreSQL minor releases are out: 𝟭𝟴.𝟳, 𝟭𝟳.𝟭𝟮, 𝟭𝟲.𝟭𝟲, 𝟭𝟱.𝟮𝟬, 𝟭𝟰.𝟮𝟱, along with 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 𝟭𝟵 𝗥𝗖 𝟮.
P.S. 14.25 is the final release of Postgres 14. If you're still on PG14, now's a good time to plan your upgrade.
https://t.co/qOLw4jOYKW
Another Career Success Story!
Our candidate joins a leading multinational company in India as a PostgreSQL Database Administrator!
Watch their journey with iXceed Solutions!
[email protected]
#iXceedSolutions #PostgreSQL #DatabaseAdministrator #CareerSuccess
Psycopg 3.2.9 is out 🚀 Async is now as fast as sync for large writes, UUIDs load 2.5x faster, Windows gets the C wait implementation, and packages are 15-40% smaller. Release notes and sponsor link in the comments 💛 #Psycopg #PostgreSQL #Python #OpenSource #Database
pg_stat_replication + pg_wal_lsn_diff give exact standby lag: sent_lsn, write_lsn, flush_lsn, replay_lsn. replay_lsn is the one that matters for read consistency. https://t.co/SwyeUAubLx
#postgresql #snippet #monitoring #python #devops #infra #redis #sharding #ValtersIT #infosec #SysAdmin #cybersecurity #Linux #devsecops #developer #100daysofcode #git #github #gitlab #redteam #blueteam #ethicalhacker #cybersecurityawareness #cybersecuritynews #cybersecuritytips #hacker #kali #ubuntu #debian #docker
#München! 🐘
#PostgreSQL Meetup Munich at AWS, today 17:30
1. Deploying Postgres in K8s by Dimitri Vanoverbeke
2. What’s New with Monitoring in PostgreSQL 19 by Gülçin Yildirim Jelinek
3. Open Alliance for PostgreSQL Education by Michael Banck
RSVP: https://t.co/gLSNCvsoRA
AI coding tools accelerate development, leaving less time for manual review of SQL queries and schemas.
When code moves fast, your underlying database layer becomes critical for security and stability.
#AICoding #DevTools #PostgreSQL #DataOps
WorkOS is hiring Experienced Software Engineer - Frontend
🔧 #typescript #react #api #css #postgresql
🌎 Europe; North America; South America
⏰ Full-time
🏢 WorkOS
Job details https://t.co/Tc0Bv0WLyv
#jobalert #jobsearch #hiring
Almost added MongoDB for dynamic fields.
After some R&D, PostgreSQL + JSONB did the job.
No extra database. Less complexity.
Sometimes, the best engineering decision is adding nothing.
#PostgreSQL #BackendDevelopment
CVE-2026-67449 (CRITICAL / 9.8) — Portabase is a database backup and restore tool for PostgreSQL, MySQL, MsSQL, MariaDB, Firebird SQL, SQLite, MongoDB, Re... https://t.co/Dtu5xdbtXZ #MySQL #PostgreSQL #MongoDB #Redis
PostgreSQL で作業の途中にエラーが出ると、その後の命令がすべて断られます。失敗したトランザクション(ひとまとまりの処理)は ROLLBACK で取り消すしかなく、SAVEPOINT(目印)を置けばそこまで戻せます。練習ターミナルで試せます。
https://t.co/CSVMO6uvhZ
#インフラ学習 #PostgreSQL
11/12 先行販売 『Just Use Postgres! PostgreSQLをもっと使いこなすための設計と実践』 #マイナビ出版 （9784839991456) #DenisMagda 著 「#データベース」棚にて！#PostgreSQL をもっと使いこなすための設計と実践。開発も、検索も分析もオープンソースのひとつのDBで。
Soft deletes break unique constraints. A deleted user's row keeps its email, so that email can never sign up again: UNIQUE(email) still sees it.
Fix: CREATE UNIQUE INDEX ON users (email) WHERE deleted_at IS NULL;
Do you soft delete or use an archive table?
#PostgreSQL #SQL
246 lines of Python that estimate PostgreSQL table bloat from dead tuples via psycopg2, no extensions. Advanced, for DBAs fighting autovacuum lag. #postgresql #python #database https://t.co/dM531oFSs7
#database #python #advanced #devops #infra #redis #sharding #ValtersIT #snippet #infosec #SysAdmin #cybersecurity #Linux #devsecops #developer #100daysofcode #git #github #gitlab #redteam #blueteam #ethicalhacker #cybersecurityawareness #cybersecuritynews #cybersecuritytips #hacker #kali #ubuntu #debian #docker
A versão 19 dos #postgreSQL traz várias mudanças. Neste post, a que dá para testar em minutos é o REPACK, um comando novo que reescreve uma tabela para devolver o espaço que ela não usa mais. Ele cumpre o papel do VACUUM FULL…
https://t.co/3Ebeh5ogjI
Landed my first Upwork contract
Building a supplier and procurement platform: suppliers, quotation requests, multi currency quote comparison, purchase order approvals, receiving and reports.
#TypeScript #Nextjs #PostgreSQL
Valentina Studio 18 auto-highlights SQL code changes when you change the diagram or builder inputs. Free version of the best database management software. https://t.co/HwFxVDcKD0
#datagrip #postgresql #sql
🛡️ MCP-#PostgreSQL-Ops 347 Just Made #PostgreSQL #AI Integration More Secure and Easier to Deploy + Video
-Fact Checker: ✅: 8 ❌: 0 || 8/8 → Score: 100% 🦾
-Prediction: 📈 5 Positive | 📉 3 Negative
https://t.co/nF0oNzrxre
Last Seen Hashtags on Sotwe
Most Popular Users
Elon Musk 
@elonmusk
241.3M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.4M followers
Kim Kardashian
@kimkardashian
70.8M followers
YouTube
@youtube
68.7M followers
Neymar Jr
@neymarjr
66.4M followers
Bill Gates
@billgates
65.2M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.6M followers