Narcis Iulian Paun alpenzoo

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:


	function compose(...fnArgs) {
	const [first, ...funcs] = fnArgs.reverse();
	return function(...args) {
	return funcs.reduce((res, fn) => fn(res), first(...args));
	};
	}

	<?php
	// PHP Simple Proxy
	// Responds to GET or POST

	//I would use session or other checks to prevent abuse.
	//do not put it in the wild without limiting usage to a domain, list of urls etc

	$url = ($_POST['url']) ? $_POST['url'] : $_GET['url'];
	$url = urldecode($url);
	if(empty($url)){

	<?php
	/ Encryption setup CODE /
	$key = openssl_pkey_new(array('private_key_bits' => 2048));

	$private_key = openssl_pkey_get_details($key);
	$public_key = $private_key['key'];

	echo "<pre>";
	print_r($private_key);
	echo "</pre>";

	301 moved permanently (redirect):
	<?php
	header('HTTP/1.1 301 Moved Permanently');
	header('Location: http://www.example.com');
	die();
	?>

	302 moved temporarily(redirect):
	<?php
	header('Location: http://www.example.com');

	start .\chrome.exe --disable-web-security --ignore-certificate-errors --user-data-dir="D:/Chrome"
	exit