Tropeçando 85

Good Engineering Practices while Working Solo How Much maintenance_work_mem Do I Need? While I generally like PostgreSQL’s documentation quite a bit, there are some areas where it is not nearly specific enough for users to understand what they need to do. The documentation for maintenance_work_mem is one of those places. It says, and I quote, […]

Tropeçando 83

PostgreSQL Tuning: Key Things to Drive Performance Performance is one of the key requirements in software architecture design, and has been the focus of PostgreSQL developers since its beginnings Illuminate your career If you are a developer, this article is for you. 5 Things You Have Never Done with a REST Specification How to to […]

Tropeçando 81

ACME Support in Apache HTTP Server Project We’re excited that support for getting and managing TLS certificates via the ACME protocol is coming to the Apache HTTP Server Project (httpd). ACME is the protocol used by Let’s Encrypt, and hopefully other Certificate Authorities in the future. We anticipate this feature will significantly aid the adoption […]

Tropeçando 79

Plan for the unexpected: install diagnostic tools on your PostgreSQL servers There’s a lot of information out there on how to configure PostgreSQL, on the importance of backups and testing them, etc. But what about the server you run PostgreSQL on? We tend to pay a lot less attention to tools that you won’t need […]

Tropeçando 77

How to Measure Execution Time in Node.js Design Pattern Workshop Recently on the pgsql-performance mailing list, a question popped up regarding Postgres RAM usage. In this instance Pietro wondered why Postgres wasn’t using more RAM, and why his process was taking so long. There were a few insightful replies, and they’re each interesting for reasons […]

Tropeçando 76

Crie um proxy SOCKS em um servidor Linux com SSH para ignorar filtros de conteúdo O método mais rápido para melhorar o desempenho de qualquer Servidor de Aplicações Web PHP usando MySQL ou PostgreSQL Getting first and last values per group Every so often someone needs solution to getting first (or couple of first) values […]

Tropeçando 75

Dply – Serviço permite criar um servidor Linux na nuvem que fica disponível por 2 horas gratuitamente Promise Anti-patterns Promises are very simple once you get your head around them, but there are a few gotchas that can leave you with your head scratching. Here are a few that got me. PG Phriday: Why Postgres […]

Tropeçando 73

Tables and indexes vs. HDD and SSD Although in the future most database servers (particularly those handling OLTP-like workloads) will use a flash-based storage, we’re not there yet – flash storage is still considerably more expensive than traditional hard drives, and so many systems use a mix of SSD and HDD drives. pgBackRest 1.0 Released […]