Pablo ArrojoinGoogle Cloud - CommunityCloud Spanner — Demystifying Load-based SplittingAs a distributed database, Cloud Spanner divides your tables and indexes into chunks called “splits.” A split holds a range of contiguous…May 7May 7
Pablo ArrojoinGoogle Cloud - CommunityTroubleshoot query latency changes using SPANNER_SYS.QUERY_PROFILES_TOP_* tablesOne of the best tools in Cloud Spanner to understand why query latency changed is Query plan samples.Mar 14Mar 14
Pablo ArrojoinGoogle Cloud - CommunityCloud Spanner — How deleted rows could affect query latencyRemoving unneeded data is a good practice as we could reduce storage and backup cost, or improve query latency reducing the number of rows…Nov 10, 2023Nov 10, 2023
Pablo ArrojoinGoogle Cloud - CommunityCloud Spanner — Table Interleaving use casesSpanner’s table interleaving is a good choice for many parent-child relationships. With interleaving, Spanner physically co-locates child…Oct 3, 2023Oct 3, 2023
Pablo ArrojoinGoogle Cloud - CommunityCloud Spanner — Latency comparison between DML and MutationsData Manipulation Language (DML) and Mutations are two APIs in Spanner that you can use to modify data. Each offers similar data…May 23, 2023May 23, 2023
Pablo ArrojoinGoogle Cloud - CommunityCloud Spanner — Is it possible to speed-up index creation?Like any other schema changes in Cloud Spanner, adding indexes to an existing database is an ONLINE task. This means that it does not…Apr 15, 2023Apr 15, 2023
Pablo ArrojoCloud Spanner — Understanding how the number of participants affects commit latency and instance’s…Cloud Spanner is a distributed database, which means that as your database grows, Spanner divides your data into chunks called splits…Mar 23, 20231Mar 23, 20231