Skip to content

Instantly share code, notes, and snippets.

View urlichLivonian's full-sized avatar

Vadzim Ivanitski urlichLivonian

0 followers · 2 following
  • EPAM
  • Tbilisi
View GitHub Profile
@urlichLivonian
urlichLivonian / postgresql.sh
Last active November 8, 2021 13:01 — forked from vielhuber/script.sh
PostgreSQL: Backup and restore export import pg_dump with password on command line #sql
# best practice: linux
nano ~/.pgpass
*:5432:*:username:password
chmod 0600 ~/.pgpass
# best practice: windows
edit %APPDATA%\postgresql\pgpass.conf
*:5432:*:username:password
# linux
@urlichLivonian
urlichLivonian / nginx-tuning.md
Created May 25, 2021 18:37 — forked from denji/nginx-tuning.md
NGINX tuning for best performance

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.