Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Repear doesn't remove expired rows from CV #2050

Open
vpikulik opened this issue Apr 12, 2019 · 1 comment
Open

Repear doesn't remove expired rows from CV #2050

vpikulik opened this issue Apr 12, 2019 · 1 comment

Comments

@vpikulik
Copy link

There is a stream:

CREATE FOREIGN TABLE field_stream (
  name text,
  value text) SERVER pipelinedb;

and continuous view:

CREATE VIEW values WITH (ttl = '5 day', ttl_column = 'day') AS
  SELECT 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?

@zahrasafavifar
Copy link

I have same problem

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants