optimization▌

Guides video optimization for Google Search (main results, video mode, Google Images, Discover), video sitemap, VideoObject schema, and indexing. Note: Google now prioritizes YouTube video results in search; YouTube + Reddit comprise ~78% of social media citations in AI Overviews. For YouTube-specific optimization, see youtube-seo; for GEO distribution via YouTube, see generative-engine-optimization. References: Google Video SEO, Semrush YouTube SEO.

Systematic approach to measuring, analyzing, and improving website loading speed and Core Web Vitals. \n \n Covers five-step optimization workflow: establish baseline metrics with Lighthouse, identify bottlenecks (bundle size, images, render-blocking resources), prioritize high-impact fixes, implement improvements, and verify results \n Addresses Core Web Vitals (LCP, FID, CLS) with specific code examples for image optimization, code splitting, lazy loading, and layout shift prevention \n Includ

Expert guidance on PostgreSQL-specific features, optimization patterns, and advanced data type capabilities. \n \n Covers JSONB operations, array types, window functions, full-text search, custom types, range types, and geometric types with practical examples \n Includes query optimization strategies using EXPLAIN ANALYZE, index design patterns (composite, partial, covering, expression), and connection/memory management \n Provides monitoring and maintenance techniques via pg_stat_statements, pg

You are a cloud cost optimization expert specializing in reducing infrastructure expenses while maintaining performance and reliability. Analyze cloud spending, identify savings opportunities, and implement cost-effective architectures across AWS, Azure, and GCP.

Production patterns for optimizing Bazel builds in large-scale monorepos. \n \n Covers WORKSPACE configuration, .bazelrc tuning, remote caching/execution setup, and platform-specific build constraints \n Includes templates for TypeScript and Python libraries, custom Docker rules, and dependency analysis via Bazel query \n Provides performance profiling techniques, memory optimization strategies, and best practices for fine-grained targets and visibility enforcement \n Addresses monorepo patterns

Reduce cloud spending across AWS, Azure, GCP, and OCI through rightsizing, reserved capacity, and cost governance. \n \n Covers four optimization pillars: visibility (tagging, dashboards, alerts), rightsizing (utilization analysis, auto-scaling), pricing models (reserved instances, spot/preemptible, savings plans), and architecture patterns (serverless, managed services, tiered storage) \n Includes cloud-specific strategies: AWS reserved instances and savings plans (30–72% savings), Azure hybrid

Comprehensive DAX formula analysis and optimization with performance, readability, and best-practice guidance. \n \n Analyzes formulas across four dimensions: performance bottlenecks, readability clarity, best-practice compliance, and maintainability challenges \n Provides step-by-step optimization strategy including variable usage opportunities, function replacements, and context optimization techniques \n Delivers refactored formulas with improved structure, error handling via DIVIDE and BLANK

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. \n \n Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns \n Includes five core optimization patterns: eliminating N+1 queries, cursor-based pagination, efficient aggregation, subquery transformation, and batch operations \n Provides advanced techniques like materialized v

Optimize cloud storage costs and performance across multiple cloud providers using compression, intelligent tiering, data partitioning, and lifecycle management. Reduce storage costs while maintaining accessibility and compliance requirements.

Build, write, and optimize high-converting landing pages combining proven copy frameworks, the 11-essential-elements structure, and a clear creation workflow.