Encerrado

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

Habilidades: Grande Volume de Dados, PostgreSQL

Ver mais: 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

Acerca do Empregador:
( 15 comentários ) Syndey, Australia

ID do Projeto: #15175454

13 freelancers estão ofertando em média $182 para este trabalho

$200 USD in 3 dias
(1 Comentário)
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 Mais

$155 USD in 3 dias
(1 Comentário)
1.9
vinaysinghh

A proposal has not yet been provided

$55 USD em 1 dia
(1 Comentário)
0.8
$155 USD in 3 dias
(0 Comentários)
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 Mais

$155 USD in 3 dias
(0 Comentários)
0.0
$222 USD in 5 dias
(0 Comentários)
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 in 3 dias
(0 Comentários)
0.0
$147 USD in 3 dias
(0 Comentários)
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 in 6 dias
(0 Comentários)
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 Mais

$233 USD in 3 dias
(0 Comentários)
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 Mais

$222 USD in 10 dias
(0 Comentários)
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 Mais

$155 USD in 3 dias
(0 Comentários)
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 Mais

$277 USD in 3 dias
(0 Comentários)
0.0