Docker 验证证据

TimescaleDB 已验证 · Verified 🕒 快照采集: 2026-08-23 15:15:53 UTC

🐳 镜像:server:由 TIMESCALEDB_IMAGE 锁定

🛠️ 关键工具:postgrespsqltimescaledb-tune

🚀 运行/交互CREATE EXTENSION/hypertable → INSERT → SELECT → \dt → EXPLAIN

docker-session.out.txt

$ PGPASSWORD=… psql -h 127.0.0.1 -U postgres -Atqc 'SELECT 1'
1

$ psql fixed hypertable session
CREATE EXTENSION
DROP TABLE
CREATE TABLE
    create_hypertable     
--------------------------
 (1,public,hello_items,t)
(1 row)

INSERT 0 3
 id | name  | score 
----+-------+-------
  3 | Carol |    40
  1 | Alice |    30
(2 rows)

 hypertable_name 
-----------------
 hello_items
(1 row)

                                QUERY PLAN                                
--------------------------------------------------------------------------
 Append  (cost=0.00..50.32 rows=714 width=48)
   ->  Seq Scan on _hyper_1_1_chunk  (cost=0.00..23.38 rows=357 width=48)
         Filter: (score >= 30)
   ->  Seq Scan on _hyper_1_2_chunk  (cost=0.00..23.38 rows=357 width=48)
         Filter: (score >= 30)
(5 rows)
NOTICE:  extension "timescaledb" already exists, skipping
NOTICE:  table "hello_items" does not exist, skipping

Docker 验证证据 ​

Docker 验证证据