WAL (Write Ahead Log) Tree locations postgres=# select pg_current_wal_flush_lsn(), pg_current_wal_lsn(), pg_current_wal_insert_lsn(); pg_current_wal_flush_lsn | pg_current_wal_lsn | pg_current_w...

RMI (Remote Method Invocation) RMI is a way of calling methods on remote objects over a network connection. It is similar to RPC, but the biggest difference is that RPC deals with data structures ...

When using GCC to add breakpoint to a specific location, sometimes I am worried that this piece of code may be optimized away by the compiler. Disabling optimization can rule out my concern, but I ...

I spent quite some time today debugging a seemingly trivial problem when working with Python ThreadPoolExecutor. The code is as follows. with concurrent.futures.ThreadPoolExecutor(max_workers=8) a...

Increase the disk size of StatefulSet PVC kubectl edit pvc <pvc-name> -n <namespace> kubectl delete statefulset --cascade=orphan <statefulset_name> -n <namespace> # Then yo...

I took a deep breath when starting this blog post. Lisp is such an arcane programming language. I am not sure I will benefit from it at all. However, since pgloader is written in CL, I think I shou...

iostat is a simple tool to monitor disk activity and latency. I ran it inside an AWS EC2 instance, and output is shown below. > iostat -d -x -m 1 Device r/s rMB/s rrqm/s %rrqm...

Postgres is wonderful piece of software! Set Up Postgres Postgres documents the progress of creating and starting a postgres database in detail. Basically, it provides initdb and postgres command...

Router, LAN, WAN, NAT Each router has a private ip address and a public ip address. Router will assign private ip address to the devices behind its local area network (LAN). Use a home LAN as an ...

It claims that k8s was originally being designed for non-persistent micorservice architecture. https://www.cockroachlabs.com/blog/secure-multi-cluster-cockroachdb-calico-clustermesh/