Joe, an SQL optimization bot

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: Joe, an SQL optimization bot
Date: 2020-02-27 10:48:44
Message-ID: CANNMO++jaU63e3k79-dNyNT-_gQfXWcqrUjy2P5D56RrVFJPpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Joe, a Postgres query optimization assistant, updated to version 0.5.0
https://postgres.ai/blog/joe-0.5/.

Joe allows to boost the development process:

- eliminating annoying waiting time needed to provision copies of large
databases for development and testing purposes,
- helping engineers understand details of SQL query performance.

The bot works on top of Database Lab (
https://gitlab.com/postgres-ai/database-lab). Every time when an engineer
starts communicating with Joe, a new full-size copy of the database is
provisioned.

This process is fully automated and takes only a few seconds, even for
multi-terabyte databases. Such database copies are called “thin clones”
because multiple clones share the same data blocks, so provisioning is
super fast, and disk space consumption is very low. The clones are fully
independent, so developers can modify databases. Finally, SQL execution
plans are identical to production, which makes it possible to troubleshoot
and optimize queries reliably without involving production databases.

Currently, Joe is provided only in the form of Slack chatbot. Slack was
chosen to improve the level of collaboration of developers and DBAs.
Alternative communication ways (including beloved psql) are planned for
future versions.

Version 0.5.0 adds support of Slack API signed secrets, automated
notifications when long-lasting jobs are done, various improvements in
EXPLAIN plan processing, more. The full list of changes can be found in
Changelog.

Links:
- What is Joe bot? https://postgres.ai/docs/joe-bot/what_is_joe.
- Open-source repository: https://gitlab.com/postgres-ai/joe/.
- Changelog: https://gitlab.com/postgres-ai/joe/-/releases.
- Bug reports, ideas, and merge requests are welcome:
https://gitlab.com/postgres-ai/joe/issues/.
- Community Slack (English):
https://database-lab-team-slack-invite.herokuapp.com/. After joining, the
live demo of Joe is available in the #joe-bot-demo channel:
https://database-lab-team.slack.com/archives/CTL5BB30R.

Browse pgsql-announce by date

  From Date Subject
Next Message David Christensen 2020-02-28 22:40:25 Bucardo 5.6.0 released!
Previous Message David Fetter 2020-02-23 23:10:50 == PostgreSQL Weekly News - February 23, 2020 ==