Running 10M PostgreSQL Indexes in Production

Re:Running 10M PostgreSQL Indexes in Production by daliwali on Tuesday June 13, 2017 @04:52AM (#14543608)

This may be a stupid question but I glanced over the marketing website and didn't really understand how logs are stored.

- Are you storing each log event as a row in Postgres?

- How do you rotate logs, what happens when logs get indefinitely large?

- Can logs be exported to some common format for offline analysis?

[ Parent | on HN ]

Re:Running 10M PostgreSQL Indexes in Production by malisper on Tuesday June 13, 2017 @02:59PM (#14547546)

We create one row per event logged in Heap.

We currently have a default 3-year retention policy. We will keep your old data for up to three years.

We have a redshift integration which you can use to export your data from Heap into redshift.

[ Parent | on HN ]