Postgres database improvements

£20-250 GBP

Imefungwa

Imechapishwa

about 2 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa

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)

Python

PostgreSQL

Database Programming

Kitambulisho cha mradi: 32693629

Kuhusu mradi

21 mapendekezo

Mradi wa mbali

Inatumika 2 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

21 wafanyakazi huru wana zabuni kwa wastani £163 GBP kwa kazi hii

@liveexperts123

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 ndani ya siku 4

4.9

(24 hakiki)

6.3

@rohitangira

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 ndani ya siku 7

5.0

(58 hakiki)

5.7

@bhupen2606

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 ndani ya siku 1

5.0

(23 hakiki)

4.2

@ThetaSolutions

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 ndani ya siku 1

4.4

(27 hakiki)

4.1

@nanditapatel2021

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 ndani ya siku 7

5.0

(1 hakiki)

3.7

@khanmaiprogram

*****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 ndani ya siku 3

5.0

(6 hakiki)

3.4

@itamarjp

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 ndani ya siku 7

4.8

(4 hakiki)

2.8

@demvitalii3

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 ndani ya siku 1

4.4

(9 hakiki)

3.2

@kristyelsuweb

*** 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 ndani ya siku 7

5.0

(1 hakiki)

2.1

@haroonfarman571

I can implement LIKE query on your database. Ping me to get it done right away. Waiting for your response

£100 GBP ndani ya siku 1

4.9

(4 hakiki)

2.2

@itsankitkp

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 ndani ya siku 7

0.0

(0 hakiki)

0.0

@mannnupatel

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 ndani ya siku 7

0.0

(0 hakiki)

0.0

@bhatvij555

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 ndani ya siku 15

0.0

(0 hakiki)

0.0

@GeoSpatialServ

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 ndani ya siku 2