
Closed
Posted
Paid on delivery
Our online education portal, [login to view URL], is powered by Python—primarily Django with a couple of small Flask services—and everything funnels through a single PostgreSQL instance. Traffic and course data have grown quickly, and the database layer is now the clear bottleneck. What I need is a specialist who can dive into our existing REST-driven codebase, profile the slow spots, and leave us with a noticeably faster, more stable platform. You’ll be looking at query plans, indexes, connection pooling, and any ORM patterns that might be hurting us. If you prefer working directly in SQL rather than through Django’s ORM when performance calls for it, that’s fine; the end goal is speed and reliability. While the stack is firmly Python/PostgreSQL, I’m open to discussing fresh ideas—whether that means refining our current setup or introducing lightweight services if a Node.js or Rails-style approach would add value without bloating the architecture. Deliverables • A concise audit report outlining pain points in our current PostgreSQL schema, queries, and Django ORM usage. • Implemented optimizations: new or revised indexes, refactored queries, and any necessary migrations or config tweaks (connection pooling, caching layers, etc.). • Benchmarked before-and-after metrics showing tangible improvements in response times and throughput under simulated production load. • Clear, step-by-step deployment notes so my team can reproduce the changes in staging and roll them out to production confidently. Acceptance criteria: key API endpoints must demonstrate at least a 40 % reduction in average response time under typical load tests, with memory and CPU usage remaining within our current server limits. If this sounds like a challenge you’re ready to tackle, let’s talk details and timelines.
Project ID: 40764429
84 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
84 freelancers are bidding on average ₹23,356 INR for this job

pg_stat_statements and EXPLAIN ANALYZE on the heaviest queries first; in Django the win is usually N+1 loops and missing composite indexes. Day 1: profile a staging copy under Locust load and send you the ranked offender list. Days 2-3: select_related/prefetch fixes, indexes added CONCURRENTLY so nothing locks, PgBouncer, before/after benchmarks and rollout notes. 1. Which 3-5 endpoints count as key for the 40% target? 2. Is PgBouncer or any pooler already in front of Postgres? I can start the profiling today once repo and staging access are shared.
₹21,050 INR in 3 days
7.8
7.8

Hi, CnEL India can help optimize your Django/PostgreSQL platform to improve API response times, database efficiency and overall stability. Our methodology: * Audit the Django/Flask codebase, REST endpoints and PostgreSQL configuration. * Profile slow queries and review execution plans using EXPLAIN ANALYZE. * Identify missing or inefficient indexes and optimize database queries. * Review Django ORM patterns, N+1 queries and unnecessary database calls. * Evaluate connection pooling, caching and database configuration. * Implement changes through controlled migrations and versioned code updates. * Benchmark key endpoints before and after optimization under simulated load. * Monitor response times, throughput, CPU and memory usage. * Document findings, deployment steps, rollback procedures and recommendations. * Validate changes in staging before production rollout. We would first establish baseline metrics, prioritize the main bottlenecks and implement measurable improvements while keeping the existing architecture lean. Regards, CnEL India
₹25,000 INR in 15 days
6.7
6.7

Greetings, I have reviewed your project description and recently worked on a similar project: ”ERP, CRM, Job Portals”. I believe I can help you deliver this successfully. Let’s open a chat to discuss your requirements in detail and determine the best approach for your project. Regards
₹30,000 INR in 3 days
5.6
5.6

Hi, i have extensive experience (over 10 years) in database optimization field with typical improvements well over 40%. I'd like to work on your project and replicate similar success. i can provide the deliverables you have listed with step by step deployment instructions and benchmark stats. Lets connect over chat where we can discuss further like size, scope, mode of operation etc. Thanks,
₹30,000 INR in 7 days
5.1
5.1

Slow queries and connection handling on a single shared PostgreSQL instance are what's holding your Django portal back, and the 40% target is only worth something if you can measure it yourself afterwards. I did something close to this on a load-balanced app and database cluster behind HAProxy, with monitoring and alerting. Here I'd start with pg_stat_statements and EXPLAIN ANALYZE to find the worst queries, fix the N+1 patterns and missing indexes, then put PgBouncer in front for pooling. The Flask services would get looked at last, since I'd guess most of the pain sits in Django. I'll leave you a load test script you can rerun, so the before/after numbers aren't just my word. 45000 INR is only an indicator to get me talking. It covers the first slice: the profiling, a ranked list of what's slow, and the fixes on your key endpoints. The full job gets a proper quote once I see how big the schema and the Flask side really are. The price holds if I get staging or a prod-like database copy plus read access to the Django repo, about 5 to 8 key endpoints need tuning rather than a schema rewrite, and load tests run against staging with you handling the production rollout from my deployment notes. If any of that differs, I re-quote before starting. M1: Profiling and audit with ranked findings, 15000 INR M2: Query, index and ORM fixes plus PgBouncer on staging, 20000 INR M3: Repeatable load test and before/after benchmark report, 10000 INR Roughly how many endpoints do you count as key, and do you already have a staging copy?
₹45,000 INR in 3 days
4.7
4.7

