PGDay Lowlands2025

Josef Machytka works as Professional Service Consultant - PostgreSQL specialist in credativ GmbH.

Born 1969 in Czech republic, dipl. engineer, Technical University Ostrava, Czech rep., field automation and robotics, living since 2014 in Berlin, Germany.

• 30+ years of experience with different databases - PostgreSQL (12y), BigQuery (7y), Oracle (15y), MySQL (12y), Elasticsearch (5y), MS SQL (5y), Sybase, Informix, FoxPro
• 10+ years of experience with high speed and volume data ingestion pipelines, data analysis, data lake and warehouse and related topics
• 2+ years of practical experience with different LLMs / AI including their architecture and principles.

LinkedIn: www.linkedin.com/in/josef-machytka Medium.com: https://medium.com/@josef.machytka ResearchGate.com: https://www.researchgate.net/profile/Josef-Machytka
Academia.edu: https://netapp.academia.edu/JosefMachytka

Speaker portfolio: https://medium.com/@josef.machytka/josef-machytka-speaker-portfolio-efd5a75e6a3b

Latest speaking engagements:

• 2025.06.03 - 5. PostgreSQL User Group NRW MeetUp (Mönchengladbach, Credativ GmbH)

  • "Boldly Migrate to PostgreSQL with credativ-pg-migrator"

• 2025.05.08–09 PostgreSQL Conference Germany 2025 (3 talks)

  • “Building a Data Lakehouse with PostgreSQL: Dive into Formats, Tools, Techniques, and Strategies”
  • “PostgreSQL Connections Memory Usage on Linux: How Much, Why, and When?”
  • “Your Data Deserves the Best: Migration to PostgreSQL”

• 2025.01.29 Prague PostgreSQL Developer Day 2025

  • "Building a Data Lakehouse with PostgreSQL: Dive into Formats, Tools, Techniques, and Strategies"

• 2025.01.27 NetApp internal talk

  • "PostgreSQL Connections Memory Usage: How Much, Why, and When?"

• 2025.01.23 NetApp internal talk

  • "Building a Data Lakehouse with PostgreSQL: Dive into Formats, Tools, Techniques, and Strategies"

• 2025.01.08 PostgreSQL MeetUp for All online event

  • “PostgreSQL and DuckDB: Supercharging ad-hoc Data Analysis and ETL”

• 2024.11.26 NetApp internal talk

  • "PostgreSQL and DuckDB: combining for quicker Data Analysis and ETL processing"

• 2024.11.15 - NetApp Tech Talk

  • "Many facets of AI hallucinations: factual errors, deep fakes, and creativity"

• 2024.11.12 - Internal Workshop - 3 talks:

  • "PostgreSQL 17: New Features"
  • "PostgreSQL Architecture: How PostgreSQL functions under the Hood"
  • "PostgreSQL Partitioning: Overview of Solutions, Tips & Tricks, Performance"

• 2024.10.29 Prague PostgreSQL MeetUp

  • "PostgreSQL and DuckDB: Analytics Performance and Use Cases"

• 2024.10.16 NetApp internal workshop - "AI Workshop: Exploring Artificial Intelligence" - 3 talks

  • "The AI Dilemmas: The Philosophical, Ethical, and Legal Implications of AI"
  • "Understanding the Magic of LLMs: A Deep Dive into the Internal Structure of LLMs"
  • "Many facets of AI hallucinations: factual errors, deep fakes, and creativity"

• 2024.10.09 PostgreSQL MeetUp Berlin

  • "GIN, BTREE_GIN, GIST, BTREE_GIST, HASH and BTREE indexes on JSONB data"

• 2024.09.27 NetApp internal talk

  • "Beyond the Buzzwords: A pragmatic explanation of LLM terminology"

• 2024.10.13 NetApp internal talk

  • "The Art and Science of AI Prompt Engineering"

• 2024.07.16 -  PostgreSQL MeetUp Berlin July 2024 - Lightning talk: "Can PostgreSQL have a more prominent role in the AI boom?"

• 2024.06.27 Swiss PG day

  • "GIN, BTREE_GIN, GIST, BTREE_GIST, HASH and BTREE indexes on JSONB data"
  • Lightning talk: "Can PostgreSQL have a more prominent role in the AI boom?"

• 2024.06.05 Prague PostgreSQL Developer Day

  • "GIN, BTREE_GIN, GIST, BTREE_GIST, HASH and BTREE indexes on JSONB data"