![]() We're going to use the pg_azure_storage extension, to load the data directly from a public container in Azure Blob Storage. For this quickstart, we'll useĪ dataset previously captured from the GitHub API. We're ready to fill the tables with sample data. ![]() If you don't distribute tables then worker nodes can't help run Increased storage and compute performance.ĭistributing tables is necessary to take advantage of Azure Cosmos DB for PostgreSQL performanceįeatures. Theįunction decomposes tables into shards, which can be spread across nodes for Provides to distribute tables and use resources across multiple machines. Distribute tablesĬreate_distributed_table() is the magic function that Azure Cosmos DB for PostgreSQL Since Citus is a PostgreSQL extension, AzureĬosmos DB for PostgreSQL supports advanced PostgreSQL features like the JSONBĭatatype for storing semi-structured data. Notice the GIN index on payload in github_events. Copy and paste theįollowing commands into the psql terminal window, and hit enter to run: CREATE TABLE github_usersĬREATE INDEX event_type_index ON github_events (event_type) ĬREATE INDEX payload_index ON github_events USING GIN (payload jsonb_path_ops) Once you've connected via psql, let's create our table. To follow this quickstart, you'll first need to: Query events recorded from GitHub open source contributors. ![]() In this example, we'll use Azure Cosmos DB for PostgreSQL distributed tables to store and Azure Cosmos DB for PostgreSQL (powered by the Citus database
0 Comments
Leave a Reply. |