Index internals
PostgreSQL includes several index types: GiST, SP-GiST, GIN, and of course, the regular B-tree. DBAs are familiar with using each of these for specific use cases, GIN for full-text search, GiST for geometrical data, and so on, but how do they work internally? What makes them suitable for the cases they're typically used for?
In this presentation, I will walk through the internal structure of each of these index types, explaining what strengths and weaknesses each one of them have.
Слайды
Видео
Другие доклады
-
22 мин
Дмитрий Воронин ОАО "НПО РусБИТех"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.
-
45 мин
Anastasia Lubennikova Postgres ProfessionalNew B-tree features
B-tree is the most widely used index type in PostgreSQL. This data structure and concerned algorithms are developed about forty years ago. But there is still an area for optimisations. In this presentation I'm going to talk about B-tree data structure, and its features important for the optimal index usage. Furthermore, I'll present a couple of new features which are expected to be included in PostgreSQL 9.6 release.
-
Michael PaquierPostgreSQL and backups
A backup is something that no Postgres deployments should go without as it gives the insurance to get back a deployment on its feet should a disaster strike.
In this talk we will discuss why backups are essential in any sane PostgreSQL deployments (this seems obvious) and what are the different options available to define and set up a good backup strategy. On top of that is discussed how the future of backups would need to be handled, particularly regarding differential backups that gain in popularity among users with large deployments.
