1817 shaares
37 private links
37 private links
1200 results
tagged
PostgreSQL
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.