Bancos de dadosPlanet PostgreSQL
Bancos de dados
max_identifier_length reports a number, 63, and the number is the least interesting thing about it. Every relational database caps the length of a name. What is unusual about PostgreSQL is what happens when you go over: MySQL, SQL Server…
PostgreSQL won't let you pass more than 100 arguments to a function, and changing it requires rebuilding every extension on your machine.
PostgreSQL's max_files_per_process isn't a hard limit—it's a descriptor pool that quietly recycles old files when full.
PostgreSQL write amplification explained: why indexes multiply WAL volume, how to measure it on your tables, and four ways to reduce it without schema changes.