https://habr.com/ru/companies/postgrespro/articles/904224/?utm_source=habrahabr&utm_medium=rss&utm_campaign=904224
#postgresql #postgresql #performance #postgres #dbms #rdbms #data #bases #субд #рсубд #базы
Result Details
Dear #lazyverse: I have a #PostgreSQL #question!
I like to migrate a "horizontal" schema (some tables, many columns) to a "vertical" layout (few tables, few columns). The amount of data does not change, of course.
Now the overhead per row seems to be pretty high and the #database starts to eat all my #diskspace. Vacuum does not show an effect on it.
Any idea or hint? TIA!
Stop by and see our CEO @c2main present on using #Linux container groups to improve #PostgreSQL system performance and automation at #PGConfDev in #Montreal tomorrow, May 14th. He'd be happy to chat with you about questions and thoughts relating to #Postgres development, research, and projects!
Is anyone else old enough to remember the Dark Ages when file systems limited names to the 8.3 notation?
Back then there were some database products I worked with that had similar restrictions for table names and column names, etc.
But those days are so far behind us.
I know "naming things is hard". But I cringe when I see vague, ambiguous names like "xyz".
It's 2025, folks. Go ahead and spell out XylophoneYomamaZygote so we know what your intent is.
Totally forgot that Laravel News published my new package for modernising the old Laravel Seeder:
Periodic reminder: ORMs are horrible for SQL Server performance once you unleash your code in the real world.
In the hands of the vast majority of developers, it's a never-ending onslaught of implicit conversions, table scans, and non-SARG-able queries.
I picked Redis for my personal website storage initially because it seemed simple. Just push docs and JSON blobs in and it Just WorksTM.
Right now I'm converting to MariaDB, in case you wanna know how I feel about my original storage decision right now.
Nice SQL Server performance victory for me today. I identified a SQL Agent job that truncates and populates two unused tables every five minutes. Each table had about a half million rows.
The fastest code is the code that never runs.
PostgreSQL, we've generally heard, is "good enough" for most intents and purposes.
We'd love to know what YOU think. What's stopped you from using #PostgreSQL in the past, and what solution did you choose instead? When have you opted for #Postgres where it turned out better than expected?
Sigh. My SQL Servers often feel like NoSQL data dumpsters.
Cloudflare Workers 提供的 MySQL/MariaDB 方案
在「Build global MySQL apps using Cloudflare Workers and Hyperdrive」這邊看到 Cloudflare 提供了 Cloudflare Workers 使用 MySQL/MariaDB 的方案。 本來以為是做出了 replicated globally 的系統,還在想要怎麼處理 ACID 問題,花了點時間看完才發現是弄出了一個類似 ProxySQL 的架構,最終還是要連回某個區域的 MySQL 主機上,可能是 AWS、GCP、Azure 或是自己的 MySQL 伺服器: Now, you can create new Hyperdrive c…
Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
A Relational Model of Data for Large Shared Data Banks - E.F. Codd, 1970
* introduced a revolutionary approach to database design
* fundamentally changed how we store/access data
* rather than complex hierarchical structures, organized data into tables (relations) w. rows/columns
* manipulated through well-defined operations
...
https://fermatslibrary.com/s/a-relational-model-of-data-for-large-shared-data-banks#email-newsletter
New problem, new library! This time, I made a small utility for Laravel to limit a group of models on the table.
https://github.com/Laragear/Capstone
I talked about the implementation on my Medium blog, but in a nutshell, it uses a subquery to keep only the records you don't want to delete, like the latest five.
Django 5.2 支援 composite primary key
看到 Django 5.2 的公告,裡面列出了比較重大的改變,其中一個注意到的是支援 Composite (Compound) Primary Key 了:「Django 5.2 released」,完整的 release notes 則是在「Django 5.2 release notes」這邊可以看到。 就是因為這些 ORM library 不支援 compsite primary key,所以才會有 best (?) practice 要求每個表格都要有 primary key,而且是單一欄位... 大家應該都習以為常了,怎麼會突然在 2025 年才想要支援? …
Ugh. We have > 7,000 database tables with a column named [ID].
This is true, even on days not dated April 1st.