Many PostgreSQL statistics views are local to the PostgreSQL server process you are connected to. That matters in YugabyteDB because a cluster can […]
Read More
Date Offset Views (Make Old Data Look New)
🤔 The Question You’ve got a dataset… but all the dates are from the 1970s. You want to: ● Keep the original […]
Read MoreExploring Tablet Placement with yb_tablet_metadata
In a distributed SQL database like YugabyteDB, understanding where data actually lives is just as important as understanding the schema itself. Once […]
Read MoreChange the Owner of a View in YSQL
When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read More