Sebastian Webber sebawebber

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.

Exposing your clipboard over SSH

I frequently administer remote servers over SSH, and need to copy data to my clipboard. If the text I want to copy all fits on one screen, then I simply select it with my mouse and press CMD-C, which asks relies on m y terminal emulator (xterm2) to throw it to the clipboard.

This isn't practical for larger texts, like when I want to copy the whole contents of a file.

If I had been editing large-file.txt locally, I could easily copy its contents by using the pbcopy command:

Hey! I saw this has been indexed by the search engines. It is a first draft of a post I ended up publishing on my blog at: Scaling PostgreSQL With Pgpool and PgBouncer

Thanks for stopping by!

PostgreSQL and Pgpool Architecture

	CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
	RETURNS json
	IMMUTABLE
	LANGUAGE sql
	AS $$
	SELECT ('{'\|\|string_agg(to_json(key)\|\|':'\|\|value, ',')\|\|'}')::json
	FROM (
	SELECT * FROM json_each(data)
	UNION ALL
	SELECT * FROM json_each(insert_data)

	def s3_form_tag(options = {})
	bucket = options[:bucket]
	access_key_id = options[:access_key_id]
	secret_access_key = options[:secret_access_key]
	key = options[:key] \|\| ''
	content_type = options[:content_type] \|\| '' # Defaults to binary/octet-stream if blank
	redirect = options[:redirect] \|\| '/'
	acl = options[:acl] \|\| 'public-read'
	expiration_date = options[:expiration_date].strftime('%Y-%m-%dT%H:%M:%S.000Z') if options[:expiration_date]
	max_filesize = options[:max_filesize] \|\| 671088640 # 5 gb