Question : I need to calculate PayPal fees or an online shop to show an overview table with the fees […]
Tag: postgresql
Add a suffix to duplicates on PostgreSQL
Question : Not sure about the term “undouble”, I am just trying to add a unique index on a column […]
pg_dump: Write failed: Connection reset by peer
Question : we are trying to move all database data to other location. we chose to perform pg_dump and we […]
Add function parameter to SQL query WHERE clause
Question : I have a web application in java and it uses a query. I don’t want to write the […]
PostgreSQL join subquery can’t restrict query
Question : I’m working on a check-splitting project that splits out amount owed for an activity. Users can be a […]
Postgres consuming a lot of cpu [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Need a log based replication / CDC solution to publish postgres to oracle subscribers
Question : We have a moderately large postgres 9.1 db that is currently 3TB and will likely grow much larger […]
Searching against a large list of people at the same time in Postgres
Question : I have a list of people that varies between 2-5k entries that has this general format: firstname1 lastname1, […]
Database design – People and Organisations
Question : The software we are building has “Customers”. The Customer could either be a Person or an Organisation. I […]
Aurora PostgreSQL CPU usage stuck at 100% for 8 hours
Question : One of our Aurora PostgreSQL database’s(48 cores) CPU usage stuck at 100% for nearly 8 hours. These situation […]