I have a tickets table (Postgres on Heroku) that has about 7 million records. I have a single table query that is run often with the exported field either true or false. When it is true, it runs very fast…
I am trying to reduce some logging noise I am getting from PostgreSQL on my Heroku/Rails application. Specifically, I am trying to configure the client_min_messages setting to warning instead of the default notice. I followed the steps in this post…
I have a database for my website that is hosted on Heroku and uses Flask and Python. The model structure looks like: class MyDataModel(db.Model): id = db.Column(db.Integer, primary_key=True) property1 = db.Column(db.String(240), default = "") property2 = db.Column(db.String(240), default = "")…
We've run into a strange issue with Postgres, initially unearthed as we prepare to upgrade from 10.21 to 11+. What we'd initially thought was a performance regression in newer versions of Postgres appears, in fact, to be a performance regression…
I'm trying to connect to my PostgreSQL database hosted on Heroku through Auth0's Database Connections. I am getting an error when I try to invoke the Get User script within Auth0's database actions: no pg_hba.conf entry for host "xx.xxx.xx.x", user…
Due to this change by heroku, I am not able to restore my Heroku Postgres backup. Following errors are thrown while restoring: pg_restore: error: could not execute query: ERROR: extension "pg_stat_statements" must be installed in schema "heroku_ext" Command was: CREATE…
I am developing the Heroku toy app and want to use the PostgreSQL database to store configurations. I either see tutorials on how to use Java + PostgreSQL or Java on Docker. I cannot find a way on how I…
I am trying to use Heroku review apps for testing and demonstrating my site to my colleagues. The site has a large database that will not function with Heroku's free hobby-dev databases. I am trying to use the app.json manifest…
Hello I am working on a shopify embedded app with ruby on rails and I must save some config parameters given by the user or me. I couldn't find any solution other than using heroku postgres database. I looked everywhere…