Đã Đóng

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

Kỹ năng: Big Data, PostgreSQL

Xem thêm: 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

Về Bên Thuê:
( 15 nhận xét ) Syndey, Australia

Mã Dự Án: #15175454

13 freelancer đang chào giá trung bình $182 cho công việc này

$200 USD trong 3 ngày
(1 Đánh Giá)
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 Thêm

$155 USD trong 3 ngày
(1 Đánh Giá)
1.9
vinaysinghh

A proposal has not yet been provided

$55 USD trong 1 ngày
(1 Đánh Giá)
0.8
$155 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0
$222 USD trong 5 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
0.0
$147 USD trong 3 ngày
(0 Đánh Giá)
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 trong 6 ngày
(0 Đánh Giá)
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 Thêm

$233 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$222 USD trong 10 ngày
(0 Đánh Giá)
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 Thêm

$155 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$277 USD trong 3 ngày
(0 Đánh Giá)
0.0