---
title: Optimization for analytics, pg_incremental, & Kubernetes
---

 Catch up on Postgres tutorials and news from your friends at Crunchy Data.

| view in browser view in browser Postgres Tuning & Performance for Analytics Data If you're using Postgres to do some reporting and analytics, we have a great overview of things to keep in mind. This blog post is packed with important advice from tuning settings, to ways to pre-compile data, and other options and ideas to keep things running fast and smooth. pg\_incremental: Incremental Data Processing in Postgres We are excited to release a new open source extension called pg\_incremental. pg\_incremental works with pg\_cron to do incremental batch processing for data aggregations, data transformations, or imports/exports. Sidecar Service Meshes with Crunchy Postgres for Kubernetes Kubernetes has a new feature in beta for native sidecars. Andrew L'Ecuyer shows off sidecars and how they can be used for integrating service meshes like Istio and Linkerd with Crunchy Postgres for Kubernetes. Name Collision of the Year: Vector There’s a myriad of uses for vectors in the Postgres world. Elizabeth reviews the history of the term vector and its use in several places - including graphics, AI, query optimization and more. Running an Async Web Query Queue with Procedures and pg\_cron The number of cool things you can do with the http extension is large, but putting those things into production raises an important problem. Learn more about the best way to run the http extension in production.   EVENTS  Crunchy Data Events Page American Meteorological Society Annual Meeting Sunday, January 12-16 \| New Orleans Red Hat Summit Connect Wednesday, January 15 \| Zurich DuckCon Friday, January 31 \| Amsterdam, Netherlands Laracon EU Tuesday, February 3 \| Amsterdam, Netherlands Crunchy Data \| 843-737-6045 \| crunchydata.com unsubscribe manage preferences |
| --- |
| Crunchy Data  162 Seven Farms Drive  Suite 220  Charleston, SC  29492   You received this email because you are subscribed to Newsletter subscription from Crunchy Data. |