jakob / jakob/Postico

Indicate which index is CLUSTER index

Open
#414 1 comment 2 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Currently when looking at table structure we cannot tell which index is the cluster index (or that clustering is as such being done). It would be comprehensive to show which index, if any, is the cluster index. I have to revert to psql with "\\d _table_" to find this out which is inconvenient.

Use case: more so now that RDS supports pg_repack, it becomes very valuable to setup table clustering, and among the DBs I manage, I like to quickly see that all tables are being clustered, and properly so.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start from Postico's table structure view and compare its displayed information with what psql's "\\d _table_" reports. The work is done when the view clearly indicates which index, if any, is the table's cluster index, including when clustering is not configured.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.