matthiasg

Turning PostgreSQL into a queue serving 10,000 jobs per second

RDBMS-based job queues have been criticized recently for being unable to handle heavy loads. And they deserve it, to some extent, because the queries used to safely lock a job have been pretty hairy. SELECT FOR UPDATE followed by an UPDATE works fine at first, but then you add more workers, and each is trying to SELECT FOR UPDATE the same row (and maybe throwing NOWAIT in there, then catching the errors and retrying), and things slow down.

On top of that, they have to actually update the row to mark it as locked, so the rest of your workers are sitting there waiting while one of them propagates its lock to disk (and the disks of however many servers you're replicating to). QueueClassic got some mileage out of the novel idea of randomly picking a row near the front of the queue to lock, but I can't still seem to get more than an an extra few hundred jobs per second out of it under heavy load.

So, many developers have started going straight t

matthiasg

> gst-device-monitor-1.0.exe
   
   
   ...
    
Device found:

	name  : 00 Pro Capture AIO
	class : Video/Source

matthiasg

tags
Android Android Things

Set the NTP server of your android device

matthiasg

[req]
default_bits = 2048
prompt = no
default_md = sha256
req_extensions = v3_req
distinguished_name = dn

[ dn ]
C= CountryCode
ST= State

matthiasg

adb help // List all comands

== Adb Server
adb kill-server
adb start-server 

== Adb Reboot
adb reboot
adb reboot recovery 
adb reboot-bootloader

matthiasg

Upgrading SmartOS zone

Make a snapshot first! Upgrading from 2013Q1 to 2013Q3 because I needed newer nginx.

Update pkgin repository

edit the files at:

/opt/local/etc/pkg_install.conf

/opt/local/etc/pkgin/repositories.conf

matthiasg

Windows 10 Pro

Windows 10 Pro ISO

Create a fresh Windows 10 Pro ISO file with Microsofts Media Creation Tool. (I created a Windows 10 Pro 64 bit German ISO image)

Save the created image on your SmartOS global zone.

cp ... /zones/Windows10_64de.iso

matthiasg

.ProseMirror .MathBlock pre {
  background: var(--default-back);
  color: rgb(var(--default-font));
  font-size: 0.8em;
  display: flex;
  padding: 1em;
}

.ProseMirror .MathBlock {
  display: flex;

matthiasg

First create a share zfs create zones/camera

Share with access to all intranet pcs with write access as root

zfs set sharenfs='sec=none,rw=*,anon=0' zones/camera

Note: sec=none must PRECEED any following option see man share_nfs

matthiasg

const fs = require('fs')
const path = require('path')
const child_process = require('child_process')

const pnpmPath = path.resolve(__dirname, '../temp/pnpm-local/node_modules/pnpm/bin/pnpm.cjs')
const tempPath = path.resolve(__dirname, '../temp')

let argv = process.argv.slice(2)

// Simple order fix to avoid building or required a full parser (only works with the two specific parameters basically)