https://github.com/F2/F2s-sourcemod-plugins

All here, as a package or individually

I think this is a common misconception, the high ping of one (or even most) other players won't affect your experience by itself. John Carmack got it mostly right back in 1996.
The "teleporting timmy" example is way more annoying for other players, but a ping limit doesn't fix that.

The rule shouldn't exist at all.

A linux-based TF2 server started with -autoupdate will auto-restart if you send a kill signal. So the simplest thing to make the above suggestion work is to add a crontab entry that runs:

killall srcds_linux

In

tf/logs

He backed out in S3 :( Sadly, couldn't do it despite being cut from the team

https://demos.tf/about

I think most or even all of the demos are stored on Hetzner servers in Germany. Some ISPs love to fight with them over bandwidth and refuse to set up peerings, causing slow speeds for that ISP's customers.

He's a lucky boy

I think you can blame the driver that was behind, on the dirty side of the track, missing the apex, understeering into his opponent.

Hehe, those are some cool queries, I was hoping you were just missing some indexes or something, but it looks like you got all that covered.

An on-the-fly aggregation like the peers is always going to be challenging, especially since you're trying to find the top 100 players most played with/against.
One thing I would consider, is to move "log_wlt" and "player_last" from views to materialized views (unlike a view these need their own indexes). You could update these materialized views (concurrently) after a new batch of log files is imported. This might improve part of the peers query.

I'll take a look if you share some slow queries (use postgres' slow query logger) and the entire DDL (pg_dump --schema-only) and put it in a github gist.

Steam condenser has ruby, java and PHP implementation to do this.

https://github.com/koraktor/steam-condenser

Demos.tf was unchecked for that reservation on na.serveme.tf

I've checked the zip for the reservation you played in, there are 4 maps played on villa in it, follow det-'s advice to find the link to the zip file.

https://www.teamfortress.tv/59525/cant-join-any-servers-max-players-1

That thread has like 1/3 of the words and the solution.

Our Dallas and Chicago servers marked with (Anti-DDoS) are at NFOservers, so those should ping identically to something you rent yourself. In both Dallas and Chicago we also have non-NFO servers, which might ping better or worse depending on routing.

tony, since you're from Mexico, I suggest trying NFOservers in Dallas. You can try one for free at https://na.serveme.tf (they're called serveme.tf NFO Dallas #1-8 (Anti-DDoS)), that way you know what kind of ping to expect if you rent one yourself at NFOservers.