FOSSWire
Search/
Databases & Storage

Karen Jex presents PostgreSQL analytics tuning at PGConf.EU

Brief written by the FOSSWire AI editor from Planet PostgreSQL How we write

1 min read

Key Takeaway

Karen Jex shared strategies for running complex OLAP queries on PostgreSQL without impacting OLTP performance.

Summary

At the PostgreSQL Conference Europe (PGConf.EU) in Valencia, Karen Jex delivered a presentation on tuning PostgreSQL for analytical workloads. The session focused on how to handle Online Analytical Processing (OLAP) tasks, such as complex joins and large dataset queries, within systems primarily configured for Online Transaction Processing (OLTP).

OLTP vs. OLAP in PostgreSQL

  • OLTP (Online Transaction Processing): Characterized by many concurrent users, short queries, and frequent select/update/insert statements.
  • OLAP (Online Analytical Processing): Involves complex queries, joining multiple tables, and large datasets requiring high CPU, memory, and IO.
  • The Challenge: Running analytical queries directly against operational data without compromising the performance of the primary application workload.

Original reference: postgr.es →