Digest news from the world of PostgreSQL. New Year's Eve (shortened) issue №13

We continue to introduce you to the most interesting news on PostgreSQL. In this New Year's Eve issue we will not bore you with a long list of news. Happy New Year!

Releases

pgAdmin4 3.6

')

In this version added:

• from the Properties panel you can drop several objects at the same time;
• can be imported from and exported to server definitions from the database and into the configuration database.

pgpoolAdmin 4.0.2



You can download here , as well as numerous previous versions.



dbForge Studio for PostgreSQL v2.0



This time devart released Studio with Standard edition, in which there is functionality not included in the free version of Express. 30 days can use the Standard edition for free. About the differences between Standard and Express can be read here .



VOPS-2.0



A new version of PostgreSQL extension from Postgres Professional has been released for the efficient execution of vector operations.



pg_probackup 2.0.25



New version of the utility for backup and recovery, also from Postgres Professional



pgCluu 2.9



A new version of this Perl program for auditing the performance of clusters with PostgreSQL can be downloaded here . pgCluu collects statistics not only on the DBMS, but also on the cluster system resources.



postgres_dba 4.0



A new version of Nikolai Samokhvalov's utility for PostgreSQL administration has been released. There are three new reports in it: a list of extensions, setting PostgreSQL and Vacuum parameters: what is happening right now. And, of course, improvements and corrections.

Education

Tutorial "Fundamentals of database technology"



Following the tutorial «PostgreSQL. The Basics of the SQL Language ”the first part of the textbook B.A. Novikova Basics of database technology . The textbook can be purchased at the publishing house DMK Press , online stores ozon.ru , Labirint.ru and retail book networks. In PDF format, the first part of the book can be downloaded freely from the Postgres Professional website. The second part of the book is being prepared for publication. The textbook covers database theory, methods and algorithms used in the implementation of the DBMS, as well as their features in the PostgreSQL system.

Articles and blogs

Benchmark PostgreSQL With Linux HugePages



Ibrar Ahmed (Ibrar Ahmed) shares his PostgreSQL test results with Linux HugePages . Testing was conducted on a 2-socket machine with SSD using pgbench . The article describes both the operating system parameters and the PostgreSQL 11 parameters.



Threaded postgres



Bruce Momjian (Bruce Momjian) in his own blog tells about the impressive experimental work of Konstantin Knizhnik ( Postgres Professional ). These are attempts to move from processes to threads. Benefits begin to affect when the number of simultaneous requests exceeds one hundred. The development of these works can be the development of an integrated puller.

Conferences

FOSDEM PGDay 2019



A one-day conference will be held in the capital of Belgium on February 1.



PgConf.Russia 2019



This conference will be held February 4-6 at the Faculty of Economics of Moscow State University. The conference program can be found here .



Prague PostgreSQL Developer Day 2019



P2D2 2019 in Prague will be held February 13-14.

---

Subscribe to the postgresso channel!



Send your ideas and wishes to email: news_channel@postgrespro.ru

Previous issues: # 12 , # 11 (special) , # 10 , # 9 , # 8 , # 7 , # 6 , # 5 , # 4 , # 3 , # 2 , # 1