Manchester: the birthplace of despondency, post-punk and two famous football clubs

Not a technical post. We decided to tell about the great city of Manchester. We try to understand how it turned from an industrial capital into the capital of alternative music and why nobody remembers it. This is largely personal feelings and subjective picture: I was in this city during my vacation and write about what I saw.
 
 
Manchester: the birthplace of despondency, post-punk and two famous football clubs  
photos the time of the British photographer Nick Hedzis.
 
 
The strikes of many sectors resulted in the so-called "winter of discontent" of 1978-1979. The biggest strike of the workers of that time. In May 197? in parliamentary elections, the Labor Party, who could not ...
+ 0 -

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 -

Digest of news from the world of PostgreSQL. Issue number 7

Digest of news from the world of PostgreSQL. Issue number 7  
 
We continue to acquaint you with the most interesting news on PostgreSQL.
 
 

Releases


 
As promised, beta version of PostgreSQL 11 came out on the 25th of May. Its innovations in relation to 10.x are mainly listed in the summary That they froze on feature freeze .
 
 
Postgres Pro ???
 
Postgres Professional has released new Postgres Pro Standard /Enterprise ??? releases based on PostgreSQL 10.4 and Postgres Pro ???. They included all the improvements to the PostgreSQL 10.4 version, as well as a number of important improvements:
 
 
 
Updated the jsquery module, which is responsible ...[/h]
+ 0 -

PGCon 2018: photos, slides, impressions

PGCon 2018: photos, slides, impressions  
 
Last week, from May 29 to June ? 3-3339 took place. conference PGCon 2018
. PGCon takes place in Ottawa every year. Unlike other conferences devoted to PostgreSQL, PGCon is positioned as a non-user conference, and developers . This makes it an extremely important event in the life of the project. Next, I would like to share my impressions of the conference and talk about the most memorable moments for me. our company At the conference there were four people: Alexander Korotkov , Fedor Sigaev , ...
+ 0 -

Cluster pacemaker /corosync without validol

Imagine the situation. Saturday evening. You are the administrator of PostgreSQL , after a hard week of work they left for a summer residence for 200 km from your favorite work and you feel fine Until your peace breaks the SMS from the monitoring system Zabbix . There was a failure on the database server, the database is currently unavailable. A short time is spent on solving the problem. And you have nothing left, as with a heavy heart to saddle the service girosculator and rush to work. Alas!
 
 
Cluster pacemaker /corosync without validol
 
But ...
+ 0 -

How to copy data sources to the IDE on the IntelliJ

How to copy data sources to the IDE on the IntelliJplatform.Hello! In this tutorial, consider a few popular scenarios.  - Copying the data source within a single project. - A common data source for different projects within the same IDE. - Copy the data source to another IDE, to another computer, to another galaxy.  export settings . But you do not always want to transfer all the settings, and the data sources - global ones, too, are not always :)  So it will be useful to know that the data source can be copied: on the shortcut menu, selectDatabase tools → Copy data source to clipboard. This will work with several at once.    The clipboard gets the ...
+ 0 -

Olympiad SQL: parsing the problem about the calendar

Olympiad SQL: parsing the problem about the calendar Hello, on the air of Radio SQL!
 
We continue the topic of popularizing the SQL language among the broad masses of the IT population of our planet, this time in the Russian-language part of it. However, the inhabitants of other planets, too, pull yourself up. Tune in to our gravity wave, smear mucus, straighten the shells and make yourself comfortable - we begin!
 
In this article, I'm going to parse the problem of the calendar that I gave on Olympics on SQL , about which I already wrote earlier. Exciting recursion and cryptic aggregate functions, nested queries and
armed with
grouping of data - ...
+ 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 -

Digest of news from the world of PostgreSQL. Issue number 6

Digest of news from the world of PostgreSQL. Issue number 6 We continue to acquaint you with the most interesting news on PostgreSQL. [/i]
 
 

Releases


 
PostgreSQL 11 Beta
 
The release command PostgreSQL was determined with the release date of the beta version: May 2? 2018.
 
 
PostgreSQL 10.4 was released
 
 
Unlike version 10.? which was unplanned (it was necessary to immediately close important security holes), this version was released in accordance with graph .
 
In the new version many corrections ...[/h]
+ 0 -