![Alexander Krizhanovsky Alexander Krizhanovsky](/media/2015/12/18/avatar.jpg.180x180.jpg)
Linux VMM for database developers
We'll discuss how does Linux work with virtual memory. The following topics will be covered: * x86-64 page table, context switch and page fault; * internals of virtual memory management (VMM) in Linux; * page eviction methods in Linux, page cache and anonymous pages; * huge and gigantic pages, transparent huge pages; * how mmap(2) works and what madvise(2), msync(2) etc. provide; * why large databases don't use mmap(2), but rather implement buffer pool on their own; * ans surely how to tune Linux VMM using sysctl.
Слайды
Видео
Другие доклады
-
Дмитрий Воронин ОАО "НПО РусБИТех"
The base version of DBMS PostgreSQL can register events bellow: - connect and disconnect - denial of access with date, time and user's name.
Requirements guidelines for audit subsystem is much wider possibilities basic version of database PostgreSQL.
The RusBITech company holds the necessary improvements PostgreSQL database to enhance it's functionality.
A result of improvements audit subsystem of PostgreSQL database as part of the operating system «Astra Linux Special Edition» further enables registration:
- The creation and destruction of database objects;
- Changes to the rules of access control;
- Both failures and successful attempts to access the database objects;
- Changes to the powers and status of subjects access objects access.
For all events are specified: - date and time; - The user performing the action of the registrant; - The object on which the action is carried out; - Type of event; - The result of the operation.
Audit subsystem of modified PostgreSQL is integrated into a centralized audit system OS «Astra Linux Special Edition». Provided the rules setting without stopping the logging (restarting) database.
-
Марат Фаттахов АО "БАРС Груп"Dmitry Boikov АО БАРС Груп
Porting a cloud solution from Oracle to Postgres
First working on Oracle, we could not ignore appearance and growth of PostgreSQL. I will describe how we came to PostgreSQL and share some experience of migrating a large medical system.
- developing a code converter;
- packages migration;
- our patches solving some of the migration problems.
-
Dmitry Vasiliev Postgres Professional
PostgreSQL Scalability
The talk describes performance benchmarking results of PostgreSQL on modern Hi-End servers. The main attention was paid to the locks for shared data access and associated bottlenecks. The testing propose was to test the linear read scalability limits with an increase of cores number allocated for PostgreSQL. Testing was performed for different postgres versions (9.4, 9.5, 9.6) to check new features designed to increase performance on multiprocessing architectures.