Logging with PostgreSQL

{
  "type": "unordered-list",
  "id": "5e31319e-7ae3-4710-ad86-5e4b3a675997",
  "items": [
    {
      "id": "5e31319e-7ae3-4710-ad86-5e4b3a675997",
      "content": [
        {
          "type": "text",
          "content": "I want to access my data from a variety of tools"
        }
      ]
    },
    {
      "id": "fdb2e3ed-f32f-421c-bc4e-2df096425f1d",
      "content": [
        {
          "type": "text",
          "content": "I want to minimize additional operational complexity"
        }
      ],
      "children": [
        {
          "type": "unordered-list",
          "id": "007b72e3-f3b7-4322-8d08-17cd7353d8d7",
          "items": [
            {
              "id": "007b72e3-f3b7-4322-8d08-17cd7353d8d7",
              "content": [
                {
                  "type": "text",
                  "content": "Jumping straight to BigQuery seemed like unnecessary complexity. I wanted to grow to BigQuery."
                }
              ]
            },
            {
              "id": "2adcfd11-e748-41f4-8f78-4cc419f2427d",
              "content": [
                {
                  "type": "text",
                  "content": "I'm already using Postgres on Amazon RDS"
                }
              ],
              "children": [
                {
                  "type": "unordered-list",
                  "id": "a5956d6a-7588-4c7d-89c8-bf9c7093e79d",
                  "items": [
                    {
                      "id": "a5956d6a-7588-4c7d-89c8-bf9c7093e79d",
                      "content": [
                        {
                          "type": "text",
                          "content": "Timescale is probably better, but RDS is more convenient."
                        }
                      ]
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    },
    {
      "id": "258c89a1-db51-4484-9a24-f3008993e5ce",
      "content": [
        {
          "type": "text",
          "content": "pg_partman"
        }
      ],
      "children": [
        {
          "type": "unordered-list",
          "id": "0cb3dbb0-925c-46a0-8195-bca3df63f5cb",
          "items": [
            {
              "id": "0cb3dbb0-925c-46a0-8195-bca3df63f5cb",
              "content": [
                {
                  "type": "link",
                  "content": "https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_Partitions.html",
                  "url": "https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_Partitions.html"
                }
              ]
            },
            {
              "id": "3b44a9f0-2d17-4c7a-a14a-8f030a1c7443",
              "content": [
                {
                  "type": "link",
                  "content": "https://www.citusdata.com/blog/2018/01/24/citus-and-pg-partman-creating-a-scalable-time-series-database-on-PostgreSQL/",
                  "url": "https://www.citusdata.com/blog/2018/01/24/citus-and-pg-partman-creating-a-scalable-time-series-database-on-PostgreSQL/"
                }
              ]
            }
          ]
        }
      ]
    },
    {
      "id": "aa5ca96e-9221-4cdf-ab36-2b68778a215d",
      "content": [
        {
          "type": "text",
          "content": "pg_cron"
        }
      ],
      "children": [
        {
          "type": "unordered-list",
          "id": "d640df56-1fec-4ec3-9f9e-e4b939b20eaf",
          "items": [
            {
              "id": "d640df56-1fec-4ec3-9f9e-e4b939b20eaf",
              "content": [
                {
                  "type": "link",
                  "content": "https://github.com/citusdata/pg_cron",
                  "url": "https://github.com/citusdata/pg_cron"
                }
              ]
            },
            {
              "id": "a19ae1d1-3375-4eb7-81a4-493afe6e9f02",
              "content": [
                {
                  "type": "link",
                  "content": "https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/",
                  "url": "https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/"
                }
              ]
            }
          ]
        }
      ]
    },
    {
      "id": "c59481bc-8c6a-49bd-8751-86edc7381a58",
      "content": [
        {
          "type": "text",
          "content": "Rollups"
        }
      ],
      "children": [
        {
          "type": "unordered-list",
          "id": "99daf936-51f7-494e-a1e7-53edf45ef026",
          "items": [
            {
              "id": "99daf936-51f7-494e-a1e7-53edf45ef026",
              "content": [
                {
                  "type": "link",
                  "content": "https://www.citusdata.com/blog/2017/06/30/efficient-rollup-with-hyperloglog-on-postgres/",
                  "url": "https://www.citusdata.com/blog/2017/06/30/efficient-rollup-with-hyperloglog-on-postgres/"
                }
              ]
            },
            {
              "id": "2d45a8ff-154a-43a5-9a18-2ace7ec6e8e8",
              "content": [
                {
                  "type": "link",
                  "content": "https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/",
                  "url": "https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/"
                }
              ]
            }
          ]
        }
      ]
    },
    {
      "id": "e0ed0f52-7559-4cbd-9358-d6c60274a017",
      "content": [
        {
          "type": "text",
          "content": "Try load testing with INSERTS"
        }
      ]
    }
  ]
}