Let's get acquainted with GEQO in 20 minutes
-----------------------------------------------------------QUERY PLAN-------------------------------------------------------------- Hash Join Hash Cond: (Subject = GEQO) -> Hash Join Hash Cond: (**Optimizer task = choose the best query execution plan**) -> Seq Scan on **The number of potential plans grows exponentially as the number of tables in a query increases** -> Hash -> Seq Scan on **PostgreSQL solves this problem by using the genetic optimizer (GEQO)** -> Hash -> Seq Scan on **Topics of the report:** Filter: (**(What is GEQO)** AND **(Pros and cons)** AND **(How it works)**) (10 rows)
Слайды
PGConf 2023 Tolmachev v4.odpВидео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
45 мин
Andrey Zubkov Postgres ProfessionalWorkload monitoring extensions pg_profile/ pgpro_pwr. Architecture, setup, features and use cases
The major task of workload monitoring tools is to provide measurable statistics about most resource intensive activities in the DBMS. They can't solve any issues but the points for concentrating optimization efforts can be highlighted. We’ll talk about the extensions pg_profile and pgpro_pwr, their architecture, features and use cases.
-
45 мин
Anton Doroshkevich ИнфоСофтTips and tricks for PostgreSQL operations for 1C
As we have large 1C+PostgreSQL database setups, questions often arise, the answers to which are not so easy to find even in the documentation. I would like to share my experience in solving such issues gained during several migrations of 1C from MS SQL to PostgreSQL made for clients from the RBC500 rating. This talk will cover the following points: How in-depth your statistics should be and why it can be dangerous? How can the creation of an explicit and implicit temporary table provoke the DBMS server downtime and how can we avoid it? In what case will the DBMS process be killed by the operating system due to overuse of RAM and what to do about it? Why having one database per cluster is good and why having multiple databases on one DBMS cluster is bad? If we are stick to the "1 cluster = 1 database" approach, what about server resources for test and development environments? Backups in PostgreSQL: what backup options we have
-
45 мин
Василий Тимощенко ПКТБ-ЦЦТ ОАОExperience of migration a highly loaded system from DB2 for z/OS to PostgresPro in multimaster configuration
The developer shares his experience of migration a highly loaded system in the field of railway transport from IBM DB2 for z/OS to PostgresPro in a multimaster configuration. The main focus is on the nuances of working with a cluster operating in multimaster mode, what problems had to be faced and how to solve them.
-
45 мин
Alena Rybakina Postgres Professional