Re: multicolumn index and setting effective_cache_size using human-readable-numbers

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: multicolumn index and setting effective_cache_size using human-readable-numbers
Date: 2016-02-29 18:05:37
Message-ID: CAEzk6ffejSAX0=NiyCPemu_8x9ErvF9ktjT38ozd+cHVeGs01g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just as a continuation of this, I can set effective_cache_size to 64MB
and it will still use the single-column index, but PG flatly refuses
to use the multicolumn index without effective_cache_size being an
unfeasibly large number (2x the RAM in the machine, in this case).

Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2016-02-29 18:06:01 Re: Only owners can ANALYZE tables...seems overly restrictive
Previous Message Rémi Cura 2016-02-29 17:56:44 bloated postgres data folder, clean up