Presentations
VACUUM is an essential part of PostgreSQL. In this talk, I will go through it, starting from basics to the internals.
- MVCC: The basics
- Data snapshots
- VACUUM
- VACUUM processing
- FREEZE
- VACUUM tuning
- VACUUM FULL
Vectors are a well-studied mathematical concept, yet pose challenges around efficient storage and retrieval in database systems. The increased ease-of-use of AI/ML has lead to a surge of storing vector data alongside application data, leading to some unique challenges. PostgreSQL has seen this story before with JSON, when JSON became the lingua franca of the web.
In this session, we'll review what vectors are, how they are used, and what users are looking for in vector storage and search systems and best practices for searching vector data in PostgreSQL with pgvector.
Learn how platform engineers can leverage Kubernetes, JupyterHub, Ray, and Crossplane to provide a robust data science platform for machine learning experimentation that fosters innovation and drives business value.
Understanding the relationships between various resource types in Kubernetes is crucial to understanding Kubernetes in general. It's unintuitive and takes many queries to gather owner/dependent hierarchies and find indirect references. Tools such as k8sviz can help visualize real Kubernetes resources, so we can quickly understand and communicate about the overall state of a Kubernetes-based service. This session is suitable for those with basic Kubernetes knowledge. We'll demo tools, look at some example diagrams, and discuss opportunities for improving diagram generators.
Discover the power of voice-assisted IoT and Edge interfaces in this practical session. Learn to create effective voice-activated devices, using LLMs like Falcon and OpenLLaMA. Gain insights into design decisions, essential components, and collaborative frameworks.
Participatory Budgeting (PB) is a popular method to engage residents in budgeting decisions. The Stanford PB Platform has been used in more than 150 processes across North America to distribute over $100 Million. We will briefly discuss the overall PB process and cover the voting process in more detail: voting methods, ballot considerations and what we learned about voter behavior.
PostgreSQL 9.6 introduced wait events and PostgreSQL 10 progressed them, but what are they? What do they mean? How do I find them and how do I make them go away? Wait events are one of the most significant advancements in observability for PostgreSQL databases; their usefulness is unparalleled in troubleshooting performance. This talk will go into all that and more as we perform a flyover of the field of database performance engineering in general, and then dive deep to explore the world of PostgreSQL wait events specifically.
I am implementing WASM derivations in Nix.
This means Nix will run WASM code rather than native code,
making use of OS-independent sandboxing, hence complete purity.
Many benefits come from this, and many interesting things can be built on top of it.
