Auki

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

Taidot: Big Data, PostgreSQL

Näytä lisää: 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

About the Employer:
( 15 reviews ) Syndey, Australia

Projektin tunnus: #15175454

13 freelanceria on tarjonnut keskimäärin 182 $ tähän työhön

200 $ USD 3 päivässä
(1 arvostelu)
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 Lisää

155 $ USD 3 päivässä
(1 arvostelu)
1.9
vinaysinghh

A proposal has not yet been provided

55 $ USD 1 päivässä
(1 arvostelu)
0.8
155 $ USD 3 päivässä
(0 arvostelua)
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 Lisää

155 $ USD 3 päivässä
(0 arvostelua)
0.0
222 $ USD 5 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0
147 $ USD 3 päivässä
(0 arvostelua)
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 6 päivässä
(0 arvostelua)
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 Lisää

233 $ USD 3 päivässä
(0 arvostelua)
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 Lisää

222 $ USD 10 päivässä
(0 arvostelua)
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 Lisää

155 $ USD 3 päivässä
(0 arvostelua)
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 Lisää

277 $ USD 3 päivässä
(0 arvostelua)
0.0