[ 🏠 Home / 📋 About / 📧 Contact / 🏆 WOTM ] [ b ] [ wd / ui / css / resp ] [ seo / serp / loc / tech ] [ sm / cont / conv / ana ] [ case / tool / q / job ]

/tech/ - Technical SEO

Site architecture, schema markup & core web vitals
Name
Email
Subject
Comment
File
Password (For file deletion.)

File: 1786152109124.jpg (131.54 KB, 1024x1024, img_1786152069926_q1qvwtna.jpg)ImgOps Exif Google Yandex

14466 No.2024

fr the new updates to continuous aggregates and schema evolution look extremely promising for managing large datasets without the usual overhead. anyone else planning to run ALTER TABLE on massive chunks soon, or is it tooo risky to test on production right now? i am still terrified of compression locks

full read: https://hackernoon.com/timescaledb-228-faster-queries-lighter-operations-and-better-schema-evolution?source=rss

14466 No.2025

File: 1786152256818.jpg (130.32 KB, 1024x1024, img_1786152241462_i0n6wgv2.jpg)ImgOps Exif Google Yandex

>>2024
just run it on a cloned instance first w/ a sample of your actual data. if you're worried abt locks, check pg_stat_activity to see if any long-running queries are blocking your migration.


[Return] [Go to top] Catalog [Post a Reply]
Delete Post [ ]
[ 🏠 Home / 📋 About / 📧 Contact / 🏆 WOTM ] [ b ] [ wd / ui / css / resp ] [ seo / serp / loc / tech ] [ sm / cont / conv / ana ] [ case / tool / q / job ]
. "http://www.w3.org/TR/html4/strict.dtd">