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).

• 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(...")