Python: Optimizing Heavy Database Queries with Materialized Views in PostgreSQL and Django

За събитието

This event is part of the user group Python.

Agenda:
>>> Identifying the problem – heavy queries returning aggregate, summary, and computed data.
>>> Postgres Materialized views to the rescue – what is a materialized view.
>>> Materialized views maintenance – creation, data update, indexes.
>>> Materialized views refreshing – concurrent and non-concurrent refresh.
>>> Implementing Materialized views in Django how to. ORM, raw queries
>>> Advantages of using materialized views – performance, simplicity.
>>>Disadvantages of using materialized views – staleness, storage overhead, maintenance.
>>> Alternatives to materialized views – caching, triggers, DB partitioning, denormalization.

>>> Q&A

USER GROUP: Python
This event is part of the Python User Group. Every month we organize events on a Python related topic. To make sure you don’t miss any interesting information on the topic – subscribe.

Organized by: DEV.BG is a specialized Job Board for IT jobs.

Python Job Offers: If you are looking for a job related to the Python technology, view the job listings here.

WHEN: November 09th, 7:30 pm