micktwomey + postgresql + postgres   17

yandex/odyssey: Scalable PostgreSQL connection pooler
Advanced multi-threaded PostgreSQL connection pooler and request router.

postgresql  postgres  database 
june 2018 by micktwomey
Top Backup Tools for PostgreSQL | Severalnines
Examples of different backup tools for PostgreSQL (pgBackRest, Barman, Amanda).
postgresql  postgres  tools 
april 2018 by micktwomey
PostgreSQL rocks, except when it blocks: Understanding locks
Handy, covers PG locking discussions I normally have with developers :)
One problem I often see users struggle with when it comes to Postgres is locks. While Postgres is amazing at running multiple operations at the same time, there are a few cases in which Postgres needs to block an operation using a lock. You therefore have to be careful about which locks your transactions take, but with the high-level abstractions that PostgreSQL provides, it can be difficult to know exactly what will happen. This post aims to demystify the locking behaviors in Postgres, and to give advice on how to avoid common problems.
postgres  postgresql 
february 2018 by micktwomey
Principles and Applications of the Index Types Supported by PostgreSQL
PostgreSQL has different index interfaces for different data types and business scenarios. Let’s introduce the principles and application scenarios for each index.
postgresql  postgres 
february 2018 by micktwomey
Cybertec Postgres Configurator
Enter in some specs and details on the workloads and you get a sample PostgreSQL config.
postgresql  postgres  tool  configuration 
january 2018 by micktwomey
Experiences with running PostgreSQL on Kubernetes
Below is a transcript of an interview I had with our CTO, Sasha Klizhentas, about his experience running PostgreSQL on Kubernetes. In this interview, we discuss the challenges involved, open source and commercial tools that can help and other alternatives to managing stateful applications on Kubernetes.

For some background, Gravitational specializes in running applications across a variety of infrastructure footprints with the help of Kubernetes. The applications our customers deploy need a persistent data store to go along with their stateless microservices. Making things more complicated is the fact that the majority of our deployments are on-premise private SaaS, so we can not rely on cloud services like AWS RDS.
postgresql  kubernetes  docker  postgres 
january 2018 by micktwomey
Understanding caching in Postgres - An in-depth guide | Madusudanan
Caching can be considered an important aspect in tuning database system performance.

While this post is mainly focused on postgres, it can be easily compared and understood with other database systems.
database  postgresql  postgres 
october 2017 by micktwomey
What is Barman? What problem resolves?
Barman allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity. Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.
backup  postgres  postgresql  tool 
august 2017 by micktwomey
Getting Started with Event Sourcing in Postgres – BackerKit Blog
In a previous post we explored how our application tracks sent emails. We set things up to update or insert a record for each email with the current state (delivered, dropped, etc). In this post we’ll look at an alternative data model where we’ll store each event as its own record and then roll up the events to get the current state of a particular email.

With this different modeling we’ll be able to understand the full lifecycle of an email allowing us to debug issues better as well as have a better understanding of how our users interact with our emails. In our original setup we could only know about the most recent email event. We’ll use the concept of event sourcing to maintain this history.
database  postgres  postgresql 
august 2017 by micktwomey
Postgres EXPLAIN Visualizer (pev)
Pev is designed to make Postgres query plans easier to grok. It displays a plan as a tree, with each node representing a step that takes in a row set and produces another.
database  postgres  visualization  postgresql  psql 
july 2017 by micktwomey
The big old reliable elephant: talking about Postgres with Craig Kerstiens

In this opportunity I interviewed Craig Kerstiens. Craig works for citusdata, a company that helps customers scale databases beyond a single node.
postgres  postgresql  citusdata  sql  dbs 
april 2017 by micktwomey
PGCon2016: Index Internals
PostgreSQL includes several index types: GiST, SP-GiST, GIN, and of course, the regular B-tree. DBAs are familiar with using each of these for specific use cases, GIN for full-text search, GiST for geometrical data, and so on, but how do they work internally? What makes them suitable for the cases they're typically used for?

In this presentation, I will walk through the internal structure of each of these index types, explaining what strengths and weaknesses each one of them have.
database  postgres  postgresql  sql 
august 2016 by micktwomey
REST API for any Postgres database
api  database  postgres  postgresql  rest  haskell 
january 2015 by micktwomey
MySQL to PostgreSQL translation tool which is fast? Sign me up :)
postgresql  postgres  mysql  tools 
january 2015 by micktwomey

Copy this bookmark: