Suljettu

fast postgres tuning

I have only one table with 4 columns.

the problem is that y load many data in this table like 30 millions of rows and do many select and updates at same time.

so I need found the best config for postgres for this tasks (many updates/select at same time)

I need increase the users that can be connected at same time and use more ram for do this updates and queries more faster.

If you want change the db to others like NoSQL or a faster db system we can talk about this.

thanks you!

Taidot: PostgreSQL, Redis, MongoDB, NoSQL, Database Design

Näytä lisää: mysql load data infile specify columns, css 4 columns responsive, redmi note 4 charging problem connecting and disconnecting, redmi 4 charging problem, fast and furious 4, how to make 4 columns in google docs, 4 queens problem using backtracking algorithm, 4 columns html, excel all combinations of 4 columns, ics 32 project 4 columns, divi filterable portfolio 4 columns, divi blog grid 4 columns, compare 4 columns in excel vlookup, nominatim postgres tuning, load data from s3 to aurora postgres, postgres tuning, gravity forms css 4 columns, solution in search of a problem y combinator, ionic 4 load data before view, 4 body problem

Tietoa työnantajasta:
( 38 arvostelua ) mackay, Serbia

Projektin tunnus: #29840248

4 freelanceria on tarjonnut keskimäärin $183 tähän työhön

SqlDevelopment

I can efficiently improve performance of required database operations because I am highly qualified SQL developer with more than 10 years of advanced experience and with exceptional expertise in professional SQL perfor Lisää

$250 USD 4 päivässä
(5 arvostelua)
3.0
khanicha

Hello, For better performance of your postgreSQL database, you should create an index of the table. Using index method will make your table performance becomes much better and faster. But it has some overhead on the Lisää

$200 USD 1 päivässä
(0 arvostelua)
0.0
mannnupatel

I have more than 14 years of IT experience with various database technologies. Working Knowledge of Postgres,MS-SQL Databases. Work experience in Postgres Performance tunning. Strong Postgres Development Skills workin Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0
adricabrelles

Hi I am a Senior DBA with more than 20 years experience in DB like Oracle, postgres, mysql ... I can help you to tune your db. Regards.

$140 USD 7 päivässä
(0 arvostelua)
0.0