TIL: crystal-pg low performance with SSL

Fryguy · October 16, 2025, 5:02pm

pgconn/config.go

cf865756e


      
          	// Match libpq default behavior
          	if sslmode == "" {
          		sslmode = "prefer"
          	}
          	if sslsni == "" {
          		sslsni = "1"
          	}
          
          	tlsConfig := &tls.Config{}
          
          	if sslnegotiation == "direct" {
          		tlsConfig.NextProtos = []string{"postgresql"}
          		if sslmode == "prefer" {
          			sslmode = "require"
          		}
          	}

…is kind of interesting - seems they override to other modes. based on certain other properties. Unless I’m reading this wrong, is pgx more of a complete rewrite of libpq as opposed to using libpq - This code appears to be emulating what libpq does, but if it’s not actually using libpq I’m not sure it’s an apples-to-apples comparison.

Topic		Replies	Views
[Help] Optimization and code review Learning Resources	13	678	August 15, 2021
Crystal vs Go: Notes and Reflections Learning Resources	3	7841	March 3, 2021
Multithreaded Crystal initial thoughts Offtopic	38	8019	February 21, 2024
There is a way to optimize this program? Help & Support	62	2286	January 18, 2026
Build with --release performance is slow than the 2017 crystal version? Help & Support	16	877	June 13, 2022

TIL: crystal-pg low performance with SSL

Related topics