title: ÐÐµÑÐ¾Ð´Ð¸ÐºÐ° Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² Ð¡Ð£ÐÐ PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: The methodology for increasing the speed of query execution in the PostgreSQL DBMS
Creators: name: ÐÐ°Ð½Ð´ÐµÐ»Ñ, ÐÐ»Ð¸Ð·Ð°Ð²ÐµÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: PostgreSQL
ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
ÑÐ·ÑÐº SQL
ÑÑÐ¾Ð¸Ð¼Ð¾ÑÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ°
relational databases
SQL language
request execution cost

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«ÐÐµÑÐ¾Ð´Ð¸ÐºÐ° Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² Ð¡Ð£ÐÐ PostgreSQLÂ». Ð ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ° Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÑ ÑÑÐµÐ´ÑÑÐ², ÑÐ°ÐºÐ¸Ñ ÐºÐ°Ðº ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¸Ð½Ð´ÐµÐºÑÐ¾Ð², Ð¿ÐµÑÐµÐ¿Ð¸ÑÑÐ²Ð°Ð½Ð¸Ðµ Ð·Ð°Ð¿ÑÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¼Ð°ÑÐµÑÐ¸Ð°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ, ÑÐ¾ÐºÑÐ°ÑÐµÐ½Ð¸Ðµ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð° ÑÐºÐ°Ð½Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ð¹. Ð ÑÐ°ÐºÐ¶Ðµ Ð±ÑÐ»Ð¾ ÑÐ¾Ð·Ð´Ð°Ð½Ð¾ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸. ÐÐ½Ð¾ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÑÐµÑ ÑÐ¾Ð±Ð¾Ð¹ Ð°Ð½ÐºÐµÑÑ, Ð² ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð·Ð°Ð¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÐºÐ¾ÑÐ¾ÑÐ¾Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð¿Ð¾Ð»ÑÑÐ°ÐµÑ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¿Ð¾ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ° Ð² Ð¡Ð£ÐÐ PostgreSQL. Ð ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¸ ÑÐµÑÐµÐ½Ñ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð·Ð°Ð´Ð°ÑÐ¸: 1. ÐÐ½Ð°Ð»Ð¸Ð· Ð¿ÑÐµÐ´Ð¼ÐµÑÐ½Ð¾Ð¹ Ð¾Ð±Ð»Ð°ÑÑÐ¸ Ð¸ Ð¿Ð¾ÑÑÐ°Ð½Ð¾Ð²ÐºÐ° Ð·Ð°Ð´Ð°ÑÐ¸; 2. ÐÐ·ÑÑÐµÐ½Ð¸Ðµ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐµÐ¹ ÑÐ°Ð±Ð¾ÑÑ Ð¿Ð»Ð°Ð½Ð¸ÑÐ¾Ð²ÑÐ¸ÐºÐ° Ð¡Ð£ÐÐ PostgreSQL; 3. ÐÐ½Ð°Ð»Ð¸Ð· ÑÑÐµÐ´ÑÑÐ² Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²; 4. Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð¸ÐºÐ¸; 5. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¸ ÐµÐ³Ð¾ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ.
description: The subject of the graduate qualification work is "The methodology for increasing the speed of query execution in the PostgreSQL DBMS." In the course of the work, the methodology was developed to increase the speed of query execution based on an analysis of the effectiveness of various tools, such as creating indexes, rewriting a query, using a materialized view, and reducing the number of scans. And also the application was created using the developed methodology. It is a questionnaire, as a result of filling and processing of which the user receives recommendations on how to increase the speed of query processing in the PostgreSQL DBMS. In the course of the work, the tasks were solved: 1. Analysis of the subject area and problem statement; 2. Studying the features of the PostgreSQL DBMS scheduler; 3. Analysis of means to increase the speed of query execution; 4. Creation of the methodology; 5. Application development and testing.