Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes: > On Mon, Feb 17, 2025 at 4:36 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> It's not pulling in the TOAST storage where the bytea column lives. >> (pg_prewarm wouldn't have either, without special pushups.) > Puzzling, since I ran "PERFORM *". What if I explicitly mentioned the > bytea column's name? You'd have to do something that actually used the column's value, perhaps "md5(byteacol)" or such. (The obvious candidate would be length(), but I think that is optimized to not fetch or decompress the whole value.) regards, tom lane
