🇻🇳 vinhjaxt

Optimizing postgresql table for more than 100K inserts per second

Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:

--

My own

sdns://AAYAAAAAAAAADzEwMy4yMzIuMTIzLjExMw

Welcome, You are my visitor, Thank You! 🎉🎉

Located in alphabetical order (not prefer)

ab – slow and single threaded, written in C
apib – most of the features of ApacheBench (ab), also designed as a more modern replacement, written in C
autocannon – fast HTTP/1.1 benchmarking tool written in Node.js
baloo – Expressive end-to-end HTTP API testing made easy, written in Go (golang)

	/* Android ssl certificate pinning bypass script for various methods
	by Maurizio Siddu

	Run with:
	frida -U -f <APP_ID> -l frida_multiple_unpinning.js [--no-pause]
	*/

	setTimeout(function() {
	Java.perform(function() {
	console.log('');

	import escpos.printer as printer

	cups_conn = printer.CupsPrinter(host="192.168.2.1",port=631,printer_name="XP-58IIH") # Default CUPS printer
	cups_conn.textln("Hello CUPS!") # or any python-escpos command
	cups_conn.close()

	# remote
	./cloudflared --url tcp://127.0.0.1:3389

	# local
	./cloudflared access tcp --hostname uncertainty-saints-newark-martin.trycloudflare.com --url 127.0.0.1:3388
	# rdp to 127.0.0.1:3388

	docker run -d --name "cloudflared" \
	--restart=unless-stopped \
	--add-host=host.docker.internal:host-gateway \
	cloudflare/cloudflared:latest \
	--url http://host.docker.internal