Grouping (not in the SQL sense) some set of data into sets of activities is incredibly common when you want to reason about your data - here’s a great highlight of how to actually apply that from Periscope.
Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. 14 day unlimited trial.
Postgres connections are notoriously memory bloated, and the answer is generally a good connection pooler like PgBouncer. However, pgbouncer won’t solve all your problems, and here’s a great highlight of how you have to handle it with something like ActiveRecord.
GoCardless has created a library, ActiveRecord::SaferMigrations, that automatically sets lock_timeout and statement_timeout before running migrations to prevent them stopping your app from responding to requests.
Indeed Prime is an elite new program from Indeed.com that presents
in-demand tech talent like you to top employers. Indeed Prime opens
the door to exciting career opportunities with one simple application.