I collect data from some API sources through Python and add it to 2 tables in Postgres.
Then, I use this data To generate reports, join and group/filter data. I add thousands of rows every da
Tag: Postgres
PostgreSQL – How should I extract repetition logic in the Postgres function?
I have a Postgres function with a lot of repeated logic. If I write this in Ruby, I will extract the repeated logic into some private helper methods. But in Postgres There seems to be no equivalent
PostgreSQL – How does this Postgres run deadlock?
Our postgres database reports a large number of deadlocks for tuples in the relationship.
Only two functions use the relationship, and usually only one function involves a deadlock. There ar
PostgreSQL – Postgres Query Optimization
Below are two almost identical postgres queries, but produced very different query plans and execution times. I assume that the first query is fast because form_id =’W40′ is only 196 Form_instance