Posts

This release is coming with this news features : Prefix all queries performed by pgAssistant with : /* launched by pgAssistant */ Optimizing the issue “Indexe missing on foreign keys” by giving recommandations, depending on the size of the referenced table documentation here. Experimental : Add a vacuum query to try to optimize the default vacuum parameters for each table. See : documentation here New docker image is available on Nexsol dockerhub Take a look at DockerHub image tag ...

Object This post provides a SQL query that analyzes PostgreSQL tables and suggests optimized autovacuum settings on a per-table basis. It aims to improve database health and performance by adapting vacuum/analyze thresholds according to table size and usage patterns. Goal PostgreSQL uses autovacuum to automatically clean up dead tuples and refresh planner statistics. However, the default settings may be too aggressive for small tables or too lax for large ones, leading to: ...

Privacy Data privacy is no longer a luxury — it’s a necessity. Today, we’ll show you how to use pgAssistant with Infomaniak Cloud — Infomaniak’s privacy-focused, sovereign cloud solution based in Switzerland🇨. Why Data Sovereignty Matters When using AI tools in the cloud, where your data is processed and stored has a major impact: Legal compliance (e.g. GDPR) Data residency requirements Protection from mass surveillance Infomaniak’s Swiss Cloud is one of the few solutions that: ...