![Arthur Zakirov Arthur Zakirov](/media/2017/01/23/arthur.png.180x180.jpg)
![Teodor Sigaev Teodor Sigaev](/media//2017/01/23/teodor.jpg.180x180.jpg)
Full text search capabilities in PostgreSQL
Full text search in PostgreSQL is probably the most advanced one among relational DBMS. This tutorial will explain how to setup full text search configurations and dictionaries and how to build a ful text search system using an example of a simple popular science web site, with demonstration of various ranking functions. Also I will tell about new RUM index, which allows to accelerate execution of some kinds of full text queries and implements a new improved ranking function.
Слайды
Видео
Другие доклады
-
Dmitry Vagin Avito
Monitoring PostgreSQL in Avito.ru, with case studies
A short talk about collecting data and monitoring database workload in Avito. Exporting metrics from stored procedures to Graphite. Collecting and visualizing pg_stat* metrics in Grafana. Case studies.
VIDEO
-
Mikhail Tyurin ИТ предприниматель
Deadlock explanations
< Query failed: ERROR: deadlock detected < DETAIL: Process 17371 waits for ShareLock on transaction 102733872; Blocked by process. < Process 10414 waits for ShareLock on transaction 102733874; Blocked by process 17371.
Such "unpleasant" messages from the server can seriously puzzle the developer. When working with locks, in particular, with transactions in general, it is necessary to take into account the features of the implementation of client libraries, which can cause the above exception.
In the short talk, the mechanics of the interaction of locks will be explained, main attention being paid to causes of deadlocks. References to the relevant documentation pages will be given. A technique of "bypassing" this problem of concurrent data access will be described and illustrated with some generalized examples from practice are shown. The talk will be interesting to database developers and administrators as well as the client-side application developers.
-
Andreas Scherbaum Pivotal
Introduction to Greenplum MPP Database
Overview of the architecture of Greenplum MPP (Massively Parallel Processing) database. Explain the internals of GPDB. Show how to configure and setup GPDB. How to distribute data effectively for MPP
VIDEO
-
Dmitry Cremer МИА "Россия Сегодня"
Building PostgreSQL from sources for system administrators
- why we build PostgreSQL from sources?
- choice build options
- dependencies
- creation system environment
- how to customise Linux for work with PostgreSQL
- extra soft for PostgreSQL DBA
VIDEO