bertrandhartwig

3 ms·

1. 1.▲
   Designing the Right PostgreSQL Index Using Query Plans and Statistics(beh74.github.io)

   1 points by bertrandhartwig 5mo ago|0 comments
2. 2.▲
   Detecting PostgreSQL optimization issues with deterministic analysis(beh74.github.io)

   1 points by bertrandhartwig 5mo ago|0 comments
3. 3.▲
   by bertrandhartwig 2y ago

   well my dev teams are using Flyway. So, I may not be reasoning correctly. You’re right, a copy-paste can happen quickly. I will modify the code according to your remark.
4. 4.▲
   by bertrandhartwig 2y ago

   Thank you for this advice but the tool is designed to help dev ... before to run on production.
5. 5.▲
   by bertrandhartwig 2y ago

   Thanks !
6. 6.▲
   by bertrandhartwig 2y ago

   When pgAssistant sends the prompt to the LLM, it provides the DDL of the tables involved in the query (using pg_dump), the result of the ANALYZE query, and of course, the query itself. Believe me, LLMs understand the schema very well, and i
7. 7.▲
   by bertrandhartwig 2y ago

   I tested numerous LLM models locally with Ollama using PgAssistant. The one that gave me the best results is codestral:latest (15B).However, ChatGPT is truly a cut above the rest.