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:

Reply via email to