1818 shaares
37 private links
37 private links
17 results
tagged
tuning
Remplacer NOT IN soit par NOT EXIST ou un left outer join where NULL
Vraiment intéressant sur le tuning des instances EC2
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.
