New pages
- 09:56, 6 June 2025 Ora2pg (hist | edit) [6,600 bytes] Ian.readman (talk | contribs) (Created page with "==== Documentation ==== https://ora2pg.darold.net/documentation.html Pre-Requisites -------------- Install Full Oracle Client or Instant Client Instant Client must include the below 4 zip files wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn...") originally created as "Pg2ora"
- 09:55, 6 June 2025 Oracle PostgreSQL Migration (hist | edit) [33 bytes] Ian.readman (talk | contribs) (Created page with "Migration Tools pg2ora")
- 16:50, 13 April 2025 TimeScale Training (hist | edit) [7,088 bytes] Ian.readman (talk | contribs) (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'));...") originally created as "TimeScale Workshop"
- 20:21, 7 April 2025 TimeScale Notes (hist | edit) [2,208 bytes] Ian.readman (talk | contribs) (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(...")