PostgreSQL

TIL

I had a PostgreSQL database query where block number was float instead of an integer. (This would not ever happen e.g. in JavaScript, but this time we were using the best programming language in the world. Python).

Instead of taking under-milliseconds the query took more than ten minutes.

I'm not sure if this is because the index match is only for integers, or if PostgreSQL is doing some other unusual behaviour. 

But this was damned hard to find.

Talks about crypto and coffee. Building onchain algo trading - check out my channels /algo-trading and /python

postgres can't efficiently use the btree index during such an implicit typecast. also, don't forget float size is bigger than int - choosing data types matters (even in mysql).

Applied AI, databases, data, vibe coding (sic.), open source, community/devrel, remote. 

itinerant businessperson. globalist.

Instead of https://dba.stackexchange.com/ I will now use @bytebot

lol, tbf, i've been dealing with databases professionally for over 20 years. ported many a postgres app to shine on mysql in the early days. still in SHOW AUTHORS; for mariadb. reviewed books (so blurb/name are on jackets, etc.)