Performance optimize PostgreSQL database
$30-250 USD
Πληρώθηκε κατά την παράδοση
We have a database running PostgreSQL v9.6 with more than 160 mill records that is currently running on a server with the following spec:
RAM: 32 GB
CPU: 8 vCPUs
HDD: 160 GB SSD
Daily we insert >400,000 records to the database. The table is partitioned by Month_Year. The issue now is that running select queries for records runs extremely slow and can sometimes hang. Especially if the query runs across a few months of data, it becomes a real issue.
We need a detailed analysis for both data bottlenecks, Disk i/o, how to improve SELECT statements cross tables, etc.
Ταυτότητα Εργασίας: #16354970
Σχετικά με την εργασία
6 freelancers κάνουν προσφορές κατά μέσο όρο $247 για αυτή τη δουλειά
Hello, I have worked with PostgreSQL on many projects and I have used it to host fairly large databases (1+ TB of data, billions of rows). I also have experience with PostGIS, text search, Linux, Python. Can you g Περισσότερα
Hello, I'm a developer and sysadmin with 12+ years experience. The table partitions are a bad idea when you have querys across them or if you have a lot of them. Those are a known issue of posgres. I think a table cl Περισσότερα
Hello I can optimize PostgreSQL database performance. I am a senior system administrator with 10+ years of experience. I've been working at a hosting company and managed more than 200 servers. I have great experienc Περισσότερα
Having wide-spread knowledge and experience about website development, website designing and mobile application, graphics development, Content Writing, Virtual Assistant, graphics design, digital marketing. Have succes Περισσότερα