Data and documents
PostgreSQLFaster applications and reports
An open-source relational database system used to store and process application data.
Business applications
It can hold operational records and integration results with reporting access. Schema, transactions and maintenance require planning.
How it fits into my work
I develop database-backed applications and integrations, checking data consistency, access and query performance.
Example scenario
PostgreSQL: Example scenario
A workflow stores imported cases and their processing status in relational tables for later reporting.
Where should your company start?
Identify a slow screen, report or import. Provide sample data, timing and the load at which the problem occurs.
How will you know it helps?
Compare response time, result correctness and resource use on the same representative scenario.