title: ÐÐ½Ð°Ð»Ð¸Ð· ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑÐ¾Ð² Ð² Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ PostrgeSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Analysis of the effectiveness of using indexes in PostgreSQL databases
Creators: name: ÐÐ¾ÑÐ¾ÑÐ½Ð¸ÐºÐ¾Ð²Ð°, ÐÐºÐ°ÑÐµÑÐ¸Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2022
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
Ð¸Ð½Ð´ÐµÐºÑ
ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ
database
index
relational model

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«ÐÐ½Ð°Ð»Ð¸Ð· ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑÐ¾Ð² Ð² Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ PostgreSQLÂ». ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¿ÑÐ¾ÑÐµÑÑÐ° Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑÐ²Ð¸Ñ Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ PostgreSQL Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð·Ñ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð¸Ð½Ð´ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: ÐÐ·ÑÑÐµÐ½Ð¸Ðµ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐµÐ¹ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸ Ð¿Ð¾Ð¸ÑÐºÐ° Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ PostgreSQL; ÐÐ½Ð°Ð»Ð¸Ð· Ð²Ð»Ð¸ÑÐ½Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð½Ð° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð²ÑÐ±Ð¾ÑÐºÐ¸, Ð²ÑÑÐ°Ð²ÐºÐ¸, Ð¸Ð·Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð¸ ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ; Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÑÑÐ°ÑÐµÐ³Ð¸Ð¸ Ð¸Ð½Ð´ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð´Ð»Ñ ÑÐ¼ÐµÐ½ÑÑÐµÐ½Ð¸Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²; ÐÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¸Ðµ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÐ°, Ð´Ð¾ÐºÐ°Ð·ÑÐ²Ð°ÑÑÐµÐ³Ð¾ ÐºÐ¾ÑÑÐµÐºÑÐ½Ð¾ÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ ÑÑÑÐ°ÑÐµÐ³Ð¸Ð¸. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð±ÑÐ»Ð° Ð´Ð¾ÐºÐ°Ð·Ð°Ð½Ð° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð´Ð»Ñ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° ÑÐ½Ð¸Ð²ÐµÑÑÐ°Ð»ÑÐ½Ð°Ñ ÑÑÑÐ°ÑÐµÐ³Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. ÐÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÑÑÐ°ÑÐµÐ³Ð¸Ð¸ Ð¿Ð¾Ð¼Ð¾Ð³Ð°ÐµÑ Ð´Ð¾ÑÑÐ¸ÑÑ Ð²ÑÑÐ¾ÐºÐ¾Ð¹ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð¸ ÑÐ´Ð¾Ð²Ð»ÐµÑÐ²Ð¾ÑÐ¸ÑÑ Ð¿Ð¾ÑÑÐµÐ±Ð½Ð¾ÑÑÐ¸ ÑÐ°Ð·ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÐµÐ¼Ð¾Ð³Ð¾ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ.
description: The topic of the final qualification work: "Analysis of the efficiency of using indexes in PostgreSQL databases" This work is devoted to the study of the process of interaction with databases in the PostgreSQL DBMS and the analysis of methods for increasing the speed of working with databases using indexing. Tasks that were solved in the course of the study: 1. Studying the features of organizing data storage and retrieval in the PostgreSQL DBMS; 2. Analysis of the influence of indexing on the efficiency of query execution, data insertion, updating and deletion; 3. Develop an indexing strategy to reduce query execution time; 4. Conducting an experiment proving the correctness of the developed strategy. As a result, the effectiveness of using indexing to improve database performance has been proven, and a universal database indexing strategy has been developed. Using this strategy helps to achieve high database performance and meet the needs of the application being developed.