matejcerny on Nostr: 💡 Quick tip: When checking if an array column in the Postgres table contains a ...
💡 Quick tip: When checking if an array column in the Postgres table contains a specific element, use @> (I call it the "ice-cream" operator 😀). It's faster than using ANY. #postgres #sql #database #performance
Published at
2024-10-15 17:52:34Event JSON
{
"id": "165f31e15462e0b2ed05e73e0fc4a4bbfda11f961bbf09d19733e8411f0b69b5",
"pubkey": "f5c3f597f754f534d47b0be2b9afe263894ecdad3d639453c4abc31f40db2c23",
"created_at": 1729014754,
"kind": 1,
"tags": [
[
"t",
"postgres"
],
[
"t",
"sql"
],
[
"t",
"database"
],
[
"t",
"performance"
],
[
"imeta",
"url https://m.primal.net/LWsX.jpg",
"m image/jpeg",
"ox 1ee0da089a915b96047d833d86a814a4a28e1d4618e6519efa86a3e9808ee6f2",
"dim 1610x972"
]
],
"content": "💡 Quick tip: When checking if an array column in the Postgres table contains a specific element, use @\u003e (I call it the \"ice-cream\" operator 😀). It's faster than using ANY. #postgres #sql #database #performance\n\nhttps://m.primal.net/LWsX.jpg\n",
"sig": "66348668441d0089ca176b3dae50a427fd687c29fc4a8c328252a060b2a9c531fdc3b500f60968e3f5bf0038074444fe0ddbeb8554f0cd01410b5b288900543a"
}
