Remote Network And System Administration Job In IT And Networking

Redesign of postgresql DB very specialised usage / big tables / few big queries than need to be fast

Find more Network And System Administration remote jobs posted recently Worldwide

deliverable : tables design, configuration file, query much faster than today
we are a nice startup doing automated operations sstems ( ordering and business insights)

We are a startup
We are noobs in postgres and for sure someone with experience will laugh at our challenge but for the first time in years uncle google proved not enough
We do not fear any challenge, we just do it :-)
attached the probably poor design of our main table, around 300 unique dates , for each date 25k indexes and for each index around 10 names, that makes around 40 M rows. Also i will share our typical query that takes 35 seconds in postgres to execute, 55 seconds from script in RStudio.

We would like to grow now so the just do it approach has its limits and would like you to advice us on proper desing of tables and DB archi
About the recuiter
Member since May 20, 2018
Steve Mulligan
from Colorado, United States

Skills & Expertise Required

Big Data Machine Learning PostgreSQL Administration 
Candidate shortlisted and hiredHiring open till - Apr 17, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$19.15

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Outdoor food photography - Fixed
FreePBX v13. Review all settings to ensure correctly configured. - Troubleshoot single issue. - Hourly
Looking for Expert on Genesis,python, jenkins - Fixed
A Ghost writer required to help in the completion of a non-fiction book. - Fixed
GIS Mapping - Hourly
Make my Album Artwork Come to Life - Fixed
Concept Package Design Rendering Consumer Packaged Goods - Hourly
Looking for Swift developer - Hourly

Similar Projects

Wine label image recognition rest API

We are building a app that will be able to recognize wine labels that the user takes a picture of. We have a dataset with about 25k products. Almowt all products have one image and have a lot of data about the wine (like producer, year, and other det...read more

Linear Regression tutorial paper with application to sustainability

We need a tutorial paper for teaching undergraduate CS major level students about using linear regression for data analysis (exploratory data analysis preferred). We need a formal tutorial paper, that explains the theory behind a specific type of dat...read more

Odoo Server Admin / Dev

We have recently selected Odoo as our CRM of choice. We will have ongoing but only occasional needs.

At the moment, we our Odoo is down. We believe it was a poorly created Module that we activated. Odoo ran normally till server restarted...read more

Data Science Specialist Needed

Hi
I want to run code for paper A New Perspective of Noisy Supervision (Tensorflow implementation)..
You can get the open source for that paper and run it for custom data.
you should be proficient in tensorflow and python.
Please ap...read more

Python and Machine learning tutorials

Python and Machine learning Tutorials. I will like to engage an expert in Python and Machine learning to help in a college course. Initial engagement will be around 2-5 hours a week.