On Mon, Sep 7, 2026 at 10:54 AM Hannu Krosing <[email protected]> wrote: > > The slowness of 1GB datum test in previous email is likely just > because of more levels in toast inex, as it should fit well into > shared buffers > > table_name │ table_size │ toast_table_size │ > toast_index_size │ > ──────────────────────────┼──────────────┼──────────────────┼──────────────────┼ > public.largeplaintoast │ 11527708672 │ 11399487488 │ > 125042688 │ > public.largedirecttoast │ 11495727104 │ 11492515840 │ > 8192 │ > > Time: 8.935 ms > dtoast=# show shared_buffers; > shared_buffers > ──────────────── > 8GB > (1 row)
Looks like this was caused by something else pushing data out of shared buffers. Once thee index (and most data) was there, plain toast was as fast as direct toast also on 1GB reads.
