### Scaling with PostgreSQL 9.6 and Postgres-XL Mason Sharp mason.sharp@gmail.com Huawei ## whoami • Engineer at Huawei (USA based) • Co-organizer of NYC PostgreSQL User Group • PostgreSQL-based PostgreSQL-based database clusters GridSQL • Postgres-XC • Postgres-XL ## Agenda • PostgreSQL 9.6 Scaling Features • Scaling Solutions • Use Cases • Postgres-XL ## BTW- PGConf US 2017 in New York City • Join us

## Scaling a Multi-Tenant k8s Cluster in a Telco Pablo Moncada eBPF Summit October 28, 2020 ## About MasMovil group • 4th telecom company in Spain - Provides voice and broadband services to +12M customers

workload and system performance • Identify bottleneck operators, straggler workers, skew • Enumerate scaling actions, predict their effects, and decide which and when to apply ## Mechanism: How to apply the consistent manner • Block and unblock computations to ensure result correctness ## Automatic Scaling Control ## The automatic scaling problem logical dataflow  metrics detect symptoms scaling controller policy decide whether

2 Import Dependencies 2.2.3 Start Server 2.2.4 Use ShardingSphere-Proxy 2.3 ShardingSphere-Scaling (Experimental) 2.3.1 Rule Configuration 2.3.2 Import Dependencies 2.3.3 Start Server 2.3 Supported...56 Supported...56 4.7 Scaling...56 4.7.1 Background...56 4.7.2 Challenges...56 4.7.3 Goal...57 4.7.4 Status...57 4.7.5 Core Concept...57 Scaling Job...57 Inventory Data...57 ShardingSphere-Sidecar ..... 210 5.3.1 Introduction ..... 210 5.3.2 Comparison ..... 211 5.4 ShardingSphere-Scaling ..... 211 5.4.1 Introduction ..... 211 5.4.2 Build ..... 212 Build&Deployment ..... 212

editor. Cmd+E Ctrl+U or Cmd+U Focus comment editor. Ctrl+M or Cmd+M Shows Automatic suggestions tab, see Automatic suggestions. Ctrl+1 to Ctrl+9 or Cmd+1 to Cmd+9 Ctrl+M + 1 to 9 or Copies placeable translation. - Maximal rendered size in pixels defined by flags, see Maximum size of translation. ## Automatic suggestions Based on configuration and your translated language, Weblate provides suggestions from tools in Machine translation. ## Automatic translation You can use automatic translation to bootstrap translation based on external sources. This tool is called Automatic translation accessible in the Tools

/p9_6.jpg)  ## Scaling and orchestration Containerized development and production environment Cloud orchestration with 98f7/p24_1.jpg) ## Evaluation & conclusions ## Evaluation Kubernetes and docker for fast scaling Low price tag on operations No bottlenecks throughout the season BAM!  ## Conclusion • Documentation and procedures Prometheus • Scaling • Best practice Locust ## Thank you for the attention Any questions? ![Image](/uploads/docum

localization • Licensing translations • Translation process • Checks and fixups • Configuring automatic suggestions • Add-ons • Translation Memory • Configuration • Sample configuration • Management Following labels are used by Weblate: Automatically translated String was translated using Automatic translation. Source needs review String was marked for review using Source strings reviews. See while editing translation. Focus translation editor. Focus comment editor. Shows Automatic suggestions tab, see Automatic suggestions. Copies placeable of given number from source string. Copy the machine

3.32 Universe Levels 99 3.33 With-Abstraction 99 3.34 Without K 109 4 Tools 111 4.1 Automatic Proof Search (Auto) 111 4.2 Command-line options 114 4.3 Compilers 118 4.4 Emacs Mode 120 • No pattern matching. • Uses each argument at most once. • Does not use all its arguments. Automatic inlining can be prevented using the NOINLINE pragma. Example: -- Would be auto-inlined since it guardedness is not tracked at type A --without-K. See issues #1023, #1264, #1292. ## Tools ### 4.1 Automatic Proof Search (Auto) Agda supports (since version 2.2.6) the command Auto, that searches for type

the Maven plugin Using the Gradle plugin Hot swapping 20. Developer tools Property defaults Automatic restart Excluding resources Watching additional paths Disabling restart Using a trigger file Deduced "grab" dependencies Deduced "grab" coordinates Default import statements Automatic main method Custom dependency management Applications with multiple source files Packaging your Properties & configuration Automatically expand properties at build time Automatic property expansion using Maven Automatic property expansion using Gradle Externalize the configuration of SpringApplication

29 Self-consistency.....32 Tree of Thoughts (ToT).....36 ReAct (reason & act).....37 Automatic Prompt Engineering.....40 Code prompting.....42 Prompts for writing code.....42 Prompts for into a bit more detail showing the actual LLM inputs and outputs with a more elaborate example. ## Automatic Prompt Engineering At this point you might realize that writing a prompt can be complex. Wouldn’t Wouldn’t it be nice to automate this (write a prompt to write prompts)? Well, there’s a method: Automatic Prompt Engineering (APE). This method $ ^{15} $ not only alleviates the need for human input but also