Re: shared_buffers advice

От: Pierre C
Тема: Re: shared_buffers advice
Дата: ,
Msg-id: op.u9nxzhryeorkce@localhost
(см: обсуждение, исходный текст)
Ответ на: Re: shared_buffers advice  (Nikolas Everett)
Ответы: Re: shared_buffers advice  (Greg Stark)
Re: shared_buffers advice  (Greg Smith)
Список: pgsql-performance

Скрыть дерево обсуждения

shared_buffers advice  (Paul McGarry, )
 Re: shared_buffers advice  (Dave Crooke, )
  Re: shared_buffers advice  (Greg Smith, )
   Re: shared_buffers advice  ("Pierre C", )
    Re: shared_buffers advice  (Nikolas Everett, )
     Re: shared_buffers advice  ("Pierre C", )
      Re: shared_buffers advice  (Greg Stark, )
      Re: shared_buffers advice  (Greg Smith, )
    Re: shared_buffers advice  (Tom Lane, )
     Re: shared_buffers advice  (Greg Stark, )
      Re: shared_buffers advice  (Greg Smith, )
      Re: shared_buffers advice  (Alvaro Herrera, )
       Re: shared_buffers advice  (Tom Lane, )
        Re: shared_buffers advice  (Alvaro Herrera, )
         Re: shared_buffers advice  (Tom Lane, )
          Re: shared_buffers advice  (Alvaro Herrera, )
           Re: shared_buffers advice  (Tom Lane, )
            Re: shared_buffers advice  (Alvaro Herrera, )
       Re: shared_buffers advice  (Greg Smith, )
        Re: shared_buffers advice  (Dimitri Fontaine, )
         Re: shared_buffers advice  (Greg Smith, )
          Re: shared_buffers advice  (Dimitri Fontaine, )
 Fwd: shared_buffers advice  (VJK, )
 Re: shared_buffers advice  (Konrad Garus, )
  [SPAM] Re: shared_buffers advice  (Ben Chobot, )
  Re: shared_buffers advice  (Cédric Villemain, )
   Re: shared_buffers advice  (Konrad Garus, )
    Re: shared_buffers advice  (Cédric Villemain, )
     Re: shared_buffers advice  (Konrad Garus, )
      Re: shared_buffers advice  (Cédric Villemain, )
       Re: shared_buffers advice  (Konrad Garus, )
        Re: shared_buffers advice  (Cédric Villemain, )
         Re: shared_buffers advice  (Konrad Garus, )
          Re: shared_buffers advice  (Cédric Villemain, )
           Re: shared_buffers advice  (Konrad Garus, )
            Re: shared_buffers advice  (Cédric Villemain, )
 Re: shared_buffers advice  (Merlin Moncure, )
  Re: shared_buffers advice  (Konrad Garus, )
   Re: shared_buffers advice  (Merlin Moncure, )
    Re: shared_buffers advice  (Greg Smith, )
     Re: shared_buffers advice  (Merlin Moncure, )
      Re: shared_buffers advice  (Greg Smith, )
       Re: shared_buffers advice  (Merlin Moncure, )
  Re: shared_buffers advice  (Scott Marlowe, )
   Re: shared_buffers advice  (Dave Crooke, )

> I think the logic you are referring to is the clock sweep buffer
> accounting
> scheme.  That just makes sure that the most popular pages stay in the
> buffers.  If your entire db fits in the buffer pool then it'll all get in
> there real fast.


Actually, I meant that in the case of a seq scan, PG will try to use just
a few buffers (a ring) in shared_buffers instead of thrashing the whole
buffers. But if there was actually a lot of free space in shared_buffers,
do the pages stay, or do they not ?


В списке pgsql-performance по дате сообщения:

От: "Ing. Marcos Ortiz Valmaseda"
Дата:
Сообщение: Re: Postgres DB maintainenance - vacuum and reindex
От: Greg Smith
Дата:
Сообщение: Re: shared_buffers advice