index tuning

PostgreSQL – How to get the total index size used by each table in a database

As per the documentation, To get the total size of all indexes attached to a table, you use the function. The pg_indexes_size() function accepts the OID or table name as the argument and returns the total disk space used by all indexes attached to that table. We will use this… Read More »PostgreSQL – How to get the total index size used by each table in a database

DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

Abstract: “Automating physical database design has remained a long-term interest in database research due to substantial performance gains afforded by optimised structures. Despite significant progress, a majority of today’s commercial solutions are highly manual, requiring offline invocation by database administrators (DBAs) who are expected to identify and supply representative training… Read More »DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

Last updated by .