1818 shaares
37 private links
37 private links
For columns of type bytea which store image data (PDFs, JPGs, etc) would it
speed up the ANALYZE process to SET STATISTICS = 0?
Yes. I'd suggest also looking at ALTER TABLE ... SET STORAGE to avoid
having Postgres try to compress those columns, which is useless waste of
CPU cycles, since those formats already compress.