mowings

https://www.reddit.com/r/PostgreSQL/comments/dqg8qs/some_tips_on_optimizing_postgres_on_amazon/

https://explain.depesz.com/

Create a builder

docker buildx create --use

Build and push

docker buildx build --platform linux/arm64/v8,linux/amd64 . -t foo:latest --push

List all Git repository objects by size

Summary
Example

Summary

Bash script to:

Iterate all commits made within a Git repository.

List base image names and tags

curl https://docker.example.com/v2/_catalog.           # List repos (base image names)
curl https://docker.example.com/v2/myimage/tags/list   # List image tags

Ok for image names to have forward slashes

To get all images in a registry, call the catalog API, then call tags/list for each result.

Use UPDATE SKIP LOCKED to manage queue concurrency

DELETE FROM queue
WHERE itemid = (
  SELECT itemid
  FROM queue
  ORDER BY itemid
  FOR UPDATE SKIP LOCKED
 LIMIT 1

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant desired access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

	Source: https://wiki.teltonika-networks.com/view/Mobile_Signal_Strength_Recommendations

	RSRP
	RSRP Signal strength Description
	>= -80 dBm Excellent Strong signal with maximum data speeds
	-80 dBm to -90 dBm Good Strong signal with good data speeds
	-90 dBm to -100 dBm Fair to poor Reliable data speeds may be attained, but marginal data with drop-outs is possible. When this value gets close to -100, performance will drop drastically
	<= -100 dBm No signal Disconnection

	RSRQ

	# kube get pod logs by pod name
	function podlogs() {
	k logs -f $(k get pods \| grep "$1" \| cut -d ' ' -f 1)
	}