Remote Network And System Administration Job In IT And Networking

PostGreSQL-Vacuum Expert needed

Find more Network And System Administration remote jobs posted recently Worldwide

We have a Ruby code base that runs multiple jobs on our website. We deployed a piece of code and saw that it bloated up one table in our database because of several updates that happened in this table due to the code.

We need 3 things in this project:

1. Immediately remove the bloat in our database (82% bloat in the biggest table) through partial/manual/FULL vacuum as the bloat is causing certain processes to slow down on our app. We have Auto-Vacuum settings enabled and the settings - We also find that auto-vacuum is not being run on our biggest table (Candidate_Project_Matchings table), so that probably caused the bloat in this table and needs to be fixed.

2. Prevent such bloat from being created in the future and editing database features in a way that auto-vacuum is run on all tables effectively, including the biggest table

3. Re-indexing our index tables, if needed, to remove existing bloat and prevent future bloat

Our DB Size is 53GB, and the biggest table takes up 26GB (Out of which 22GB is bloat). We have total disk space of 160GB right now an EC2 instance. We are using PostGreSQL v11.
About the recuiter
Member since Sep 7, 2017
Juelz
from Nevada, United States

Skills & Expertise Required

Database Administration PostgreSQL Programming sql

Open for hiringApply before - Jul 1, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.83

Cost

Offer to work on this project closes in 45 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

Developer needed to build custom Auto scraper - Fixed
Realistic home rendering - Fixed
I need an IP lawyer or attorney for a youtube copyright counter notification - Hourly
Looking For Experienced 3D Modeler to Model 24 Realistic and Detailed Grenades For Unity Engine - Fixed
Forex - Basic - Fixed
Setup report manager for N-Central MSP - Hourly
Physicist/Electrical Engineer - Foil Design for Ionocraft - Hourly
BYO Window Custom Interactive Builder Needed - Fixed
GA data mapping with wordpress users - Fixed
Unreal Engine VR project from Oculus Rift to Go - Hourly
Developer needed to add customization to Squarespace Theme - Hourly

Similar Projects

NLN Quick MySQL Join

I have two tables. One is orders, one is order items. I will share it later

I need a join that will append the results of multiple rows of order items to the end of orders; keeping one row per order.

i.e. the final output should be...read more

SQL Server Performance EXPERT

We have customers with 10**9 records.

We need to delete 10**7 records NOT in SQL Server Management Studio - SQLCMD or (better) our CLI.

The expert must be able to provide practical solution/code (script) snippets/documentation onread more

Need mentoring for SQL Database Servers, and WordPress web development.

I am working to adapt an existing SQL server and Wordpress page to work for a similar application. I would like to learn the basics of working with the server and webpage to eliminate problems with simple solutions.

I am a recent college gra...read more

I need a SQL query written for my database and a way to view and segment data.

Im looking for a programmer that can write a SQL query based on the data we need and then import it to Access database so we use the data.

MANAGEMENT PLATFORM

A web application for costumer managing, their orders, raw materials and current accounts.

An original, active and concrete agency in its solutions

Build a platform together that can revolutionize this industry.