|
Hi there,
Welcome to a special announcement newsletter for our May 2022 issue of the pganalyze newsletter!
Today, we are very proud to announce the new and improved version of the pganalyze Index Advisor, based on the new pganalyze Indexing Engine! Learn more about why we are so excited about this below. Of course, you will also find a re-cap and links to our latest 5mins of Postgres episodes.
Interested to hear more in a webinar? Join us on June 16th, 9:30am PDT for "How to reason about indexing your Postgres database".
- - - pganalyze Index Advisor
The new version of the pganalyze Index Advisor provides you a database-wide overview of missing and unused index recommendations.
This represents a leap forward from our initial release of Index Advisor - now opportunities are assessed for the whole table, and indexes are optimized to cover multiple queries, whilst keeping Index Write Overhead low.
Read more in the announcement blog post:
We'll also give a detailed walk-through and a behind-the-scenes of the methodology that lead us to build the Indexing Engine and the Index Advisor on June 16th, 9:30am PDT and would love to see you there: Webinar Registration: How to reason about indexing your Postgres database →
If you like what we have built, we'd appreciate if you could share the blog post and the webinar on twitter→
- - - pganalyze Indexing Engine
The foundation of the new features launched today is the new pganalyze Indexing Engine. We built the engine to be a system thats repeatable, transparent, and can be introspected.
It represents over a year of effort from our team, and we're excited to share it with you today.
Read more in our technical deep-dive blog post: An automatic indexing system for Postgres: How we built the pganalyze Indexing Engine→
If you want to share this article on twitter, you can do so here→ - - -
5mins of Postgres - episodes from May: E17: Demystifying Postgres for application developers: A mental model for tables and indexes→ We walk through a mental model for how to think about databases as an application developer and explain Postgres Tables, Indexes, Index Cardinality & Table scans (share this episode here).
E18: Partition pruning, prepared statements and generic vs custom query plans→ In this episode, we talk about partition pruning and prepared statements in Postgres and run a performance test using the pgbench tool (share this episode here).
E19: Speeding up sort performance in Postgres 15→ Here, we look at four specific improvements made in Postgres 15 that help speeding up sort performance: Sorting a single column, specialized sort routines for common datatypes, and more (share this episode here).
Subscribe to the pganalyze YouTube channel to stay up to date about our weekly videos→
- - -
Product changes in April:
- - -
As always, I'm happy to hear from you and am personally reading all of your responses. Looking forward to your thoughts!
Have a nice day! Lukas & the pganalyze team
PS: If you're interested in giving pganalyze a try you can learn more about it here. Of course, I'd be happy to walk you through a demo on a video call. You can book a 30 minute meeting with me here. Or, if you have general requests, feel free to get in touch with us here.
|
