PostgreSQL Query Rewriting Techniques The previous articles in this series covered performance problems you fix by adding indexes, restructuring joins, or tuning memory. This one is about the queries where the plan is "fine" — every node is doing something reasonable — but the query itself is asking the wrong question, producing unnecessarily large intermediate results or forcing the planner dow
What is Azure Storage? Azure storage is Microsoft's cloud storage solution. It allows storage of unstructured data, pdfs, file shares etc. The following steps in this article outlines how I was able to create storage for the department's testing and training. In the Azure portal, search for and select Resource groups Select + Create Give your resource group a name. For example, storagerg
When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across many databases. GBase 8a, the China‑domestically developed MPP database from GBASE, solves this elegantly with the QUALIFY clause. Let's break down how it works, what it can do, and where you need to be careful. DROP TABLE IF EXISTS emp; CREATE TABLE emp
Setting up a public website using azure blob storage can be easy with the following steps. what is azure blob account? An Azure Blob Storage account is just a cloud space from Microsoft where you can store files of any type—like documents, pictures, or videos—so you can access them anytime, anywhere. with the following steps we will create a public website using azure blob storage. step 1 on azure
Before you train a model, you need data in the right format. This took me longer than I expected and taught me a lot about how LLMs actually learn. I used MedQA USMLE — real medical licensing exam questions used to certify doctors in the US. It's available on HuggingFace for free. from datasets import load_dataset dataset = load_dataset("GBaker/MedQA-USMLE-4-options") Each sample looks like this:
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full process of adding a composite GNode to a running GBASE cluster. Existing cluster: A healthy GBase 8a cluster New node: A server with a static IP address configured Network: All nodes must be able to communicate with each other Stop services on all existi
If you’re coming from Web2, identity probably means a username and password. You sign up for a service, create credentials, and the platform stores your data. Whether it’s GitHub, your email, or a banking app, your identity exists because a company manages it. Solana works differently. On Solana, your identity starts with something called a keypair. This is made up of two things: a public key and
Namespace ဆိုတာကို အရိုးရှင်းဆုံး အဓိပ္ပာယ်ဖွင့်ရရင်တော့ ကုဒ်တွေကို စနစ်တကျ စုစည်းသိမ်းဆည်းထားတဲ့ "ကွန်တိန်နာ (Container)" သို့မဟုတ် "နာမည်ပေးစနစ်" တစ်ခု ဖြစ်ပါတယ်။ အောက်ပါ အချက်အလက်တွေနဲ့ အကျယ်တဝင့် လေ့လာကြည့်ရအောင် - ၁။ ဘာကြောင့် Namespace ကို သုံးရတာလဲ? (The "Why") • ကွန်ပျူတာထဲမှာ Homework.docx ဆိုတဲ့ နာမည်တူ ဖိုင်နှစ်ခုကို Folder တစ်ခုတည်းမှာ သိမ်းလို့မရပါဘူး။ • ဒါပေမဲ့ English ဆိုတဲ့ Folder