Query optimization assistant Joe now supports hypothetical indexes

From: Artyom Kartasov <artyom(at)postgres(dot)ai>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: Query optimization assistant Joe now supports hypothetical indexes
Date: 2020-03-30 13:45:00
Message-ID: CANRqJBfQt2TNR435jmviS2iVg0ffeB9LsYLx46aKwj1kaBbytw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Joe, a chatops bot that allows troubleshooting optimizing SQL performance
using fast thin clones of full-size databases (cloning of 10 TiB takes only
a couple of seconds), updated to version 0.6.0
https://postgres.ai/blog/joe-0.6/.

Two new commands were added:
- "hypo" to manage hypothetical indexes. The command allows performing
HypoPG functions such as creation, deleting and listing hypothetical
indexes, as well as estimating the index size.
In addition, it checks if the hypopg extension exists and automatically
runs the command CREATE EXTENSION hypopg; Moreover, if any hypothetical
index is present in the query plan, you will see two versions of the plan,
with and without HypoPG involved.
- "plan" to get a query plan without execution. The command knows about
hypothetical indexes as well.

See the full list of commands: https://postgres.ai/docs/joe-bot/usage

Links:
- The blog post about Joe 0.6.0: https://postgres.ai/blog/joe-0.6/
- Git repository and issue tracker: https://gitlab.com/postgres-ai/joe.
- Community Slack (English):
https://database-lab-team-slack-invite.herokuapp.com/. After joining, the
live demo is available in the #joe-bot-demo channel:
https://database-lab-team.slack.com/archives/CTL5BB30R.
- Joe command list: https://postgres.ai/docs/joe-bot/usage
- Extended images with PostgreSQL:
https://hub.docker.com/r/postgresai/extended-postgres Includes HypoPG,
pg_hint_plan, more.
- Proposals to add more extensions are welcome in the Custom Images repo:
https://gitlab.com/postgres-ai/custom-images

Browse pgsql-announce by date

  From Date Subject
Next Message Stacey Haysler 2020-04-01 05:14:55 PostgreSQL Community Code of Conduct Committee Annual Report for 2019
Previous Message David Fetter 2020-03-29 20:02:27 == PostgreSQL Weekly News - March 29, 2020 ==