Quick Links

Re: To keep indexes in memory, is large enough effective_cache_size enough?

From:	Kaixi Luo <kaixiluo(at)gmail(dot)com>
To:	david(dot)rowley(at)2ndquadrant(dot)com
Cc:	samruohola(at)yahoo(dot)com, sk(at)zsrv(dot)org, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject:	Re: To keep indexes in memory, is large enough effective_cache_size enough?
Date:	2018-09-19 10:12:35
Message-ID:	CAHo5iyhUqxnHYfs9CdxEjRxP25tp4skmcoq-CSH2tk1AOeF4EQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Does a large shared_buffers impact checkpoint performance negatively? I was
under the impression that everything inside shared_buffers must be written
during a checkpoint.

In response to

Re: To keep indexes in memory, is large enough effective_cache_size enough? at 2018-09-19 10:11:08 from David Rowley

Responses

Re: To keep indexes in memory, is large enough effective_cache_size enough? at 2018-09-19 10:23:18 from David Rowley

Browse pgsql-performance by date

	From	Date	Subject
Next Message	David Rowley	2018-09-19 10:23:18	Re: To keep indexes in memory, is large enough effective_cache_size enough?
Previous Message	David Rowley	2018-09-19 10:11:08	Re: To keep indexes in memory, is large enough effective_cache_size enough?