Published inGoogle Cloud - CommunityCloud Spanner — Evaluating commit timestamp optimization for recent-data queriesThe commit timestamp, based on TrueTime technology, is the time when a transaction is committed in the database. The…Jan 8Jan 8
Published inGoogle Cloud - CommunityCloud Spanner — Performance comparison between SQL and READCloud Spanner provides two APIs to query data: SQL API and READ API.Sep 11, 2024Sep 11, 2024
Published inGoogle 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 7, 2024May 7, 2024
Published inGoogle 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 14, 2024Mar 14, 2024
Published inGoogle 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
Published inGoogle 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
Published inGoogle 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
Published inGoogle 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
Cloud 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