Following the tracks meetup "New features of PostgreSQL 11"

Today we will talk about the most important features of PostgreSQL 11. Why only about them - because some features are not needed by all, so we stopped at the most popular.
 
 

Table of contents


 
Following the tracks meetup "New features of PostgreSQL 11"
 
 
JIT-compilation
 
Sectioning
 
Indices
 
Covering indices
 
SP GiST
 
Productivity
 
WAL
 
Backup and replication
 
For DBA
 
Parallel execution of
 
Optimizers
 
Window functions
 
Changes in the full-text search
 
Json (b) and the full text of
 
...[/h]
+ 0 -

Oil and gas dilemma: in search of alternative DBMS

Oil and gas dilemma: in search of alternative DBMS
 
As you know, at the beginning of this year, the US corporation Oracle, in accordance with the requirements of the US government to tighten sanctions against Russian oil and gas companies, changed the conditions for the provision of its products and services. The ban on both new transactions and the extension of existing contracts was introduced. These restrictions directly relate to many oil and gas structures, including enterprises of Gazprom, Rosneft, Lukoil and Surgutneftegaz. 283 Russian companies got under the sanctions.
 
 
In particular, Oracle introduces a ban on the provision, export or re-export ...
+ 0 -

How do I measure the evolution of admins in programmers

How do I measure the evolution of admins in programmers  
Recently, my friend Karl (name changed) was interviewed for the position of DevOps and asked me to check his decision. I read the condition of the problem and decided that a good test would come out of it, so I extended the task a little and wrote my own implementation, and at the same time asked my colleague Alex to think about my own implementation. When all three options were ready, I made two more comparative versions in C # and sat down to write this article. The task is quite simple, and applicants are at some stages of evolution from administrators to programmers, which I wanted to evaluate.
 
Who ...
+ 0 -

Webinar: Planning the Apache Ignite cluster capacity on live examples

In the previous post we considered the principal approaches to assessing the capacity of the cluster and spoke very little about optimization. For fans to look "under the hood" Alexey Goncharuk 29 May will hold webinar with live examples :
 
 
 
Where does overhead come from when writing data?
 
Optimization techniques;
 
How to plan the capacity of the cluster Apache Ignite;
 
Improvements that await you in the next releases.
 
 
The webinar will be interesting for those who plan to use Apache Ignite in a real project and want to evaluate the hardware configuration or the amount ...
+ 0 -

Development API Clickhouse for the Rambler /top-100

Development API Clickhouse for the Rambler /top-100  
 
Still know what is the Rambler /top-100? Just in case, it's a web analytics service. Our users put a counter on their sites, and we, in turn, prepare all necessary visitor statistics in the form of a set of standard reports. Below the story is the story of Vitaly Samigullin, the head of the technology group Rambler /top-10? about how we developed the ClickHouse API in Python and why we started all this. Clickhouse? First, we have had some changes in the data processing process. The general scheme of the service now looks like this.
 
 
...
+ 0 -

We invite you to the mtap "New features of PostgreSQL 11"

We invite you to the mtap "New features of PostgreSQL 11"
 
 
Friends, a little more than a month ago ended with a commitefest and it became clear what new opportunities we will enjoy PostgreSQL's fall release. We have already started talking about INCLUDE-indices , the built-in web search , improvements in casting .
 
 
And now, together with Raiffeisenbank, migrated to PostgreSQL a number of systems, we decided to conduct an open Mitap on new features in PostgeSQL 11.
 
 
We are waiting for you on May 23 at 6 pm in the Nagatinsky office of Raiffeisenbank at Moscow, Andropov Avenue 1? building 2.
 

 
The entrance is free. ...
+ 0 -

noBackend, or How to survive in the era of fat clients

noBackend, or How to survive in the era of fat clientsThe title of the article should not be taken literally:
backend has not gone anywhere
, simply the focus of development - especially at the initial stage of the development of a new project - is strongly shifted towards "
client part
". There is a great temptation to take something understandable for data storage and already "bound" REST API, to give up PHP /Python /Ruby /Java /etc as much as possible, to write 80% of the code "on the client side", minimally worrying about the "server side" ".
 
 
This article is based on the report
Nikolay Samokhvalov
, which, in turn, summarized the experience ...
+ 0 -

Fuzzy search in relational databases

To search for relevant information on websites and mobile applications, it is often necessary to search by words or phrases that the user freely enters from the keyboard (rather than selecting from the list for example). Naturally, the user can make mistakes and typos. In this case, full-text search, full-text indexes that are implemented in most databases do not give the expected result and are practically useless. Such functionality is increasingly implemented based on elasticsearch.
 
 
Solutions using elasticsearch have one significant drawback - a very high probability of mismatching the main ...
+ 0 -

The BaselineTopology concept in Apache Ignite 2.4

The BaselineTopology concept in Apache Ignite 2.4
 
At the time of the appearance in the Apache Software Foundation of the Ignite project, it was positioned as a clean in-memory-solution: a distributed cache that raised data from a traditional database in memory to gain access time. But already in the release 2.1 there was a built-in persistence module ( Native Persistence ), Which allows to classify Ignite as a full-fledged distributed database. Since then, Ignite has ceased to depend on external systems to ensure persistent storage of data, and a bundle of rakes configuration ...
+ 0 -

Compare Tarantool with Redis and Memcached

Compare Tarantool with Redis and Memcached
 
Choose between Tarantool and Redis or between Tarantool and Memcached ? Let's look at the main differences, so that it's easier for you to decide. [1] . In Tarantool operations on data groups reached an even higher level of complexity, and in terms of reliability of storage (persistence) and indexing Tarantool exceeds Redis , not to mention the speed of work and support for users [2] . Given the development of storage facilities, as well as ...
+ 0 -