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 […]

Tropeçando 72

A simple JSON difference function A function that would take two JSONB objects in PostgreSQL, and return how the left-hand side differs from the right-hand side. Deadlocks in PostgreSQL Compreenda os tipos de lock existentes no PostgreSQL, como ocorre um deadlock e pesquisar o causador do lock. PG Phriday: COPY and Alternative Import Methods Alternativa […]

Tropeçando 71

PG Phriday: Displaced Durability Há tabelas que possuem dados com os quais você não se importa de perdê-los. São situações de dados transientes, como áreas de dados passageiros, tabelas temporárias persistentes, tabelas com dados crus de importação. Por quê não aproveitar o fato do PostgreSQL oferecer a opção de ser UNLOGGED? Ainda mais porque pode-se […]

Codility – PermMissingElem

I scored 100% in #php on @Codility! https://codility.com/demo/take-sample-test/perm_missing_elem/ Training ticket Session ID: trainingWEF9F8-YEU Time limit: 120 min. Status: closed Created on: 2016-01-17 03:25 UTC Started on: 2016-01-17 03:25 UTC Finished on: 2016-01-17 03:40 UTC Training ticket (real finishing time) Session ID: trainingCSVQV7-4KF Time limit: 120 min. Status: closed Created on: 2016-01-17 04:29 UTC Started on: […]