**Can start on this today and profile your PostgreSQL bottleneck first** I am Anand. I work on Django and Flask backends and will dig into your REST codebase, query plans, indexes, connection pooling, and ORM patterns like N+1 queries. Where Django ORM is the problem I am happy to drop to raw SQL. Recent work: cut a Django course platform's API time by fixing missing indexes and prefetching, and rebuilt slow reporting queries for a live dashboard app. On deliverables: a concise audit of schema, queries, and ORM use; implemented indexes, refactored queries, migrations, and pooling or caching tweaks; before-and-after benchmarks under simulated production load targeting your 40% reduction within current CPU and memory limits; and clear step-by-step deployment notes for staging to production. Can you share access to the repo and a staging database, or a recent pg_stat_statements export to start with?
₹25,000 INR in 7 days
4.3
4.3

As a seasoned software engineer with over six years of experience in building websites, I have dealt with numerous challenges very similar to the one you're facing. My expertise includes Python and SQL, which are the core technologies of your stack. Over the years, I have not only worked on building robust codebases but also optimizing them for speed and efficiency to handle increasing loads effectively. Lastly, I've shared a comprehensive portfolio of my previous work for your perusal. These examples not only exhibit my skillset across various domains but also showcase my knack for handling high-traffic platforms without bloating the architecture. Given this opportunity, I guarantee tangible improvements in response times and throughput under typical load tests while ensuring your CPU and memory limits are honored. Let's set a date to discuss the project's details and timelines – I'm prepared to tackle this challenge head-on!
₹34,000 INR in 15 days
4.2
4.2

Hi there, I'm Karthik, a PostgreSQL optimization expert with over 15 years of experience, particularly in enhancing performance for Django applications. I understand the critical need for a robust database layer, especially as your online education platform experiences rapid growth. I will conduct a comprehensive audit of your current PostgreSQL schema, focusing on slow queries and inefficient ORM patterns. My approach will involve profiling query plans, optimizing indexes, and implementing connection pooling to ensure your platform is both faster and more stable. I'll provide a detailed report outlining pain points and offer actionable recommendations. Expect tangible improvements, with key API endpoints showing at least a 40% reduction in average response time under typical loads. Additionally, I will include clear deployment notes, ensuring your team can replicate the changes seamlessly. Let’s discuss how we can enhance your platform's performance and reliability. Looking forward to collaborating! Best, Karthik
₹25,000 INR in 7 days
5.3
5.3

For a Django/PostgreSQL bottleneck, I’d start with evidence rather than assumptions: profile the slow API endpoints, inspect EXPLAIN ANALYZE, ORM query counts, index usage, connection behaviour, and request-level CPU/memory before changing architecture. I’d focus on two priorities: clean implementation and scalability. Typical fixes would include eliminating N+1 ORM patterns with select_related/prefetch_related, revising composite/partial indexes, simplifying expensive joins, introducing PgBouncer where connection pressure exists, and adding Redis caching only where measurements justify it. Each change would be benchmarked against the same load profile so the 40% response-time target is measurable rather than subjective. I’m a full stack developer and technical lead at Sacesta Technologies, and I handle performance investigations across APIs, databases, backend architecture, production debugging, and deployment. A relevant scaling project is our LMS platform. Its initial Laravel implementation was suitable for validation, but when usage requirements grew we reworked the architecture into a MERN-based system, reinforcing our approach of measuring constraints and changing architecture only where scale requires it. I would not recommend introducing Node.js or Rails services until profiling proves Django/PostgreSQL is the wrong boundary rather than simply an unoptimised one.
₹45,000 INR in 7 days
4.0
4.0

As a seasoned developer with extensive experience in Python and backend optimization, I am confident that I can bring significant improvements to your crescentacademyedu platform. My specialization lies in understanding performance bottlenecks and finding innovative solutions to optimize them. I have a keen eye for details, and optimizing databases to improve response time is something I've done consistently over the years. To address your concerns about PostgreSQL optimization, I'm well-versed with query plans, indexes, connection pooling, and the Django ORM. But what truly sets me apart is my openness to fresh ideas and exploring alternative approaches where they add value. This means that if introducing a lightweight Node.js or Rails-style service can enhance speed without complicating the architecture, I'll be proactive about suggesting and implementing it. Beyond just delivering enhanced speed and stability to your platform, my comprehensive approach includes precise audit reports outlining the pain points as well as clear documentation for rolling out changes. You can count on me to get the job done meticulously within the agreed timelines while not compromising on delivering tangible results through significant improvements in response times and throughput during rigorous production testing. Let's not wait any longer—hire me today!
₹25,000 INR in 1 day
3.6
3.6

Hi there, I’m Malix Azis. I’ll profile slow queries, review execution plans, improve indexes and Django ORM queries, and tune connection pooling. I’ll benchmark before and after, targeting your 40% response time reduction, and provide a clear audit report and deployment guide. Do you have load test results or slow query logs available? I have experience with Python, Django, Flask, PostgreSQL, SQL, and REST APIs. I can deliver reliable results and start immediately once we finalize the plan. Let’s discuss the details via chat. Best regards, Malix
₹20,000 INR in 7 days
3.6
3.6

Hi there, I’m Bilal, a Software Engineer with expertise in Python backend development, REST APIs, PostgreSQL, and performance optimisation. I believe every project is not just about writing code but creating real value for your business. With strong experience in backend engineering and database-driven applications, I can help identify and resolve the bottlenecks affecting Crescent Academy’s Django and Flask services. I’ll profile critical API endpoints, analyse PostgreSQL execution plans, review index coverage and ORM query patterns, and investigate connection pooling, caching, and transaction overhead. I’ll prioritise evidence-based improvements within your existing architecture, then run repeatable load tests to compare response times, throughput, and resource usage before and after the changes. The work will include a concise audit report, tested migrations, and clear deployment instructions, with the 40% response-time reduction target used to guide optimisation efforts. My focus is always on: * Identifying slow queries, inefficient ORM patterns, and database contention * Implementing and benchmarking targeted SQL, indexing, pooling, and caching improvements * Delivering reproducible performance results, safe migrations, and production-ready deployment notes I’d love to review your current performance metrics and discuss a focused optimisation plan. Feel free to contact me anytime—I look forward to collaborating with you! Best regards, Muhammad Bilal
₹15,000 INR in 7 days
3.2
3.2

Hi there, I can help identify exactly where PostgreSQL and Django are slowing the platform down, then optimize the bottlenecks with measurable before/after results. I’d begin with profiling rather than guessing: slow-query logs, `EXPLAIN (ANALYZE, BUFFERS)`, index usage, lock/contention checks, connection behavior, and Django ORM patterns such as N+1 queries, unnecessary joins, large result sets, and missing `select_related` / `prefetch_related`. From there I can implement targeted indexes, query rewrites, ORM refactoring, connection pooling, safe caching where useful, and PostgreSQL configuration adjustments without adding unnecessary architectural complexity. I’d benchmark the critical REST endpoints before and after changes under repeatable load, document every migration/config update, and provide a clear staging-to-production rollout plan with rollback steps. One question: do you currently have `pg_stat_statements` and PostgreSQL slow-query logging enabled in production or staging? Best regards, Jaroslav Caprata
₹12,500 INR in 3 days
3.3
3.3

Hi, Sara here, from Serbia. What matters most in optimizing PostgreSQL for your Django platform is a first version real users can sign up for and use, without a rewrite later. I'm a senior full stack developer with 8+ years of experience working with projects like this. With Django, the real challenge is auth, roles and data isolation. A common issue: no clear MVP boundary, so it never ships. My plan: first, agree the MVP scope, user roles and data model. Then, build auth, the core flows and the admin side in Django. Finally, test roles, permissions and edge cases, then deploy with backups. I'd start with auth and the core user flow as phase one. I've done web app work before, so I check early for data leaking between accounts and roles. A few questions to better understand the scope: 1. Do users upload files with personal data? Then I'd store them privately with signed links, not public URLs. 2. A proven auth service instead of custom login code? I'd recommend it, resets and security fixes come built in. 3. Are many users on low-end Android phones? Then I'd keep pages light and test on an entry-level device first. I can start right away. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, Sara
₹37,500 INR in 5 days
3.4
3.4

Hi, I can help optimize your Django/PostgreSQL platform by identifying database bottlenecks and implementing measurable performance improvements. My approach would be: • Profile slow API endpoints and database queries. • Analyze PostgreSQL execution plans using EXPLAIN/ANALYZE. • Review indexes, schema design, and query patterns. • Identify inefficient Django ORM usage and optimize where required. • Improve connection handling through pooling/configuration changes. • Add caching or other lightweight improvements where beneficial. Deliverables: • PostgreSQL/Django performance audit report • Optimized queries, indexes, and migrations • Configuration recommendations • Before/after benchmark results • Deployment notes for staging and production rollout I focus on practical improvements that reduce response times while maintaining system stability and avoiding unnecessary architectural complexity. I can begin with profiling and benchmarking first, then apply targeted optimizations based on measured bottlenecks. Best regards, Ankit
₹12,500 INR in 3 days
3.2
3.2

Hi, I can help identify and resolve PostgreSQL performance bottlenecks across your Django REST APIs and Flask services, focusing on measurable improvements without unnecessarily increasing server resource usage. I’ll profile slow endpoints, analyse PostgreSQL execution plans, review indexing and Django ORM queries, and investigate connection pooling, N+1 queries, and caching opportunities. I’ll implement targeted optimisations with safe migrations and configuration changes while preserving your existing architecture. You’ll receive a concise database audit, implemented fixes, before-and-after benchmarks under simulated load, and step-by-step staging and production deployment notes. I’ll use your 40% response-time reduction target to guide the work, validating results against agreed workloads and monitoring CPU and memory usage. My experience with Python, Django, FastAPI, Node.js, and production server deployments allows me to evaluate both database-level and application-level improvements. I’d prioritise optimising your current Python/PostgreSQL stack before introducing additional services. To estimate the timeline accurately, I’d like to review your PostgreSQL version, server specifications, slow-query logs, and the API endpoints currently experiencing the highest latency. Best Regards, Jitendra Sharma
₹12,500 INR in 3 days
2.9
2.9

Hello, I understand you need to optimize your Django/Flask education portal and PostgreSQL database to reduce API response times and improve platform stability. The goal is to achieve measurable performance gains without exceeding existing server resources. Here’s what I can provide: Audit PostgreSQL queries, execution plans, indexes, and Django ORM patterns to identify bottlenecks. Optimize SQL queries, database indexes, connection pooling, and caching where appropriate. Benchmark API performance before and after changes, with load testing, deployment notes, and a target of 40% lower average response times. I bring over 4+ years of experience in full-stack development using Python, Django, REST APIs, and SQL databases, focusing on reliable backends and maintainable applications. Just to clarify a few things: Which API endpoints currently have the highest response times, and do you have existing performance logs? Can you provide staging access and representative database statistics for profiling and load testing? Please come to the chat box to discuss more about your project. Best regards Indresh Kushwaha
₹35,000 INR in 7 days
2.1
2.1

Hi, Your Django/Flask platform needs targeted PostgreSQL optimization to reduce API response times and improve stability as traffic and course data grow. I’d start by profiling the slowest endpoints and examining query execution plans, indexing, Django ORM patterns, and connection usage. Based on the findings, I’d implement targeted query refactoring, index improvements, and pooling or caching changes where justified. I’d then run comparable load tests to document before-and-after latency, throughput, CPU, and memory usage, alongside a concise audit report and deployment instructions. Our team works with Python, Django, Flask, PostgreSQL, REST APIs, and backend optimization. The 40% response-time reduction would be treated as a measurable target and validated against the actual workload. Which API endpoints are currently the slowest, and do you have baseline load-test results available? If this aligns with your requirements, we can discuss the project in more detail. Best regards, Deepak.
₹12,500 INR in 7 days
2.4
2.4

Hi, I am excited about the opportunity to optimize the PostgreSQL database for your Django-based online education portal, crescentacademyedu.com. With over 11 years of experience in full-stack development, I specialize in database architecture and performance optimization, ensuring that your platform runs efficiently and scales seamlessly as your user base grows. To address your specific requirements, I will: - Analyze the current database schema and queries to identify bottlenecks. - Implement indexing strategies to enhance query performance. - Optimize data retrieval processes to reduce load times. - Ensure that the database is configured for optimal performance under varying loads. - Provide ongoing monitoring and maintenance recommendations to sustain performance improvements. My approach focuses on delivering immediate results while laying the groundwork for long-term scalability. I understand the intricacies of Django and PostgreSQL, allowing me to tailor solutions that align perfectly with your platform's architecture. Let’s collaborate to enhance your portal’s performance and user experience. Best regards, Anil Prajapati
₹30,005 INR in 15 days
1.0
1.0

Hi, I can help optimize your Django/PostgreSQL platform by profiling slow API endpoints, analyzing query plans, improving indexes, refactoring ORM queries, and tuning connection pooling and caching. I’ll provide an audit report, implement and test improvements, benchmark before-and-after performance under simulated load, and document safe deployment steps. My goal will be to achieve your 40% response-time reduction target while keeping CPU and memory usage within existing limits.
₹25,000 INR in 7 days
1.1
1.1

Bengaluru, India
Member since Feb 13, 2023
₹12500-37500 INR
$25-50 USD / hour
₹750-1250 INR / hour
₹12500-37500 INR
$1500-3000 USD
$700 USD
₹1500-12500 INR
$30-250 USD
$250-750 USD
$8-15 USD / hour
₹750-1250 INR / hour
₹600-1500 INR
$15-25 USD / hour
₹750-1250 INR / hour
$2-8 USD / hour
€750-1500 EUR
₹1500-12500 INR
₹12500-37500 INR
$10-30 USD
$250-750 AUD