Closed

PgSQL Performance Tuning

I have couple of tables and some views based on them. One of the view is the UNION of 3 views. Earlier fetching the data from that view was faster but all of the sudden its taking time. Ex :- fetching of 3-5 records with only 4-5 columns are taking 5-6 seconds. If anyone is expert in this please connect with me.

Skills: Database Administration, MySQL, PostgreSQL, Software Architecture

See more: wordpress performance tuning expert writers, java performance tuning expert, performance tuning expert, postgresql query performance, postgres in clause performance, postgres performance millions of rows, postgres array performance, postgresql performance tuning tools, postgresql tuning advisor, postgresql performance benchmark, postgresql tuning script, postgresql, cpanel whm performance tuning, lucene performance tuning, solr performance tuning, performance tuning squid, clearcase sun performance tuning overview, performance tuning file access, oscommerce performance tuning, solr search performance tuning

About the Employer:
( 0 reviews ) Kashipur, India

Project ID: #17011274

6 freelancers are bidding on average ₹632/hour for this job

satvainfotech

Hello, We have very good exposure in diff. Platforms and We are strongly looking to start with such good projects and looking for long term works too. We can start work on immediate basis. Our aim of bidding is to pr More

₹777 INR / hour
(14 Reviews)
5.4
fastlabindia

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI More

₹400 INR / hour
(6 Reviews)
3.4
tausy

A proposal has not yet been provided

₹777 INR / hour
(10 Reviews)
3.6
sreenivas2903

hi can you please give me the access credentials to check it once. let me know whether you need it now or at after few hours

₹777 INR / hour
(1 Review)
2.5
marlonabeykoon

I have 5+ years in PostgreSQL development, so based on the requirement I have confidence that I can do it. Even I have a team of developers with me

₹645 INR / hour
(4 Reviews)
2.1
yaswant0259

PostgreSql needs to maintain clear space and should not contain duplicate indexes. Need to look into the datatype which the view consists of and maintain the view accordingly.

₹416 INR / hour
(0 Reviews)
0.0