Buka

fix slow sql query

I have a test greenplum cluster, it supports postgres 8.3 SQL language/functions etc,

I have a query that it should finish in about 30 minutes but instead it just keeps running on end, it fills the filesystem and then die

I need someone that knows SQL very well, has experience with columnar database and how they work (example no indexes etc) and that it can properly read and understand query plans

I will provide the query and more details later

Thanks!

Mark

My apologies for being blunt, but it appears that many providers are not reading the requirements

This is not a web project, so please unless you have years of SQL experience and you know GreenPlum or similar columnar databases (Vertica etc), you are wasting your time and my time

Kemahiran: Big Data, PostgreSQL

Lihat lebih lanjut: slow sql query oscommerce, bad subdomain sql query prestashop fix, fix bad subdomain sql query prestashop, bad subdomain sql query error fix, fix bad subdomain sql query, need sql query, sql query slow loading website, sql query slow server, aspnet website sql query slow, asp net sql query slow, magento sql query mark items stock, getafreelancer message sql query help needed, sql query tree children, sql query tree structure, sql query child child, asterisk call forward database sql query, sql query tree structure records

Tentang Majikan:
( 15 ulasan ) Syndey, Australia

ID Projek: #15175454

13 pekerja bebas membida secara purata $182 untuk pekerjaan ini

$200 USD dalam 3 hari
(1 Ulasan)
2.2
zkutch

Hello More 20 years programming experience. I need more details to set real price and time. Regards. Relevant Skills and Experience More 20 years programming experience. Proposed Milestones $155 USD - postgres I nee Lagi

$155 USD dalam 3 hari
(1 Ulasan)
1.9
vinaysinghh

A proposal has not yet been provided

$55 USD dalam sehari
(1 Ulasan)
0.8
$155 USD dalam 3 hari
(0 Ulasan)
0.0
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. I am a developer very strong in below skills. Relevant Skills and Ex Lagi

$155 USD dalam 3 hari
(0 Ulasan)
0.0
$222 USD dalam 5 hari
(0 Ulasan)
0.0
kishanlalyadav

HI SIR I M 100% CONFIDENT FOR THIS PROJECT AWARD ME RIGHT NOW!!! I am ready to start this immediately. I am extremely eager and ready to go. Stay tuned, I'm still working on this proposal.

$250 USD dalam 3 hari
(0 Ulasan)
0.0
$147 USD dalam 3 hari
(0 Ulasan)
0.0
SaravanaKumarNar

Hi, Can you please share details like how many tables and the volume of data ,so could plan the optimised query.

$144 USD dalam 6 hari
(0 Ulasan)
0.0
thampl

Hi Mark, I have 10 years experience with SQL. Can you send me your query ? Do you have some test database where I can test query ? Kind regards, Tom Relevant Skills and Experience Database developer Proposed Miles Lagi

$233 USD dalam 3 hari
(0 Ulasan)
0.0
sandesh267

hi, I know you are expecting a guy with high experience, and I might not have that much experience I currently have 2.3 years of experience and can actually figure it out if you give me the chance, I am in contact Lagi

$222 USD dalam 10 hari
(0 Ulasan)
0.0
puneet6006

I can write the sql queries in optimized way. Relevant Skills and Experience For last 4 years i am working on Postgresql and Oracle and SQL Queries. Proposed Milestones $155 USD - On Daily basis, I provide sql queri Lagi

$155 USD dalam 3 hari
(0 Ulasan)
0.0
vw6764450vw

I have over 20 years experience in app and DB design. I primarily work with traditional postgresql DB vs greenplum. The efforts part of my proposal will be to evaluate what you have.

$277 USD dalam 3 hari
(0 Ulasan)
0.0