Snapshots
Snapshots are an artifact of calls to pgml.train()
that specify the relation_name
and y_column_name
parameters. See Training Overview for ways to create new snapshots.
Schema
CREATE TABLE IF NOT EXISTS pgml.snapshots(
id BIGSERIAL PRIMARY KEY,
relation_name TEXT NOT NULL,
y_column_name TEXT[] NOT NULL,
test_size FLOAT4 NOT NULL,
test_sampling pgml.sampling NOT NULL,
status TEXT NOT NULL,
columns JSONB,
analysis JSONB,
created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT clock_timestamp(),
updated_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT clock_timestamp()
);
Snapshot Storage
Every snapshot has an accompanying table in the pgml
schema. For example, the snapshot with the primary key 42
has all data saved in the pgml.snaphot_42
table.
If the test_sampling
was set to random
during training, the rows in the table are ordered using ORDER BY RANDOM()
, so that future samples can be consistently and efficiently randomized.
Have Questions?
Join our Discord and ask us anything! We're friendly and would love to talk about PostgresML.
Try It Out
Try PostresML using our free serverless cloud. It comes with GPUs, 5 GiB of space and plenty of datasets to get you started.