Postgres Pro
Downloads
Home   >   mailing lists

Re: multicolumn index and setting effective_cache_size using human-readable-numbers - Mailing list pgsql-general

From Geoff Winkless
Subject Re: multicolumn index and setting effective_cache_size using human-readable-numbers
Date
Msg-id CAEzk6fcDRT9eANnxHKEB-Jrnq1TXYWp2RqjpKMi5c8tkgSiX8w@mail.gmail.com
Whole thread Raw
In response to Re: multicolumn index and setting effective_cache_size using human-readable-numbers  (Jim Mlodgenski <jimmy76@gmail.com>)
Responses Re: multicolumn index and setting effective_cache_size using human-readable-numbers  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
Tree view 
On 29 February 2016 at 14:06, Jim Mlodgenski <jimmy76@gmail.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

pgsql-general by date:

Previous
From: Jim Mlodgenski
Date:
Subject: Re: multicolumn index and setting effective_cache_size using human-readable-numbers
Next
From: Guillaume Lelarge
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive