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

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Jim Mlodgenski <jimmy76(at)gmail(dot)com>
Cc: 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 14:07:56
Message-ID: CAEzk6fcDRT9eANnxHKEB-Jrnq1TXYWp2RqjpKMi5c8tkgSiX8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29 February 2016 at 14:06, Jim Mlodgenski <jimmy76(at)gmail(dot)com> wrote:
> No they are not the same. When you don't include a unit for
> effective_cache_size, it defaults to page size so you're saying 2146435072 *
> 8K

Hah.

Thanks Jim, like I said I was sure I'd be missing something :)

Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2016-02-29 14:15:21 Re: Only owners can ANALYZE tables...seems overly restrictive
Previous Message Jim Mlodgenski 2016-02-29 14:06:57 Re: multicolumn index and setting effective_cache_size using human-readable-numbers