Vignesh Ravichandran on Home

The last line of defense for those OOPS moments — so even DBAs can sleep peacefully.

Seven attempts, seven different wrong answers — lessons from setting up a local LLM.

The analytics databases optimized for queries.

I was writing an article for Infoq on the topic less spoken costs of managed databases and one question that the editor asked is how much margin RDS makes compared to running a Postgres instance on EC2?

I was trying to play with Phil’s pgtam and the first step is that to install Postgres version 16.

Abstract On a high level, the talk addressed following questions: What is Edge and why are the benefits of edge?

Abstract We talked about the importance of having a good toolset, of practicing incidents and of internally advocating database best practices to a large engineering organization.

Abstract With the advent of cloud/managed offerings, running Postgres on their own hardware is becoming rare.

Abstract This talk explores how Cloudflare uses HAProxy for health checks, load balancing and reading traffic among nodes set up with Postgres streaming replication in hot standby mode.

I kept hearing about the term wire protocol especially Postgres wire protocol in the recent days (Looking at you cockroachdb, yugabytedb - in a good way) but never really quite understood it.

I use pg_rewind for rewind a Postgres cluster which is ahead of the primary.

Citus: Distributed PostgreSQL for Data-Intensive Applications paper can be downloaded here.

TL;DR: Connect with people whom you admire.

Capturing thoughts from https://twitter.com/viggy28/status/1530800893842444289 When you are doing major DML changes, other than locks one more thing to keep in mind is replication lag.

Before I forget let me write this down here. $$ log_stament - none - all log_min_duration_statment - millisecond value When you set log_statement=none and log_min_duration_statement=1 then any statement which takes longer than 1 millisecond will be logged.

Last week, I got promoted to Engineering Manager (EM) of the Database team at Cloudflare.

I saw this pattern of a function taking optional parameters (variadic arguments) and I never understood why they do that until today.

double pointers A pointer (whose value is another variable’s address) which points to another pointer copying a pointer to another pointer copies the address copying a de-referenced pointer to another de-referenced pointer updates the value of the one to…

go run command go run command is a quick way to run go program.

context is a standard package.

From the wiki, In computing, data storage, and data transmission, character encoding is used to represent a repertoire of characters by some kind of encoding system that assigns a number to each character for digital representation.

closure is a function inside another function where you can reference variable defined in the outer function.

There are two types of variable declaration. recursively expanded variables - foo is assigned with bar which inturns assigned to ugh whose value is Huh?

I have know about the postgres wire protocol, but first I ran into streaming replication protocol.

defer is one of the unique keywords in Go.

I came across this piece of code from The Go Programming Language book. loop: for { select { case size, ok := <-fileSizes: if !

I was going through The Go Programming Language and in chapter 5 there was a section Caveat: Capturing Iteration Variables.

program1 package main import ( "log" ) func main() { done := make(chan struct{}) go func() { log.Println("done") }() <-done //wait for background goroutine to finish } program2 run nc -l 8000 on another terminal package main import ( "log" "net" ) func ma…

Initializing embedded field: The field name of an anonymous field during a struct instantiation is the name of the struct (Time) type Event struct { ID int time.Time } event := Event{ ID: 1234, Time: time.Now(), } If an embedded field type implements an i…

Concurrency channels are like typed pipes, Where you can send something from one side and receive from other side. using channel direction operator <-.

In Go, copying generally does a copy by value.

This is something new for this site.

In v6, /48 is the minimum prefix that can be advertised by the routers in the Internet.

namespaces is a Linux Kernel feature.

I have seen this term here and there.

I have used many signals with kill like SIGHUP, SIGKILL etc.

There are tools like https://tehnoblog.org/ip-tools/ip-address-in-cidr-range/ which does the job.

Disclaimer: Whatever I write here is my learnings.

This is part of my Today I Learnt series where I share whatever I am learning something new.

This article is part of my Today I Learnt.

This is a crosspost from my TIL What the heck is .PHONY in makefile?

Libpq-Postgres-Go After I started working on Postgres, I have heard this term libpq enough times, but never had a good grasp of it.

This is a guest post by Suvam Prasad (https://www.linkedin.com/in/suvamprasad/).

Understanding context in Golang through Postgres I was trying to learn Go package context especially with respect to Postgres.

Disclaimer: This book was published in 1989.

TLDR; A short book on Product Development and especially explains how B2C (especially social media) companies make their users hooked on their products.

Part 1 is about Master Internal Triggers which talks about that distractions are mainly caused by discomfort.

Here is a list of books which I really enjoyed reading.

Chapter 1 is Good Returns which explains the Dangers and Rewards of Giving more than you get with multiple examples.

This aricle is inspired by Give and Take by Adam Grant.