All public logs

Combined display of all available logs of Ian Doob Technology. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 11:41, 17 April 2025 Ian.readman talk contribs moved page TimeScale Workshop to TimeScale Training
• 16:50, 13 April 2025 Ian.readman talk contribs created page TimeScale Workshop (Created page with "== Setup == <pre> SET search_path = "$user", public, "timescaledb_information"; SET timezone TO 'Europe/Berlin'; \dv timescaledb_information.* </pre> <pre> DROP TABLE IF EXISTS metrics; CREATE TABLE metrics (id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY, device_time timestamptz NOT NULL, device_id integer, cpu_usage numeric); </pre> == Create Hypertable == <pre> SELECT create_hypertable('metrics', by_range('device_time'));...")
• 20:21, 7 April 2025 Ian.readman talk contribs created page TimeScale Notes (Created page with "== TimeScale Compression == Check Distinct Values --------------------- -- n_distinct (-1 = Unique, 1 = All The Same) SELECT tablename, attname, most_common_vals, most_common_freqs, n_distinct FROM pg_stats -- WHERE tablename = '<TableName>'; WHERE schemaname = '<SchemaName>'; == Compress Table == ALTER TABLE crypto_ticks SET (timescaledb.compress, timescaledb.compress_segmentby='symbol', timescaledb.compress_orderby='time DESC'); SELECT compress_chunk(...")
• 15:42, 23 March 2025 MediaWiki default talk contribs created page Main Page