Functions for documenting PostgreSQL databases. Part Three

This is the third part of the article that describes user-defined functions for working with system directories: pg_class, pg_attribute, pg_constraints, etc.
 
First and the second is parts of the article were published earlier.
 
 
Functions for documenting PostgreSQL databases. Part Three
 
In this part of the article, functions that return are discussed. characteristics of sequences, inherited tables , as well as special characteristics of the attributes of tables .
 
Appendix .
 

Structure of the function returning a list of sequence characteristics of the table


 
...[/h]
+ 0 -

Orchestrated saga or how to build business transactions in services with the database per service

Orchestrated saga or how to build business transactions in services with the database per servicepattern.Hello! My name is Konstantin Evteev, I work in Avito as the head of the DBA unit. Our team develops Avito data storage systems, helps in the selection or issuance of databases and related infrastructure, supports Service Level Objective for database servers, and we are responsible for the efficient use of resources and monitoring, advising on design, and possibly developing micro services, strongly tied to storage systems, or services for the development of the platform in the context of storage. I want to tell you how we solved one of the challenges of the microservice architecture - conducting ...
+ 0 -

Metadata S3 in PostgreSQL. Lecture of Yandex

Metadata S3 in PostgreSQL. Lecture of YandexThis is the second lecture from Y. Subbotnik on databases - first we published a couple of weeks ago.
 
 
The general database management team leader Dmitry Sarafannikov told about the evolution of the data warehouse in Yandex: how we decided to make the S3-compatible interface, why they chose PostgreSQL, what rakes came and how they managed it.
 
 

 
- Hello! My name is Dima, in Yandex I'm engaged ...
+ 0 -

The history of active sessions in PostgreSQL is a new extension of pgsentinel

Company pgsentinel has released the same extension pgsentinel ( repository github ), adding in PostgreSQL representation pg_active_session_history - the history of active sessions (similar to the v $ active_session_history).
 
 
In fact, it's just an every second snapshot from pg_stat_activity, but there are important moments:
 
 
 
All the accumulated information is stored only in RAM, and the amount of memory consumed is regulated by the number of last stored records.
 
The queryid field is added - the same queryid from the pg_stat_statements extension (a preliminary installation is ...
+ 0 -

Functions for documenting PostgreSQL databases. Part One

Over the course of working with PostgreSQL, more than one hundred functions for working with system directories have accumulated: pg_class, pg_attribute, pg_constraints, etc.
 
 
Functions for documenting PostgreSQL databases. Part One
 
What to do with them? They are used relatively rarely. To include in any project? Krasnoyarsk customer for such "nonsense" will not pay. And yet, and suddenly they are useful to someone else besides the author. And I decided to put them out as read books in a public closet for those who wished.
 
Appendix .
 
 

What extended characteristics are we talking about?


 
In order to get an idea of ​​what is ...[/h]
+ 0 -

Functions for documenting PostgreSQL databases. Part Two

This is the second part of the article that describes user-defined functions for working with system directories: pg_class, pg_attribute, pg_constraints, etc.
 
Functions for documenting PostgreSQL databases. Part Two  
Texts of functions and their descriptions are given in the hope that they are useful to someone other than the author. In this article, some of these functions are laid out, like books read in the public cupboard for those who wish.
 
Appendix .
 
 

admtf_Table_Constraintes list of database table constraints and their characteristics


 
The source code can be viewed and downloaded here , and ...[/h]
+ 0 -

Following the tracks meetup "New features of PostgreSQL 11" (part 2)

In the first part of we talked about the major innovations and changes in PostgreSQL 11. This time, we will discuss in more detail some points in the question /answer format that were raised on meetup.
 
 

What is the best way to transfer a large data set as a set of input parameters for a stored procedure on PL /pgSQL?


 
The most convenient way is to create a temporary table, make copies of data there, and then use it in the procedure.
 
 

External engines (zheap) and development of in-memory PostgreSQL


 
Not for all workloads is the model with the storage of old versions of ...[/h][/h]
+ 0 -

ThinkingHome.Migrator - version migration of the database schema on the. NET Core

ThinkingHome.Migrator - version migration of the database schema on the. NET Coreplatform.Hello! Today I released a new version of ThinkingHome.Migrator - a tool for the versioned migration of the database schema to the .NET Core platform.  Packages are published in NuGet , written detailed documentation . You can already use a new migrator, and I'll tell you how it came about, why it has version number ??? (although this is the first release) and why it is needed when there is EF Migrations and FluentMigrator . Migrator.NET . The migrant proposed a new idea for that time - to set changes to the database as migrations. Each migration contains a small ...
+ 0 -

Slides of the course "Technologies and DBMS development"

Slides of the course "Technologies and DBMS development"  
 
Over the past year my colleague Anastasia Lubennikova and I conducted a course called "Technologies and DBMS Development". This course is devoted to the development of relational DBMS with an emphasis on a specific implementation in the person of PostgreSQL. We cooperated immediately with several universities. At HSE it was a compulsory subject, designed for students of the 4th year (in the photo students pass the exam). In VMK MGU it was an elective subject, for which students of different courses attended. ...
+ 0 -

Administration courses PostgreSQL &lt;{short}&gt; &lt;{full}&gt; <div class="post__text post__text-html js-mediator-article"> The reason for writing the article was the release of a new training course <a href="https://postgrespro.ru/education/courses/

<{full}>
The reason for writing the article was the release of a new training course
DBA3 "PostgreSQL Administration 10. Backup and Replication"
. Thoughts about his appearance and possible content were with us for a long time. But first things first.
 
 
Up to this point, we had two training courses on administration. The first one - the Basic course ( ? DBA1
), We developed in the summer of 201? it was built on the then current version of PostgreSQL 9.4. According to the idea, it includes the basic set of knowledge required by any database administrator. From the installation and initialization ...
+ 0 -