PostgreSQL query acceleration

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.

Kemahiran: SQL

Lihat lagi: send query, postgresql c++, it factor, db query, optimize sql queries, sql optimize, 2013 query, access sql calculate, access sql query, sql query access, access projects sql server, postgresql sql, modify query, query optimize, need modifing, sql postgres, postgresql check check, crm postgresql, acceleration, crm sql, salary calculate, calculate salary, sql server query, sql projects bid, modifing

Tentang Majikan:
( 23 ulasan ) Siegburg, Germany

ID Projek: #4099681

Dianugerahkan kepada:


PostgreSQL expert. Please check PM for references

€150 EUR dalam 7 hari
(12 Ulasan)

11 pekerja bebas membida secara purata €129 untuk pekerjaan ini


Hi, .NET developer with 10+ years of experience is ready to help you. Please, check PMB for more details. Thanks.

€250 EUR dalam 5 hari
(9 Ulasan)

please check ur PM

€150 EUR dalam 2 hari
(2 Ulasan)

Hi, Please see PM.

€60 EUR dalam sehari
(3 Ulasan)

Hello Sir,PostgreSQL expert here. Please check pmb fo more details.

€90 EUR dalam 6 hari
(1 Ulasan)

Hello, I have been working on WCF, C#, BizTalk, ASP.NET for the past 10 years and during this tenure I handled various clients by delivering quality software within specified timeline.

€200 EUR dalam 7 hari
(2 Ulasan)

My primary work is DBA. I work and develop with Postgresql (8.x and 9.x). Also expert with SQL Server. If database can be optimized, i can do it.

€100 EUR dalam 7 hari
(2 Ulasan)

please check my pm

€60 EUR dalam 7 hari
(0 Ulasan)

Hello. More 20 years programming experiense. See pmb, please.

€30 EUR dalam 0 hari
(0 Ulasan)

hi, i can help U. please pm to me. thanks!

€200 EUR dalam 7 hari
(0 Ulasan)

Hello. I have an experience in database administration and optimization (Oracle 10g). Please consider my bid.

€30 EUR dalam 6 hari
(0 Ulasan)

I have 3.5 Years it and Oracle Experience if you will give this project i will do on time and best assured good quality.

€125 EUR dalam 2 hari
(0 Ulasan)