On Tue, Sep 6, 2016 at 11:22 PM, Claudio Freire <klaussfre...@gmail.com> wrote: > CREATE INDEX could also allocate 218GB, you just need to index enough > columns and you'll get that. > > Aside from the fact that CREATE INDEX will only allocate what is going > to be used and VACUUM will overallocate, the potential to fully > allocate the amount given is still there for both cases.
I agree with that, but I think there's a big difference between allocating the memory only when it's needed and allocating it whether it is needed or not. YMMV, of course, but that's what I think.... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers