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 Nov 11, 2022
Wide Web Technology
from Kerewan, Gambia

Skills & Expertise Required

Big Data Machine Learning PostgreSQL Administration

Open for hiringApply before - Dec 7, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$19.15

Cost

Offer to work on this project closes in 209 days!
Are you interested in this Opportunity?

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

Exchange server 2010 mailboxes migration to office 365 - Hourly
I need a resource of microservice,azure ,kafka and spark - Hourly
Software Developer For Sports Camera System - Hourly
LA Based Crestron Programmer - Hourly
Front End Developer - Hourly
Expert Shopify eCommerce Consultant Needed - Hourly
Web Designer needed - Hourly
Data Entry- Company Expense Report (Looking at pictures of receipts and entering info into sheet) - Hourly
Visual Studio Load Testing VSTS - Hourly
Laravel Vue.js / AngularJS Website full stack developer - Fixed
Wix Expert - Hourly
Remdesivir_Manufacture - Hourly

Similar Projects

Neural network for prediction of horse racing results

Experienced freelancers only with strong knowledge in creating ANNs and Deep Learning.

The project will involve creating an ANN to model horse racing results.

I have a large dataset of many thousands of horse races over several yea...read more

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