Find Jobs
Hire Freelancers

fast postgres tuning

$30-250 USD

Closed
Posted about 3 years ago

$30-250 USD

Paid on delivery
I have only one table with 4 columns. the problem is that y load many data in this table like 30 millions of rows and do many select and updates at same time. so I need found the best config for postgres for this tasks (many updates/select at same time) I need increase the users that can be connected at same time and use more ram for do this updates and queries more faster. If you want change the db to others like NoSQL or a faster db system we can talk about this. thanks you!
Project ID: 29840248

About the project

4 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $183 USD for this job
User Avatar
I can efficiently improve performance of required database operations because I am highly qualified SQL developer with more than 10 years of advanced experience and with exceptional expertise in professional SQL performance tuning.
$250 USD in 4 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hello, For better performance of your postgreSQL database, you should create an index of the table. Using index method will make your table performance becomes much better and faster. But it has some overhead on the database system so you should maintain it carefully. Best Regards, khamid
$200 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 14 years of IT experience with various database technologies. Working Knowledge of Postgres,MS-SQL Databases. Work experience in Postgres Performance tunning. Strong Postgres Development Skills working experience in Database design. Expertise in developing skill , proficient in PLPG-SQL,T-SQL writing stored procedures, triggers and functions. Worked in build complex query. Database tuning experience. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Having Developing/DBA experience of postgres database size more than 10 TB.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am a Senior DBA with more than 20 years experience in DB like Oracle, postgres, mysql ... I can help you to tune your db. Regards.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SERBIA
mackay, Serbia
4.9
38
Payment method verified
Member since Mar 4, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.