received_transactions table can accumulate millions of records despite being cleared monthly

[turt2live]

Are there any side effects to just clearing it weekly instead? Mine has 21.6 million records in it, accumulating to about 24 GB of space.

[turt2live]

also the index on this table feels way too slow, but that's probably a function of the number of records.

[richvdh]

daily, even

[richvdh]

also the index on this table feels way too slow

I think postgres does not handle a large churn of rows particularly well.

[turt2live]

it sounds like it's relatively safe to clear this more often then? I think the largest side effect is if a server decides to send you the same transaction twice you'll waste some CPU time realizing that you've already processed it? That also shouldn't happen after 24+ hours though...

[turt2live]

also the index on this table feels way too slow, but that's probably a function of the number of records.

This was actually because the index on that table was corrupted. The table is now at 31gb.

[Routhinator]

also the index on this table feels way too slow

I think postgres does not handle a large churn of rows particularly well.

If this truncate was run nightly and then a reindex of the table was called, with a vaccum afterwards, it would be fine.