Find Jobs
Hire Freelancers

Postgres database improvements

£20-250 GBP

Closed
Posted over 2 years ago

£20-250 GBP

Paid on delivery
have a postgres database (connected through psycopg2 with python) with 60M rows, need to perform 'LIKE' queries as fast as possible (UNDER 5s query time)
Project ID: 32693629

About the project

21 proposals
Remote project
Active 2 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
21 freelancers are bidding on average £163 GBP for this job
User Avatar
Hi there,I'm biddin on your project "Postgres database improvements" I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. .. .
£250 GBP in 4 days
4.9 (24 reviews)
6.3
6.3
User Avatar
Hii their I am an software dev with 5+ exp , your problem statement kind of jumped me off the table . i would like to inquire few things . you need this for whole db or for a specific table on some specific fields then i can go for it waiting for your reply happy to help .. :) Regards Rohit K.
£250 GBP in 7 days
5.0 (58 reviews)
5.7
5.7
User Avatar
Hi, i have extensive experience in database queries tuning. i can help with your query tuning task. Please share more details so i can start working on it.
£80 GBP in 1 day
5.0 (23 reviews)
4.2
4.2
User Avatar
I am Professional postgrese expert having more than 5 years of experience. Please share me your code hopefully I can write query for you.
£50 GBP in 1 day
4.4 (27 reviews)
4.1
4.1
User Avatar
Hii Mate, I have read everything and have a few questions related to your project that I want to ask through chat. I’m an Expert Coder having 5+ years of experience with similar expertise. I’m sure that you will be highly satisfied when I finish the project according to your needs. What you receive from my side:- 1. Daily or Weekly update. 2. Clean code with fast speed and accuracy. 3. Real-time communication. 4. Free Bug-Fix support for a longer period of time. 5. After support. Waiting for revert with a positive note. Thanks, Nandita Please note that this is a placeholder proposal, we can be more specific once we get all the requirements and information required to execute the project
£135 GBP in 7 days
5.0 (1 review)
3.7
3.7
User Avatar
*****Python/PostgreSQL EXPERT***** Hello, dear client It is my great honor to read your project requirement and place my bid. I have enough skill and experience. I want to make a good friendship with you. I will wait for your reply. Best regards for you.
£100 GBP in 3 days
5.0 (6 reviews)
3.4
3.4
User Avatar
please contact me and show me your database structure, data and your sql querys and I will take a look about whats possible todo to improve the performance of your sql like query's.
£135 GBP in 7 days
4.8 (4 reviews)
2.8
2.8
User Avatar
Hi, There I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have good experience with Python, PostgreSQL, Query, so can help you very well. I work according to your requirement to provide the best quality and customer satisfaction. I can start work immediately. Thanks.
£50 GBP in 1 day
4.4 (9 reviews)
3.2
3.2
User Avatar
*** Database Optimization Expert *** Hi, Thank you for your job posting I have rich experiences and all skills for your project as I am a Database Optimization Expert. I am very familiar with Python and Query Builder I would like to discuss more detail via chat Looking forward to hearing from you. Best regards,
£250 GBP in 7 days
5.0 (1 review)
2.1
2.1
User Avatar
I can implement LIKE query on your database. Ping me to get it done right away. Waiting for your response
£100 GBP in 1 day
4.9 (4 reviews)
2.2
2.2
User Avatar
Lots of factor depends on optimizing performance. 1. If column where like is properly indexed. 2. Use of explain analyze to get idea that query planner is creating right plans. 3. Postgres Configuration 4. Postgres instance capacity.
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 13 years of IT experience with various database technologies. Working Knowledge of Postgres,Oracle Databases. I have working experience in postgres database development as well as DBA. Expertise in developing skill , proficient in PL/PG-SQL,PL-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 Migration experience from Oracle to Postgres, Postgres to MS-SQL. Performed migration till 5 TB of Databases. Having Developing/DBA experience of postgres database size more than 10 TB.
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working as a postgresql datavase administrator for last 7 years, Having experience on de0loyment, performance tuning, query tuning, configuration. As per the requirement I might be the right fit for this job.
£135 GBP in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear, As a very experienced in PostgreSQL Also the Spatial extension PostGIS and with Strong experience in Database Administration and Performance, I Can Assure your Support in this Particular Job. I have Many Tips to be Applied to speed up this type of query. I Look forward to get access to tour Db to Apply my Solution or If Possible a dump. Regards
£200 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Stoke-on-trent, United Kingdom
0.0
0
Payment method verified
Member since Jul 16, 2017

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.