You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE FOREIGN TABLE field_stream (
name text,
value text) SERVER pipelinedb;
and continuous view:
CREATEVIEWvalues WITH (ttl ='5 day', ttl_column ='day') ASSELECT DISTINCT
day(arrival_timestamp),
value
FROM field_stream;
We write almost 60M rows to the stream every day.
We expect that we should not see rows where day < NOW() - INTERVAL '5 days'. reaper0 process is active.
But we can find all rows that were written to the stream.
The first rows are more then one month old.
The table grows extremely.
What are we doing wrong?
Is it possible to see any reaper logs?
The text was updated successfully, but these errors were encountered:
There is a stream:
and continuous view:
We write almost 60M rows to the stream every day.
We expect that we should not see rows where day < NOW() - INTERVAL '5 days'.
reaper0
process is active.But we can find all rows that were written to the stream.
The first rows are more then one month old.
The table grows extremely.
What are we doing wrong?
Is it possible to see any
reaper
logs?The text was updated successfully, but these errors were encountered: