Optimize Postgres queries on the website
111 USD Optimize the postgresql.conf file
— configure parameters for specific hardware and workload type (memory, CPU, I/O).
Analyze and improve indexing strategy
— create necessary indexes, remove redundant ones, optimize for specific SQL queries.
Review the database structure
— apply table partitioning, normalize data, analyze schemas (schema review).
Configure VACUUM and autovacuum
— control parameters for cleaning and reorganizing tables considering performance.
Set up connection pool
— for example, install and properly configure PgBouncer to reduce server load.
Implement monitoring system
— connect tools like pg_stat_statements, pgBadger, or others for performance analysis, logs, and load.
details to be discussed in private messages
-
1 day445 USD
8193 63 1 1 day445 USD
Good afternoon,
Interesting project, I would be happy to help with its implementation. The approximate budget will be: $3000 - $6000.
To provide a more accurate estimate, we need to discuss some clarifications and obtain detailed information. Here are a few questions that will significantly affect the cost and approach to completing the tasks:
1 - What are the specifications of the current equipment hosting the database (server configuration, available memory, disk types)?
2 - Can you provide statistics on the current load type and data volumes you are working with? How large and complex is the database structure?
3 - What specific features and requirements for the application should be considered when optimizing the database?
I will be waiting for your response to further detail the work plan and adjust the estimate.
-
1 day356 USD
3853 24 0 1 day356 USD
Good afternoon,
I am ready to optimize your PostgreSQL database, including configuring the postgresql.conf file for maximum efficiency with your hardware and workload type. I will also analyze and optimize the indexing strategy, review the database structure with the application of best practices for table partitioning and normalization. Setting up VACUUM and autovacuum, connection pooling, and monitoring systems are within my expertise.
My rate is $16 per hour.
-
А сайт на чем
Самописный или нет? использует ли параметрические запросы или все в sql пишет
select * from table where name=:name ($name) (?)
а потом name назначается типа %раздватри
Или select * from table where name="%раздватри" ? (В этом случае предподготовленный кэш "херится")
-
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 20 hours 54 minutes back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 12 hours back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 6 days 11 hours back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 22 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 10 days 5 hours back ∙ 16 proposals |
Ukraine