Tag: PostgreSQL

Feed: Planet PostgreSQL. I want to take a few minutes for a deep dive into the effect your data model has on storage density when using PostgreSQL. When this topic came up with a customer, I explained my thoughts on the matter, but I realized at the time that I had never done a reasonably careful apples-to-apples test to see just exactly what the effect is, at least for a model sample size of one. So here it is ... Read More

Feed: Planet PostgreSQL. Common table expressions, aka CTEs, aka WITH queries, are not only the gateway to writing recursive SQL queries, but also help developers write maintainable SQL. WITH query clauses can help developers who are more comfortable writing in imperative languages to feel more comfortable writing SQL, as well as help reduce writing redundant code by reusing a particular common table expressions multiple times in a query.A new patch, scheduled to be a part of PostgreSQL 12 major release later in the year, introduces the ability, under certain conditions, to inline common table expressions within a query. This is a huge ... Read More

Feed: What's New. With this update, a new Restricted Password Management feature is introduced for PostgreSQL 10.6. Using a new parameter and a special role, you can limit database user password changes to members of the role, thereby enabling greater control over password management on the client side (e.g. expiry requirements, complexity requirements). This release is available in the US East (N. Virginia), US East (Ohio), US West (Oregon), Asia Pacific (Seoul), Asia Pacific (Sydney), Asia Pacific (Tokyo), EU (Ireland), and EU (Frankfurt) regions. For additional release details, see the Release Notes. Amazon Aurora combines the performance and availability of ... Read More

Feed: Planet MySQL; Author: Severalnines; Since the concept of cloud was born, there has been strong growth in the number of migrations to this environment. However, not everything that shines is gold. As the demand grows, so does the costs. We can find ourselves in a situation where our monthly cloud expenses are very high and, in this case, it may make sense to migrate back to an on-prem environment. The costs may not be the only reason. There might be security or compliance requirements, or we may need to have more control of our systems. Knowing what happens at ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; If you work with MySQL or PostgreSQL, you probably at least heard about PMM (Percona Monitoring and Management). If you want to test it, you may also be interested in this article: I’ll show you how to setup a MySQL and a MariaDB instance and monitor them in the quickest way. Which is Docker. Docker is also my favourite way of running PMM in production. To be clear, I wouldn’t run a production DBMS in Docker. But now we are talking to test something quickly on your laptop, without wasting too much time. And ... Read More

Feed: Planet MySQL; Author: Severalnines; How to Monitor MySQL Databases? Operational visibility is a must in any production environment. It is crucial to be able to identify any issues as soon as possible, otherwise you may end up in serious troubles as an undetected issue can cause serious service disruption or downtime. MySQL Enterprise Monitor is one of the oldest monitoring products for MySQL on the market, and is available as part of an commercial enterprise subscription agreement from Oracle.In this blog post we will take a look at MySQL Enterprise Monitor and the kind of insight it provides into ... Read More

Feed: Planet MySQL; Author: Severalnines; The introduction of DevOps in organizations has changed the development process and also introduced some new challenges. In addition, developers and DevOps teams, along with their own chosen programming languages, also have their favorite database systems. The product life cycle is getting shorter each year so developers want to be able to develop fast, using technologies they know best. Having multiple RDBMS database backends means your organization will become more agile on the development side, but it also imposes additional knowledge on the operation teams. Extending your infrastructure from one to many databases implies you ... Read More

Feed: Planet PostgreSQL. I wrote yesterday about Vitess, a scale-out sharding solution for MySQL. Another similar product is Citus, which is a scale-out sharding solution for PostgreSQL. Similar to Vitess, Citus is successfully being used to solve problems of scale and performance that have previously required a lot of custom-built middleware. Citus solves the following problems for users: Sharding. Citus handles all of the sharding, so applications do not need to be shard-aware. Multi-tenancy. Applications built to colocate multiple customers’ databases on a shared cluster—like most SaaS applications—are called multi-tenant. Sharding, scaling, resharding, rebalancing, and so on are common pain ... Read More

Feed: Planet PostgreSQL. PosgreSQL 11 was released four months ago and my review is long overdue. Here we go!With respect to standard SQL, the main theme in PostgreSQL 11 is window functions (over). For almost eight years, from 2009 until 2017, PostgreSQL was the only major free open-source product to support SQL window functions. Just a year later, by September 2018, all open-source competitors have caught up…and some even overtook PostgreSQL. The PostgreSQL community was prepared. PostgreSQL 11 was just released in 2018, and it has restored and even expanded its leadership position.This article explains this race and covers other ... Read More

Feed: Planet PostgreSQL. PREVIOUS POST PostgreSQL is emerging as the standard destination for database migrations from proprietary databases. As a consequence, there is an increase in demand for database side code migration and associated performance troubleshooting. One might be able to trace the latency to a plsql function, but explaining what happens within a function could be a difficult question. Things get messier when you know the function call is taking time, but within that function there are calls to other functions as part of its body. It is a very challenging question to identify which line inside a function—or ... Read More