PostgreSQL query acceleration

  • Status Closed
  • Budget €30 - €250 EUR
  • Total Bids 12

Project Description

We are offering a CRM where a duplicate check for addresses is included. This duplicate search still works but we search for a solution to accelerate this.

This acceleration should mainly be realized by modifing the DB/SQL queries. If it is necessary we can modify the postgres configuration as well and discuss othere options. The target is to accelerate it factor 20 for all different DB sizes with:

10,000 Addresses compared with 100

10,000 Addresses compared with 10,000 (itself)

100,000 Addresses compared with 500

100,000 Addresses compared with 100,000 (itself)

500,000 Addresses compared with 1,000

500,000 Addresses compared with 500,000 (itself)

If it becomes accelerated more than factor 100 i double the salary and hope to work with you in further projects.

Please bid on this only if you are very very very experienced in Postgres/SQL techniques to accelerate queries and optimize the server configuration.

You get access to a test DB on a test server with different sized DBs and the Postgres configuration so that you can suggest a different configuration. Please send me a hint which information you need to calculate your bid.

And again: Please only bid if you are a very very very experienced in this topic.

Get free quotes for a project like this
Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online