Açık

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

Beceriler: Büyük Veri, PostgreSQL

Daha fazlasını görün: 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

İşveren Hakkında:
( 15 değerlendirme ) Syndey, Australia

Proje NO: #15175454

13 freelancer bu iş için ortalamada 182$ teklif veriyor

in 3 gün içinde200$ USD
(1 Değerlendirme)
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 Daha fazlası

in 3 gün içinde155$ USD
(1 Değerlendirme)
1.9
vinaysinghh

A proposal has not yet been provided

1 gün içinde 55$ USD
(1 Değerlendirme)
0.8
in 3 gün içinde155$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
in 5 gün içinde222$ USD
(0 Değerlendirme)
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.

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0
in 3 gün içinde147$ USD
(0 Değerlendirme)
0.0
SaravanaKumarNar

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

in 6 gün içinde144$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde233$ USD
(0 Değerlendirme)
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 Daha fazlası

in 10 gün içinde222$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
vw6764450vw

I have over 20 years experience in app and DB design. I primarily work with traditional postgresql DB vs greenplum. I would split the proposal into two pieces. Phase one is to gather up more details about what your Daha fazlası

in 3 gün içinde277$ USD
(0 Değerlendirme)
0.0